Delete All Database User Accounts for a Given Server Login
Easily and quickly delete all database accounts even if they don't have the same name as server login.
2015-05-05 (first published: 2013-07-18)
6,108 reads
Find Stored Procedures and Functions That Reference Certain Tables
Find any code objects that interact with a given table/view, or call another given code object.
2015-04-10 (first published: 2013-07-05)
4,585 reads
Defrag All Indexes On a Database
Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.
2012-05-25 (first published: 2012-05-15)
2,856 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