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,411 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)
629 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
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL Query - FULL JOIN multiple tables but return NULL results
Good day! Need help with my sql query code; first FULL JOIN "ILEtransfer" no...
Coping with a working life as an imposter
Comments posted to this topic are about the item Coping with a working life...
SQL Select with condition
Hi, In my sql table, there is a column which have string of text...
Ask SSC