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 […]
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 […]
Snapshot isolation level when database is set to read only.
Recently there was a question posted on #sqlhelp about why a database switched to Snapshot isolation level when you make it read only and then reverts back to […]
administration / Errors / TSQL
Cannot use row granularity hint on the table
Got approached with the below error message recently and thought it might be an interesting problem to look into. ProgrammingError((\’42000\’, 651, \'[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot use […]
administration / MSBI / MSSQL / TSQL / Uncategorized
#sqlhelp | should you remove indexes from tables before ETL?
Starting today we are introducing a new type of blog content which covers questions from #sqlhelp. We pick random questions from the feed and try to cover them […]
Can we use in-memory oltp instead of columnstore index for DW queries
Recently when having a chat with a client I was asked if it will be a good idea to replace a view with a static in memory table […]