Table Sizes in database
This script uses the same information sp_spaceused does. It just formats it in a different way.
2005-05-10 (first published: 2005-04-26)
186 reads
Execute SQL-DMO Database method on all databases
This script allows you to specify a method and a server (or multiple servers.) It will then execute the method on every database on the server. With very minor tweaking you could have it search for the servers, then call the server db script with each one, or add another nesting to call tables or […]
2005-04-27 (first published: 2005-04-14)
691 reads
Blogs
Are You a Diverse User Group or Event?
By Steve Jones
One of the things that I’ve seen crop up at various points in my...
Daily Coping 18 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
When Read Committed Snapshot Goes Bad – Version Store Filling TempDB
We all had those calls, it’s the middle of the night and we get...
Forums
Seeking input on Best Method to Join on First or Last Row in a 1:M Join
I have included the DDL to re-create the 2 tables in this examples. I...
DB logins permission script out
Hi, Can anyone share or point me to get -DB logins permissions in a...
UniqueIdentifier as Primary Key, non-clustered index, fragmentation issue
I've been working a little bit with a few tables here, they've got "CreatedDate"...
Ask SSC