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
New Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress
My new course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available on Pluralsight here!...
Step By Step Installation of SQL Server 2019 with all features
By Rohit Garg
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...
Step By Step Installation of SQL Server 2019 with all features
By Rohit Garg
[MSSQLFUN & Decote ITeS becomes a family of 1500 individuals across the globe. Please...
Forums
Career Advice: Data Warehouse Architect/Modeler
Maybe some of you would share your thoughts about my situation. I´m working in...
https //ketomegamar com/vaso-prime-rx/
Vaso Prime RX Now for your method. Process specific exercises that you perform on...
Avamar Backup--Is it good?
Dear Experts, is it good to use Avamar backup for SQL Server, currently we...
Ask SSC