A heap in SQL Server is a table with no clustered index. Forwarded records pushed one count from 11,113 reads to 199,844, and a single REBUILD put it back. When a heap is fine and when it is not.
SQL SERVER – What DBCC Memory Cache Commands Actually Clear
SQL Server retains memory caches to support later work. I investigate memory pressure before trying to release them.
SQL SERVER – Enable Login – Disable Login using ALTER LOGIN – Change name of the ‘SA’
ALTER LOGIN can enable, disable or rename a SQL Server login. I verify another administrative access path before changing sa.
SQL SERVER – FIX : ERROR 1101 : Could not allocate a new page for database because of insufficient disk space in filegroup
Error 1101, could not allocate a new page because of insufficient disk space in filegroup. Free up hard disk space and turn on AUTOGROW for the filegroups.
SQL SERVER – 2005 TOP Improvements/Enhancements
SQL Server 2005 brings two enhancements to the TOP clause: pass a variable or sub-query as the TOP value, and use TOP in INSERT, UPDATE and DELETE.
SQL SERVER – User Defined Functions (UDF) to Reverse String – UDF_ReverseString
UDF_ReverseString returns a reversed string starting from any position you pass. The script of the function plus usage examples, like reversing from the third character.
SQL SERVER – Copy Column Headers in Query Analyzers in Result Set
To copy column headers with your results in Query Analyzer, set Results to Text, Tab Delimited and turn on Print column headers in Options. Video included.