2017-05-16 (first published: 2017-05-05)
876 reads
2016-10-07 (first published: 2016-09-20)
1,481 reads
2015-10-21 (first published: 2013-12-26)
3,991 reads
Determine when a Stored Procedure was created and last altered
Determine when a Stored Procedure was created and last altered.
2015-02-25 (first published: 2013-12-26)
3,436 reads
Dynamically create drop user statistics scripts
Generate script to drop any unwanted user created statistics.
2015-02-24 (first published: 2013-12-26)
1,505 reads
2014-01-21 (first published: 2013-12-28)
2,232 reads
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
2014-01-06 (first published: 2012-01-26)
4,278 reads
2013-12-02 (first published: 2013-11-18)
1,701 reads
Blogs
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Forums
SQL Window Functions Series: LAG() and LEAD()
Comments posted to this topic are about the item SQL Window Functions Series: LAG()...
Breaking Biometrics
Comments posted to this topic are about the item Breaking Biometrics
Attaching Databases
Comments posted to this topic are about the item Attaching Databases
Ask SSC