2015-05-01 (first published: 2013-08-13)
3,723 reads
Display the SELECT statement for any table
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
3,201 reads
Display the number of days since last Database backup.
A simple T-SQL script to display the number of days since the last database backup.
2013-08-07 (first published: 2013-07-29)
1,404 reads
sp_MSforeachtable:Add SQL objects to multiple database on a server.
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
628 reads
2011-09-15 (first published: 2011-09-05)
2,892 reads
2011-08-05 (first published: 2011-07-23)
2,162 reads
A simple SysProcess query
A quick and simple SysProcess query which will display most of the common parameters of interest.
2011-07-28 (first published: 2011-07-23)
1,365 reads
Blogs
Getting the Proc Code–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Running SQL Server in Google Cloud Platform
By Daniel Janik
On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows...
More ADLS Gen2 enhancements
By James-Serra
On the heels of More Azure Blob Storage enhancements come more enhancements for Azure...
Forums
Limitation on a file size import
Is there a restriction of file size that can be imported into SQL? 5...
How to change the Scan to Seek and optimize
Hello, Attached sample query and actual plan, I want to further optimize the query...
Availability Groups with Docker Containers
Comments posted to this topic are about the item Availability Groups with Docker Containers
Ask SSC