Get All Foreign Key names and Tables referenced
This script lists all the foreign keys ,the referenced and the referencing tables , along with the column information.
2007-07-09 (first published: 2006-10-04)
308 reads
spaceused by user tables
to figure out space used by tables. I have seen different versions of them .. here is a very simple effective one!!!
2003-04-28
85 reads
truncate logs regularly
It is a painful experience for all us administrators to truncate logs regularly. I just created a job to executesp_msforeachdb "use ?; backup log ? with truncate_only ; dbcc shrinkfile(2,5)"on all the servers at frequent intervals. It has saved me a lot of time. hope it helps you too.n.b: I assume that file id 2 […]
2003-04-18
308 reads
Blogs
What goes around comes around : T-SQL Tuesday #129
I almost died. I’m sure a lot of you already know this but just...
My T-SQL Tuesday #129 Time Capsule
By Steve Jones
This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...
Azure Database Administrator
By Arun Sirpal
Recently I found out that I passed the BETA exam for Azure Database Administrator...
Forums
Send me an email if this job run longer than 30 minutes
Hi I have a job that I need to be notified/emailed if it runs...
Time out expired on the application side
Hi I have an application that is timing out i run the query...
Ask SSC