SQL Server with Mr. Denny


September 14, 2009  5:24 PM

SQL Server Clustering Guide & Webcast Links

Denny Cherry Denny Cherry Profile: Denny Cherry

A white paper which I wrote for Starwind Software is now available.  The link to register for the webcast (October 21, 2009) has also been put up.  The webcast and white paper go together, so I recommend that you grab the white paper now and I hope to see you at the webcast next month.

Denny

September 14, 2009  11:00 AM

My experiences upgrading ESX 3.5 to vSphere 4.0

Denny Cherry Denny Cherry Profile: Denny Cherry

A couple of weeks back I begun the process of upgrading our VMware ESX 3.5 systems to vSphere 4.0.  I’ve got to tell you, that has to be the easiest system upgrade process in history. Continued »


September 11, 2009  11:16 PM

Next weeks webcast has been rescheduled.

Denny Cherry Denny Cherry Profile: Denny Cherry

I was going to be doing a webcast next week on September 16th, 2008 on Clustering SQL Server 2008 over iSCSI.  Due to some scheduling issues we’ve had to reschedule the presentation for October 21, 2009 at 2pm (Eastern) / 11am (Pacific).

The information page is the same.  There’s no registration form on it just yet. that is supposed to go up on Monday for the new date and time.  I’ll be sure to put up a new post then.

Denny


September 11, 2009  7:43 AM

South Bay .NET User Group, thanks for having me over.

Denny Cherry Denny Cherry Profile: Denny Cherry

Tonight I spoke at the South Bay .NET User Group.  I had a blast talking with them.  They are a great group of programmers. Continued »


September 10, 2009  11:00 AM

How did I ever survive without Live Sync

Denny Cherry Denny Cherry Profile: Denny Cherry

Apparently I need to pay more attention to the software that Microsoft has up on the Live site. Continued »


September 9, 2009  1:55 AM

Whitepaper on why database maintenance is important

Denny Cherry Denny Cherry Profile: Denny Cherry

Today I’m publishing a white paper which I wrote for our Customer Service department to give to our customers. It explains why database maintenance is so important in keeping your database happy and healthy. Continued »


September 7, 2009  11:00 AM

Speaking at the South Bay .NET Users Group

Denny Cherry Denny Cherry Profile: Denny Cherry

On September 10th, 2009 I’ll be speaking at the South Bay .NET Users Group in Torrance, CA.

I’ll be giving two presentations at the meeting.  First I’ll be giving my “SQL Server Indexing for the Client Developer”, and second I’ll be giving my “What do all Those Undocumented Stored Procedures do?” session.

The meeting starts at 7, but I’m sure people start arriving about 6:30 or so.  This is my first time speaking at this user group, but I’m sure it’ll be a blast.

See you there.

Denny


September 7, 2009  11:00 AM

How I got started in IT

Denny Cherry Denny Cherry Profile: Denny Cherry

I was tagged by Brent Ozar in his post Starting the SQL Journey where he talked about how he got started as a SQL DBA.  So here’s my story, in all its glory. Continued »


September 1, 2009  6:31 PM

SQL Server 2008 Clustering Article in SQL Server Magazine

Denny Cherry Denny Cherry Profile: Denny Cherry

For those of you who haven’t check out this months SQL Server Magazine, the cover article was written by yours truly about Clustering SQL Server 2008 on Windows Server 2008.  This is an updated version of the article I did last December on Clustering SQL Server 2005 on Windows Server 2003.

I hope that you find it handy.  (Subscription is required.)

Denny


August 31, 2009  6:26 PM

Difference between an Index and a Primary Key

Denny Cherry Denny Cherry Profile: Denny Cherry

There seams to be some confusion between what a Primary Key is, and what an Index is and how they are used.

The Primary Key is a logical object. By that I mean that is simply defines a set of properties on one column or a set of columns to require that the columns which make up the primary key are unique and that none of them are null. Because they are unique and not null, these values (or value if your primary key is a single column) can then be used to identify a single row in the table every time. In most if not all database platforms the Primary Key will have an index created on it.

An index on the other hand doesn’t define uniqueness. An index is used to more quickly find rows in the table based on the values which are part of the index. When you create an index within the database, you are creating a physical object which is being saved to disk. Using a table which holds employees as an example:

CREATE TABLE dbo.Employee
 (EmployeeId INT PRIMARY KEY,
 LastName VARCHAR(50),
 FirstName VARCHAR(50),
 DepartmentId INT,
 StartDate DATETIME,
 TermDate DATETIME,
 TermReason INT)

The EmployeeId is the Primary Key for our table as that is what we will use to uniquely identify an employee. If we were to search the table based on the last name the database would need to read the entire table from the disk into memory so that we can find the few employees that have the correct last name. Now if we create an index on the LastName column when we run the same query, the database only needs to load the index from the disk into memory, which will be much quicker, and instead of scanning through the entire table looking for matches, because the values in the index are already sorted the database engine can go to the correct location within the index and find the matching records very quickly.

Hopefully this will help sort out some of the confusion.

Denny


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: