2017-05-16 (first published: 2017-05-05)
908 reads
2016-10-07 (first published: 2016-09-20)
1,548 reads
2015-10-21 (first published: 2013-12-26)
4,054 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,456 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,520 reads
2014-01-21 (first published: 2013-12-28)
2,249 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,302 reads
2013-12-02 (first published: 2013-11-18)
1,722 reads
Blogs
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Forums
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
T-SQL in SQL Server 2025: Fuzzy String Search I
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?