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)
312 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
90 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
314 reads
Blogs
Using Git Prune–#SQLNewBlogger
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
Microsoft Purview new data governance features
By James Serra
Starting last week is a rollout of the public preview of a new and...
SQL Database Administration: Not For Everyone (But Maybe It’s for You)
Let's get one thing straight: database administration isn't the most glamorous tech job out...
Forums
Do I need a recursive query for this? bill of materials (sort of)
I am working on a data warehouse project for a bakery. For the most...
Do I need a recursive query for this? bill of materials (sort of)
I am working on a data warehouse project for a bakery. For the most...
Create Copy of DB in same server.
Hi I want to create a copy of a DB on the same server....
Question of the Day
Restoring the Resource Database
How can I restore a version of the Resource Database in SQL Server 2022?
See possible answers