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
Identity Columns- How close to the edge are you?

Day 9. How close is your data to the edge! Integer identity columns that increment by 1, have been known to run out of numbers. I have seen it occur on a few occasions on highly transactional systems. However there is really no excuse for getting caught out. The folwoing code easily shows you were your...

Posted to Martin Croft Musings on SQL Server (Weblog) by MartinCroft on Mon, May 9 2011
Quick and Simple Deletes

Day 6 and a Friday so keep it simple. There are occasions where you want to delete a huge table and truncation is just not an option for various reasons, but deleting from the table creates a huge transaction log. You don’t want to over engineer the solution so heres a simple example thats takes copy...

Posted to Martin Croft Musings on SQL Server (Weblog) by MartinCroft on Fri, May 6 2011
Maximum date in a row (not a column)

Day 2 of a post every day ! I was asked recently how you could get the latest/earliest date field across a row of data, not the most usual request it tends to be the maximum value in a column and then its just a straight forward GROUP BY and MAX in that case. However given the example above the user...

Posted to Martin Croft Musings on SQL Server (Weblog) by MartinCroft on Mon, May 2 2011
SQL 2008 sp 2 – partitioning changes

I was interested to see that SQL 2008 service pack 2 includes support for an increased number of partitions. ie In SQL 2008, the maximum number of partitions on a table is 1,000 – but now with sp2, the maximum number is 15,000. Microsoft have published a whitepaper to document this change – here . A...

Posted to Steve Hindmarsh's SQL Blog (Weblog) by steveh99999 on Tue, Oct 5 2010
Stored procedure and how to script them

Imagine having hundred of stored procedures in your database and you want to move them to another database. There are several ways to move them. 1) In MMSM you can right-click each procedure and select "script stored procedure as -> create to -> new query window" but this might be tidious...

Posted to Tomaz.tsql (Weblog) by Tomaz.tsql on Tue, Aug 31 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
SQL Server MVP Deep Dives book available for preorder

Along with 53 other MVP's I've contributed a chapter to the SQL Server MVP Deep Dives book which is now available for preorder. All author royalties, along with a contribution from Manning Publications, go to support War Child International (visit www.warchild.org for more information). To order...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on Tue, Oct 27 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
SQL 2008 R2 August CTP now available to all

It has been up on Technet and MSDN for a few days now for subscribers but the August CTP of SQL Server 2008 R2 is now available to all from Technet. Get it here http://technet.microsoft.com/en-us/evalcenter/ee315247.aspx SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 to help your...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on Thu, Aug 13 2009

Page 1 of 5 (48 items) 1 2 3 4 5 Next >