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
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
to figure out space used by tables. I have seen different versions of them .. here is a very simple effective one!!!
2003-04-28
89 reads
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
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
I am very excited and lucky to be speaking once again at SQLBits along...
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Hello everyone I hope everyone's ok. I have this query and I'm trying to...
what are the best books to become a SQL developer?
what are the best books to become a DBA SQL?