in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SQL 2005 (RSS)

Browse by Tags

  • Parallelism, CPU Time & DMV’s

    Whilst reviewing the CPU statistics of a system that i knew was CPU bound i found the numbers were not adding up and i was not seeing the code i expected to see as a top CPU consumer so i decided to going digging. I quickly identified that if the query has gone parallel it: Only shows as one thread in...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Mon, May 30 2011

  • The Exceptional EXCEPT clause

    Ok, I exaggerate, but it can be useful… I came across some ‘poorly-written’ stored procedures on a SQL server recently, that were using sp_xml_preparedocument. Unfortunately these procs were not properly removing the memory allocated to XML structures – ie they were not subsequently calling sp_xml_removedocument...
    Posted to Steve Hindmarsh's SQL Blog (Weblog) by steveh99999 on Wed, Feb 2 2011

  • The overlooked OUTPUT clause

    I often find myself applying ad-hoc data updates to production systems – usually running scripts written by other people. One of my favourite features of SQL syntax is the OUTPUT clause – I find this is rarely used, and I often wonder if this is due to a lack of awareness of this feature.. The OUTPUT...
    Posted to Steve Hindmarsh's SQL Blog (Weblog) by steveh99999 on Mon, Jan 17 2011

  • Server Side Aliases

    Over the years i have come across a few situations where server side connections to SQL server fail when you use a DNS alias that points back to the server your initiating the connection from but you can connect remotely. Its an annoying problem which has a very unhelpful error message that changed in...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Nov 7 2010

  • Exploring backup read io performance

    I was recently exploring how to increase the backup read throughput on one of our SQL servers. Below are some interesting facts i found. I would say that one of the most important reminders that came from the exercise is, do not assume that 2 databases being backup up on the same server using an identical...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Jan 24 2010

  • New version of Expressmaint now available (2.0.0.0)

    A new version of the Expressmaint database maintenance utility is now available for download. This version adds the ability to specify a custom backup file name format. Please note there are specific version for SQL 2005 (2.0.0.0) and SQL 2008 (2.0.0.1) that differ only in the version of SMO they use...
    Posted to sqldbatips.com blog (Weblog) by sqldbatips on Sat, Nov 7 2009

  • Restoring an Expressmaint backup using SQL Server Management Studio Express

    This post describes step by step how to restore a full database backup taken with Expressmaint (or by any other means) using SQL 2005 Management Studio Express (SSMS). The same steps apply to SQL 2008. To download this free tool for SQL Server Express Edition use the links below Download SQL 2005 Management...
    Posted to sqldbatips.com blog (Weblog) by sqldbatips on Wed, Oct 21 2009

  • New version of Expressmaint now available (1.9.0.0)

    A new version of the Expressmaint database maintenance utility is now available for download. This version fixes an issue with the timeout parameter (-TO) being treated as seconds instead of minutes for the REORG task. Please note there are specific version for SQL 2005 (1.9.0.0) and SQL 2008 (1.9.0...
    Posted to sqldbatips.com blog (Weblog) by sqldbatips on Sun, Sep 13 2009

  • Keeping up with SQL Server KB articles

    One of the most useful tools for anyone involved in day to day support of SQL Servers is being able to keep up with the latest Microsoft Knowledge Base articles for the products you support. There are RSS feeds available for each of the currently supported editions that allow you to keep up to date with...
    Posted to sqldbatips.com blog (Weblog) by sqldbatips on Wed, Jul 29 2009

  • Disk Partition Alignment Best Practices for SQL Server whitepaper

    This paper documents performance for aligned and nonaligned storage and why nonaligned partitions can negatively impact I/O performance; it explains disk partition alignment for storage configured on Windows Server 2003, including analysis, diagnosis, and remediation; and it describes how Windows Server...
    Posted to sqldbatips.com blog (Weblog) by sqldbatips on Tue, May 12 2009
Page 1 of 4 (34 items) 1 2 3 4 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems