SQL Server Statistics Info

Leave a comment

Great article by none other than the “Scary DBA” himself, Grant Fritchey. This article is all about SQL Server statistics which are now a dark art or path less traveled for the hybrid developer/DBA. Like all of his articles this one is very well written with examples that are easy to digest.

 

SQL Server Statistics Questions We Were Too Shy to Ask 

http://bit.ly/17INCWp

Advertisements

Remove data from data (.mdf) file

Leave a comment

SHRINKDB with the EMPTYFILE argument is a handy command that I for some reason continue to forget about.

MSDN – http://msdn.microsoft.com/en-us/library/ms189493.aspx

EMPTYFILE – “Migrates all data from the specified file to other files in the same filegroup. Because the Database Engine no longer allows data to be placed in the empty file, the file can be removed by using the ALTER DATABASE statement.”

DBCC SHRINKFILE (EMPTYFILE)

 

 

%d bloggers like this: