Showing posts from April, 2011
It is important to make sure you set the Max server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subjec…
Buffer cache hit ratio This means what is the percentage that SQL Server had the data in cache and did not have to read the data from disk. Ideally you want this number to be as close to 100 as pos…
Here is a script which list out all the identity columns and percentage used SET NOCOUNT ON SELECT SCHEMA_NAME(t.schema_id) + ' . ' + t.name AS TableName, idc.name AS ColumnName, C…
Partitioning can be effectively used to break up a very large table into multiple partitions based on a column or partitioning key. However, there can be significant management overhead in maintainin…
I encountered the situation recently where I needed to find the size of the database. --size of database SELECT DB_NAME(database_id) AS DatabaseName, SUM (( size *8)/1024) SizeInMB FROM sys.mast…