2015-05-01 (first published: 2013-08-13)
3,731 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,211 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,485 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)
641 reads
2011-09-15 (first published: 2011-09-05)
2,897 reads
2011-08-05 (first published: 2011-07-23)
2,172 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,369 reads
Blogs
Book Review: Lights Out
By Steve Jones
I have always been interested in GE since I was a kid. My best...
A Successful Blogger on Making the Switch
By todd-32417
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...
Login Timeouts
I was recently approached at work about a company that was seeing tons of...
Forums
Oracle: ORA-01843: not a valid month
Hi I have the following query which works fine in Oracle SQL Developer. When...
SQL Server internal variable with DML type
Can you advice how to retrieve the DML type a query is running? Does...
How to Convert Oracle SQL to T-SQL
Hello Community, I have been given a challenge of converting the following SQL code...
Ask SSC