2015-05-01 (first published: 2013-08-13)
3,728 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,205 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,442 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)
634 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
Behavior of numeric data types with ”
As we all know, there are various numeric data types, such as TINYINT, INT,...
Daily Coping 5 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Microsoft Ignite Announcements 2021
By James-Serra
Microsoft Ignite has always announced many new products and new product features, and this year...
Forums
Golden Goose Outlet too
Black women are constantly being policed in this way: from what we wear and...
shared datasets and cache refresh option
hi guys! Problem: 1) Every time I overwrite an existing shared dataset (with a...
Question on report server database
Hi, We just installed SQL Server 2019 on a new server and moved...
Ask SSC