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)
307 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
84 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
306 reads
Blogs
What the ???? T-SQL Tuesday #120
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...
First Time Speaking at PASS Summit
By Bert Wagner
This week, I filmed my experience as a first time speaker at PASS Summit...
Azure SQL Best Practices?
By Arun Sirpal
A way to enforce good practice and standards is by Azure Policy. As stated...
Forums
Limiting the Data Frame
Comments posted to this topic are about the item Limiting the Data Frame
Micro Credentials
Comments posted to this topic are about the item Micro Credentials
CheckDB on VLDB, Geography data type
I've narrowed down a DBCC CheckDB issue to a set of tables with Geography...
Ask SSC