SQL Server with Mr. Denny:

November, 2008


November 30, 2008  11:15 PM

Webcast: SQLServerPedia.com — The Definitive SQL Server Knowledge Base

Denny Cherry Denny Cherry Profile: Denny Cherry

Gain access to SQL Server experts and learn more about SQLServerPedia.com by attending this webcast. SQLServerPedia.com is the free reference resource created for SQL Server professionals, by SQL Server professionals. See how...

November 28, 2008  10:58 PM

January SoCal Code Camp Sessions Being Posted

Denny Cherry Denny Cherry Profile: Denny Cherry

The SoCal Code Camp website has started accepting sessions for the next Code Camp in January. I've put a couple of sessions up there already.

I've got one on


November 27, 2008  12:15 PM

Back To Basics: Creating Indexes

Denny Cherry Denny Cherry Profile: Denny Cherry

After you have created your tables, and stored procedures you will have a basic idea of what queries are going to be running against your database.  If you haven't already done so, its now time to start adding indexes to your database.  The catch with index is that there is such a thing as to...


November 25, 2008  11:39 PM

How to configure storage in SQL Server DB with more writes than reads

Denny Cherry Denny Cherry Profile: Denny Cherry

All to often articles and presentations about storage work under the assumption that you have a typical OLTP database with mostly reads. However there are plenty of databases out there which are mostly writes and very few reads. Setting these systems up takes a different technique for best...


November 24, 2008  1:00 PM

Back To Basics: What’s the difference between a Scan and a Seek?

Denny Cherry Denny Cherry Profile: Denny Cherry

There are a few basic operations which SQL will perform when looking for the data that you need.  Here they are listed in the order of worst to best.

  • Table Scan
  • Clustered Index Scan
  • Index Scan
  • Clustered Index Seek
  • Index Seek
The...


November 23, 2008  12:00 PM

ITKE is getting an upgrade soon

Denny Cherry Denny Cherry Profile: Denny Cherry

I've been informed that at some point in the near future (within the next couple of weeks probably) that we'll be upgrading the version of Word Press that we use for the blogs.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


November 22, 2008  7:08 PM

PASS 2008 Wrapup

Denny Cherry Denny Cherry Profile: Denny Cherry

Well the PASS 2008 summit must be official over as I'm sitting at the airport waiting for my plane.  I was expecting a very long security line here at SeaTac but I was through security within maybe 10 minutes.  While means that the two hours I was planning on standing in line I instead get to sit...


November 22, 2008  12:43 AM

PASS 2008 – Day 3

Denny Cherry Denny Cherry Profile: Denny Cherry

Today was a pretty slow day. I spent most of the day kicking back in the MVP room talking to the MVPs and the Microsoft folks. I did make it to a couple of sessions however.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


November 21, 2008  5:08 AM

PASS 2008 – Day 2 Recapped

Denny Cherry Denny Cherry Profile: Denny Cherry

Today was another excellent day here at PASS 2008 in rainy Seattle, WA.

Continued »


November 20, 2008  8:31 AM

Congratulations to Tom LaRock and Douglas McDowell!

Denny Cherry Denny Cherry Profile: Denny Cherry

Two of my fellow SQLServerPedia.com editors Tom LaRock and Douglas McDowell, have been nominated for...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: