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 […]
Charting controls: – Things to keep in mind – Part 2
In this second part of the series on charting controls we take a look at a few lesser known charting controls. You can view the first part of […]
Charting controls: – Things to keep in mind
I often do a number of trainings on MSBI and PowerBI and one of the tasks we do during the course is “I would ask all participants to […]
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 […]
Calculating Pi in MS SQL Server
PI is a very commonly used mathematical constant, in fact it is probably more famous than the equation E=MC2. We might not find a lot of use for […]
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 […]