SQL Server KBs and Blogs

Quick access to blogs posts from SQL Server Support Team., Some of the new KBs published for SQL and SQL Content news

December, 2013

Featured
    No blog posts have yet been created.
  • Spatial Index is NOT used when SUBQUERY used

    I have found the following link to be invaluable when working with and tuning SQL Server Spatial indexes:  http://technet.microsoft.com/en-us/library/bb895265.aspx However, the link is not as clear as it could be about the Spatial index selections...
  • How Simple Parameterization works

    Recently we got a customer who upgraded from SQL Server 2005 to 2008. But their performance degraded greatly. What happened was that they had an update query that was run many times in a batch. The query was submitted as ad hoc by the application with...