Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2009

All the Aggregate Data you Crave with Grouping Sets in SQL Server 2008

As reporting requirements increase, it seems that aggregate functions have thankfully risen to the occasion concurrently. To maintain its competitive edge as Staples' best Canadian vendor, BaldGorilla, where I’m consulting actually, has been able to fulfill the most demanding deadlines thanks to the query results produced from Grouping Sets. … Read more

2 comments, 1,242 reads

Posted in The Database Hive for SQL Server DBAs on 28 January 2009

It's Minus Twenty-Five Outside and I'm Writing about Transaction Log Files

(1linerForward) I originally wrote this in French while working at LaCaisse.com - http://dbhive.blogspot.com/2008/07/fichiers-journaux-de-transactions.html   

Why do you care, as a DBA, or a Developer for that matter, about what is happening in the Transaction Log? Lets rollback a little and see... The raison d’être of a transaction log file is to… Read more

6 comments, 4,615 reads

Posted in The Database Hive for SQL Server DBAs on 17 January 2009

SQL 2008 Row and Page compression – or SQL 2005 (post SP2) vardecimal conversion

One of the great new features in SQL 2008 is Row and/or Page Compression. Plus, still good news for those of you on SQL 2005 in production who might be there for a long while: there’s a decent feature you can take advantage of too. How? With compression in SQL…

Read more

3 comments, 847 reads

Posted in The Database Hive for SQL Server DBAs on 2 January 2009

How Certification Can Help You Stay Current with Technology, as well as Continuing Your Education

If you'd like to keep up with your profession as a SQL DBA, I thoroughly recommend certification.  It has certainly given me an edge with respect to several mandates over the past seven years, and even at the least, a decent boost of confidence with respect to being able to… Read more

0 comments, 807 reads

Posted in The Database Hive for SQL Server DBAs on 1 January 2009