Forcing Execution Plan
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)
11,284 reads
SQL Toast
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,700 reads
Merge outputs of perfmon and profiler to get a great view
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,176 reads
SQL Server Statistics
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,597 reads
Blogs
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
A New Word: Jouska
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
PGSQL Phriday #009: On Rollback
The invitation this month for #PGSqlPhriday comes from Dian Fay. The topic is pretty...
Forums
puzzeled with "exec sp_cursor 180150007,40,1"
I've noticed in one of our applications a cursor uses operation 40 and that...
Not wanting to use a Cursor, but...
Ok, need someone to talk me off the cursor ledge on this one. I...
Better Communication Through Less Messaging
Comments posted to this topic are about the item Better Communication Through Less Messaging
Ask SSC