2017-05-16 (first published: 2017-05-05)
853 reads
2016-10-07 (first published: 2016-09-20)
1,434 reads
2015-10-21 (first published: 2013-12-26)
3,938 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,431 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,499 reads
2014-01-21 (first published: 2013-12-28)
2,220 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,268 reads
2013-12-02 (first published: 2013-11-18)
1,692 reads
Blogs
Daily Coping 26 Sep 2022
By Steve Jones
Today’s coping tip is to enjoy photos from a time with happy memories. On...
Daily Coping 23 Sep 2022
By Steve Jones
Today’s coping tip is to notice what you are feeling without any judgment. Today...
Snowflake – Where is the explain/execution plan?
By Arun Sirpal
Whatever your database background is you will have heard of an execution / explain...
Forums
Seggregating access within a database to users
For some folks that have gotten used to working in Oracle where a user...
Replication Error on identity Column : Transactional Replication
I have manually deleted data from a subscriber replicated table, and broken replication....
Two fact tables related
Hi all, I have a couple of modelling questions using several star schemas. There...
Ask SSC