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
86 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
Bash: ^^}: bad substitution – upgrade your Bash version (macOS)
By HeyMo0sh
This blog post is about a situation where you are capitalising an argument in...
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
By HeyMo0sh
This blog post relates to where you might be doing scale operations of your...
Bash: “command not found” in IF statement
By HeyMo0sh
This blog post is about a situation where writing an IF THEN ELSE statement...
Forums
Multi subnet failover cluster
My goal is to have an FCI across 2 nodes with shared storage (node...
Power Query or SQL Server? Which, when and why
Comments posted to this topic are about the item Power Query or SQL Server?...
Are You Empowered?
Comments posted to this topic are about the item Are You Empowered?
Ask SSC