You do not need to restart the server to clear SQL Server memory caches. DBCC FREESYSTEMCACHE and related DBCC commands do it, for the rare times you need it.
SQL SERVER – Enable Login – Disable Login using ALTER LOGIN – Change name of the ‘SA’
Use ALTER LOGIN in SQL Server 2005 to disable or enable any login, including ‘sa’, and to rename the SA account to a name that is hard to guess.
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.
SQLAuthority.com 100th Post – Gratitude Note to Readers
A thank you note on the 100th post of SQLAuthority.com, to my readers for their emails, comments and support, and to my parents for their love.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.