THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008   (RSS)
Showing page 5 of 8 (73 total posts)
  • New (web) update for SQL Server 2008 Books Online

    Fire up your SQL Server 2008 Books Online (BOL) and check the date. You should find this in any article (except for the very start page). RTM of SQL Server 2008 shipped with a BOL which has ... hmm,... doesn't have a date (just checked in a virtual machine). OK, so if you don't find a date (year month) you have the BOL which shipped with ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 5, 2008
  • Geek City: Clearing a Single Plan From Cache in SQL Server 2008

      I just today found out about something that was in plain sight in the Books Online... but the documentation is so vast, I haven't discovered everything yet. I blogged about clearing a single plan from cache in SQL Server 2005 a while back, and mentioned a rumor that there would be a new way to do this in SQL Server 2008. And then just ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 31, 2008
  • Does the Resource Governor govern?

    Two weeks ago, we did the ''SQL 2008 Summit'' roadshow here in Sweden. We did 4 cities around Sweden in 4 days ( It was a bit exhaustive, but even more fun - being able to travel and spend some time with persons wish I could meet more often (Kalen), others I meet regularly but only at workplace (Roger, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 22, 2008
  • SQL Server 2008 SMO Library Changes

    While preparing for a presentation at PASS next month I tested my PowerShell script to back up user databases on a server. This script has been running flawlessly against SQL Server 2005 for a couple of years, so I was really surprised when PowerShell returned a screen full of errors and no backups. What slipped my mind was something I'd ...
    Posted to Allen White (Weblog) by AllenMWhite on October 18, 2008
  • [Ohio] A Day in the Life of the DBA 2008

    We are pleased to invite you to the October 9th 2008 meeting of the Ohio North SQL Server Users Group (ONSSUG). The meetings are held on the 2nd Thursday of every month at 5:45 in the Cleveland Microsoft office. The address of the office is below: Microsoft Corporation 6050 Oak Tree Blvd. Suite 300 Cleveland, OH 44131 Agenda: 5:00 - 5:45 ...
    Posted to Allen White (Weblog) by AllenMWhite on October 6, 2008
  • Did You Know? It's SQL Know How!

    I am very excited to be part of a new SQL Server Training Group, which was organized in the UK by 4 SQL Server MVPs (current and former).  I know this is a shameless plug, but I am not apologizing. I am actually going to the UK for the benefit of the SQLKnowHow guys, and I'm just trying to help them out even more by telling you all about ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 26, 2008
  • SQL 2008 Data Compression - Linchi Shea

    Last night at the NYC SQL Server Users Group meeting Linchi Shea presented a session on Data Compression (not Backup Compression) in SQL Server 2008. By understanding how the compression algorithm works, and tuning your clustered indexes based on that understanding, you can achieve some pretty incredible space savings on disk, and performance ...
    Posted to Allen White (Weblog) by AllenMWhite on September 26, 2008
  • My datetime article updated for 2008

    Actually, the article has been out for about a month now, but I first solicited feedback on errors and typo's and then I forgot to mention the update here... Anyhow, the article now also covers 2008 and the new date, time, datetime2 and datetimeoffset types. There are some interesting aspects of the new types which sets them apart from the old ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 23, 2008
  • Geek City: Too Many Columns!

    As I am working on my new SQL Server 2008 internals book, I am finding many test situations in which I need to create a table with LOTS of columns. First of all, you're probably aware of the new SPARSE column feature that allows you to have up to 30,000 columns in a table!  I did some testing with sparse columns, but just today I realized I ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 20, 2008
  • Did You Know? It's Official...I'm a Geek!

    I almost didn't respond to the request for an interview with Richard Morris of Simple Talk. There were a few strange things in the request that made me think it might be spam or phishing. But I asked some trusted colleagues, and found out it was for real, and you can read the result ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 16, 2008
« First ... < Previous 3 4 5 6 7 Next > ... Last »
Privacy Statement