Recently I was asked by a client if the Stretch table feature will work with SQL Express and if so what the limitations are. This seemed like an […]
Decimal datatype rounding
Recently I was asked this question about how decimal is rounding off values when doing a simple calculation. The question was I am not able to find why […]
Identity value skips after restart
Recently a client of mine had complained to me about an issue they were facing when restarts happen on a system. After a restart the system skips the […]
Forcing Columnstore batch mode on Select * type query
Recently at a consulting project while working with tabular model I was asked about how we can force SQL Server to use batch mode on Columnstore index when […]
administration / Misc / TSQL
Weird ways I explain seemingly complicated SQL topics
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. […]