2015-05-01 (first published: 2013-08-13)
3,708 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,393 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)
596 reads
2011-09-15 (first published: 2011-09-05)
2,889 reads
2011-08-05 (first published: 2011-07-23)
2,151 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
Weekly reading #15
By damianwidera
SQLDay 2019 is gone. The Data Community.PL has now a new goal – it...
Last Weeks Reading (2019-05-26)
By KamilN78
It was tremendously extensive week for me (a week ago) when I spent time...
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Streamlining a Power BI Solution
Comments posted to this topic are about the item Streamlining a Power BI Solution
Proverbial Tree Barking
Hi All, I'm just after a pointer really. I've had an idea. I want...
Ask SSC