2015-05-01 (first published: 2013-08-13)
3,748 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,212 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,563 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)
651 reads
2011-09-15 (first published: 2011-09-05)
2,898 reads
2011-08-05 (first published: 2011-07-23)
2,183 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,370 reads
Blogs
Advent of Code 2022
By Zikato
Foreword Advent of Code is an annual event in which participants solve a series of...
Daily Coping 8 Dec 2022
By Steve Jones
Today’s coping tip is to be curious. Learn about a new topic or an...
#PowershellBasics: Warnings and how to hide them.
One of my favorite parts of having a new job is that I learn...
Forums
blank page
Hi guys! The topic "Connect to SQL Server with Python to Create Tables, Insert...
how to keep two databases with different collation on one instence
hi, i want to keep two databses with diffrent collation on one instence of...
The Enterprise Roadmap to Reducing Costs (While Increasing Value)
Comments posted to this topic are about the item The Enterprise Roadmap to Reducing...
Ask SSC