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)
935 reads
2009-05-27 (first published: 2009-04-30)
2,618 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,968 reads
Lists the Databases and their Backups status in a neatly formatted HTML Email
2009-05-19 (first published: 2009-04-23)
2,985 reads
2009-05-14 (first published: 2009-04-08)
1,997 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)
667 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,168 reads
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Comments posted to this topic are about the item Hyperscale Replicas I
Comments posted to this topic are about the item The End of Summer
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers