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)
311 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
88 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
310 reads
Blogs
Amazon RDS Custom for SQL Server – A new beginning
By AnupWarrier
Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was...
Getting Started with the Advent of Code as a #SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Your next step in the cloud
Over the last nine months I’ve presented (virtually) eleven times on a variety of...
Forums
Issue when joining 3 temp tables
Hey everyone, I have an issue joining 3 temp tables. I have such tables...
Row limit for Updates before transaction log fills up
Hello SSC, I hope everyone is staying safe and healthy. I am using SQL...
Changing the Excel Rendering format???
JHi I was wondering if anyone knew how I can change the Excel rendering...
Ask SSC