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 […]
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 […]
Adding a Quintillion
An interesting problem was asked on #Sqlhelp recently about adding very large numbers, in excess of 20 digits in SSAS tabular model. While most of us will find […]
Azure / MSSQL / TSQL / Uncategorized
Query to find size of tables in Azure database
Quick and dirty way to find the size of all tables in a azure database. DROP TABLE #list DROP TABLE #data GO CREATE TABLE #data ( name VARCHAR(100) […]
Analyze Actual Execution Plan in SSMS
This might be a hidden gem in SSMS that most people aren’t aware of so I figured I would post about it. I recently used this feature to […]
Plan reuse under Simple parameterization
Interesting problem came up today on #sqlhelp. A trivial plan results in multiple prepared Execution plans. To begin with let’s understand parameterization quickly. It is a mechanism that […]