Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!
2009-05-29 (first published: 2009-05-05)
934 reads
2009-05-27 (first published: 2009-04-30)
2,617 reads
2009-05-22 (first published: 2009-04-28)
3,838 reads
The function is used to find non-printable ASCII characters in an input string.
2009-05-21 (first published: 2009-04-24)
2,966 reads
Lists the Databases and their Backups status in a neatly formatted HTML Email
2009-05-19 (first published: 2009-04-23)
2,984 reads
2009-05-14 (first published: 2009-04-08)
1,996 reads
Needed to return the week ending date as Sunday for daily transactions multiple times, for several aggregate reports. This function returns the last Sunday for past or future weeks.
2009-05-11 (first published: 2009-04-15)
665 reads
This script will display information about the instance(s) on your cluster. Name of nodes, active node and drive letters of the resources
2009-05-08 (first published: 2009-04-15)
1,419 reads
2009-05-07 (first published: 2009-03-27)
1,615 reads
International Applications require timezone handling for different users Here is how to do this with SQL.
2009-05-06
4,167 reads
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Comments posted to this topic are about the item How Can SQL Server Detect...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers