Rotating Header Image

Posts from ‘November, 2008’

Moving tempdb

Best practice dictates that tempdb should reside on it’s own physical drive(s).  There are many good reasons to do this but the two that normally get brought up and discussed are that tempdb is too big on the current drive and/or the desire to increase performance by having tempdb on different physical drives. In order to […]

SQL Server 2008 – Backup compression

Backup compression is something new to SQL Server in SQL 2008 and it’s something that products like SQL LiteSpeed will be quite interested. Using a sample database I ran the following scripts and listed the results below: DECLARE @StartDateTime DATETIME = GETDATE()BACKUP DATABASE <<DatabaseName>>  TO DISK = 'D:\NotCompressed.bak' WITH INIT, COPY_ONLYSELECT DATEDIFF(ms, @StartDateTime, GETDATE()) SET @StartDateTime […]

SQL Server Kilimanjaro

Alot of people (at the PASS Summit) got a preview of the next release of SQL Server code named Kilimanjaro.  I’m going to just call it KJ cause well it’s just easier 🙂 who knows… maybe it’ll catch on LOL. Anyways… with an planned release of the first half of 2010.  Quentin Clark, general manager of Microsoft’s […]

Cumulative Update Package 2 for SQL Server 2008

http://support.microsoft.com/kb/958186/ Cumulative Update 2 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008. Note This build of the cumulative update package is also known as build 10.00.1779.00. We recommend that you test hotfixes before you deploy them in a production environment. Because the builds […]

SQL 2008 – New DateTime Datatypes

Finally SQL Server (well SQL Server 2008 anyways) gives you the option of storing your date and time separately.  In SQL 2008 there is a new set of datatypes for storing date, time, and both date and time.  The date limitations have also been changed so that now you can store from the beginning of […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.