Search for a specified GUID (or its part) in all databases (updated)
This procedure searches for the specified GUID (or its part) in all (or selected one) databases
2008-03-06 (first published: 2008-01-24)
970 reads
Scripts
Db files size per directory
This procedure displays amount of disk space used by database per directories.
2008-02-29 (first published: 2008-01-14)
940 reads
Random varchars
This procedure generates a list of random varchars (8 charactes length, only letters - lower or upper case).
2008-02-28 (first published: 2008-01-14)
675 reads
2008-02-27 (first published: 2008-01-21)
1,053 reads
2008-02-25 (first published: 2008-01-15)
937 reads
Sorted views in 2005 and TOP clause
These examples show how You can circumvent the problem with not working TOP 100 PERCENT and ORDER BY in views.
2008-02-22 (first published: 2008-01-22)
1,304 reads
2008-02-21 (first published: 2008-01-09)
2,009 reads
2008-02-18 (first published: 2007-12-27)
818 reads
2008-02-14 (first published: 2007-12-20)
1,044 reads
2008-02-13 (first published: 2007-12-18)
1,757 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers