2015-05-01 (first published: 2013-08-13)
3,711 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,196 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,395 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)
605 reads
2011-09-15 (first published: 2011-09-05)
2,891 reads
2011-08-05 (first published: 2011-07-23)
2,152 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,364 reads
Blogs
Trouble writing? Join the club. #JustWriteTech
By Jen McCown
I was talking with a couple of excellent SQL people* recently, and we were bemoaning...
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live...
SQL Server 2019 on Docker no longer runs as root by default
In my home lab I have an Ubuntu virtual machine that runs both SQL...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
how to list index corresponding to statistics using select statement
Hi , with query bellow I can list DTA statistic that is not updated...
Get files based on SQL results
I have a sql task which queries a database and returns a result set...
Ask SSC