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
Extended Events Misperceptions: Profiler is Easier
I know, I know, I’m on #teamexevents so I think that Extended Events can...
I’m Speaking at #SQLSatSpokane
By Angela-Henry
I am super excited to announce that I have been selected to speak at...
Common commands and tasks to make dealing with Windows Core easier.
I don’t know how many of you are working with Windows Core these days...
Forums
Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2
Comments posted to this topic are about the item Move Data from SQL Server...
Knowing What You Don’t Know
Comments posted to this topic are about the item Knowing What You Don’t Know
Automate Import of LIBOR Rates
Does anyone have any recommendations for sites which publish the daily LIBOR rates in...
Ask SSC