2017-05-16 (first published: 2017-05-05)
920 reads
2016-10-07 (first published: 2016-09-20)
1,569 reads
2015-10-21 (first published: 2013-12-26)
4,066 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,490 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,537 reads
2014-01-21 (first published: 2013-12-28)
2,259 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,317 reads
2013-12-02 (first published: 2013-11-18)
1,731 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers