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 – 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 – Collate – Case Sensitive SQL Query Search
Make a SQL Query Search case sensitive: add COLLATE Latin1_General_CS_AS to the WHERE clause so ‘casesearch’ matches one row instead of all four.
SQL SERVER – SET ROWCOUNT – Retrieving or Limiting the First N Records from a SQL Query
SET ROWCOUNT limits how many rows a query returns, and SQL Server stops once it has them. See the syntax, how SET ROWCOUNT 0 resets it, and when it is ignored.
SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1
Msg 3159 says the tail of the log was not backed up, then Msg 3013 ends RESTORE DATABASE. A script that worked in SQL Server 2000 failed in 2005, and here is why.