Cloud & SQLSailor

Cloud, Databases & Beyond!

Month: March 2011

  • Buck Woody’s description on Win 2008 R2 and SQL 2008 R2

    ” Windows Server R2 is a revolutionary change and SQL 2008 R2 is a evolutionary change”

  • Doing a count(*) can be really a bad idea

    Just learned that doing a count (*) is not that a great idea. People (So do I) often think that it will just pick the row count, but it will…

  • Have you ever wondered why SPID values are mostly over 50 when you do a sp_who2

    The user connections/activity will be having SPIDs over 50 and most of the internal checks will be below that number.

  • Reading error logs

    I like to pull the error logs using running SP : SP_readerrorlog.This is much simple and easy to read.

  • Check which are the traces which are currently running

    You can run DBCC  TRACESTATUS to pull the info.

  • Trace flag 3226 and 1222

    These are really useful trace flags : Stop logging all successful backups in your SQL Server error logs : DBCC  TRACEON(3226,-1) Capture deadlocks in SQL Server error logs : DBCC…

  • EXEC dbo.xp_msver

    This will pull server level info and will provide information on couple of things which are really useful : ProductName ProductVersion Platform FileVersion ProcessorCount

  • Template Explorer

    This is one of the awesome feature I learned today.I was aware of the availability of Template Explorer,but never knew that there is a short cut for it. Ctrl+Alt+T will…

  • Compatibility Mode

    There are many assumptions on SQL Server compatibility option which is available.Changing the compatibility is major for the T-SQL changes which comes in with different versions.

  • SQL 2000 and 2005 support

    There are some important news about SQL 2000 and 2005 support.Please read the article below for more information: http://www.microsoft.com/sqlserver/en/us/support/support-updates.aspx The best suggestion for everyone is to migrate to the latest…

Explore