SQL Toast

Very rarely there is a need to force an execution plan and even more rarely we should be doing it....

2018-07-30 (first published: 2018-07-20)

13,199 reads

Send SMS from SQL Server

We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...

2014-03-31

1,949 reads

There is a way by which we can merge the .trc and .blg files to get a great view as...

2013-10-17 (first published: 2013-10-09)

6,327 reads

INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....

2013-09-29

3,932 reads

You could be tolerating limited reporting because there isn’t an off the shelf solution...

A while back I wrote a quick post on setting up key mappings in...

In 100 years a lot of what we take to be true now will...

Comments posted to this topic are about the item Lots of FKs

Comments posted to this topic are about the item Real-time On-prem SQL Server Data...

Comments posted to this topic are about the item Can You Let Go of...

In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?