2017-05-16 (first published: 2017-05-05)
809 reads
2016-10-07 (first published: 2016-09-20)
1,270 reads
2015-10-21 (first published: 2013-12-26)
3,842 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,424 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,494 reads
2014-01-21 (first published: 2013-12-28)
2,207 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,255 reads
2013-12-02 (first published: 2013-11-18)
1,678 reads
Blogs
What is the CONTROL permission?
One of the most powerful permissions available in SQL Server is control. But what...
Daily Coping 19 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1)
By Kevin3NF
Welcome to a new year, and a new look at what I’ve learned in...
Forums
Measure Latency for Readonly Replica in AOAG
I've SQL 2017 Read Scale availability group setup in our test environment(AOAG configured on...
XML Openrowset column Issue
Morning , I'm having an issue returning any records from an xml file, using...
Deadlock - What to do next?
Hi, I have a job that keeps getting a deadlock victim error and fails....
Ask SSC