Over the years I have accumulated some seemingly weird ways to explain topics within SQL Server. Usually in a training I find that participants are able to relate […]
Rebuild all indexes and statistics on Azure SQL database
Since Azure SQL databases are limited in what they expose to the management studio client we miss out on a lot of features within SSMS that we could […]
String split using full text indexes
Recently I needed a way to extract keywords from email messages in order to create a list of noise words for a spam filter as well as implement […]
administration / Database / MSSQL / TSQL
Set based vs row by row (procedural code)
I was reading a blog about how to write procedural code today ( link below) and wanted to take a moment to explore another approach just to provide […]
administration / Database / MSSQL / TSQL
Actual vs Estimated plan and the use of Time to arrive at the best plan
I came across a comment on linkedin today about the difference between the actual and estimated execution plan in SQL Server and how it is used to determine […]
administration / Database / MSSQL / TSQL
Plan reuse for conditional statements in MS SQL Server
I was asked this question the other day on linkedin and figured it might be good to write a post on it considering the confusion around the topic. […]
administration / Database / MSSQL / TSQL
The Log buffer – improving performance for write log activity
The log buffer is the space in the memory where transactions are written to before they are committed to disk. The size of the Log buffer pool is […]
administration / Database / MSSQL / TSQL
Script to Enable and use CDC in MS SQL Server
Recently at a training I was asked about CDC and while this script is old and previously published I couldn’t find it within the blog after I migrated […]
administration / Database / MSSQL / TSQL
Improving the performance of functions
Recently I had to employ functions to perform a kind of name resolution on a column within the database. The database had a user table with usr_name and […]
Getting all values when input parameter is NULL and still get IX seek behavior!!
Recently while working on a requirement for a client we came across this scenario. It’s fairly widely used although I would not recommend it. The example is in […]