So we have a new DMF to allow us to view details for the page something I do very often during trainings using the DBCC Page Utility. I […]
SQL 2019:- APPROX_COUNT_DISTINCT
A function that might prove useful when querying very large datasets, it provides a count of distinct values for any column in the database except text,ntext , image […]
administration / Errors / TSQL
To accomplish this action, set property PartitionScheme
SSMS 18.X error when creating NonClustered index This seems to be a bug in SSMS as the index can be created using TSQL just fine here is the […]
Installing SQL 2019 CTP 2.0
It’s finally out and it’s going to be awesome but there is only one way to find out, so here is the very first step, installing SQL SERVER. […]
Why does the query throw NULL and Schrödinger’s cat?
An interesting problem came up in #SQLHelp today. The query is fairly simply and aims to generate a random distribution of value 1,2 and 3. I am not […]
administration / MSSQL / TSQL
The use of table valued parameters and its performance impact – analysis
I read a very informative post today on Linkedin about how developers sometime don’t understand the impact of using table valued parameters in a stored procedure. A table […]
RECOMPLE behavior the difference between OPTION ( RECOMPILE ) AND WITH RECOMPILE
An interesting problem was posted on #SQLHelp the other day about using the QueryHint OPTION(RECOMPILE). If you are not sure about how recompile works here is a quick […]
Smart Log backups SQL Server 2017
Smart log backups is a feature introduced in SQL 2017 to allow DBAs to manage the transaction log growth better. Before we go into details it might be […]
Changing Default port number for SQL on Windows/Linux Install
Changing the default port number of a SQL installation is one of the most basic post install steps performed. It is mainly used to make intrusion more difficult […]
administration / Azure / Database / Errors / MSSQL
Online Indexes Failures in Azure for VLDBs
Recently we had a requirement that was caused by a very unique situation. A table with a column of datatype nvarchar(max) was inadvertently populated with some text in […]