SQL Server with Mr. Denny:

Back To Basics


February 2, 2009  1:31 PM

Back To Basics: Clustered vs NonClustered Indexes; what’s the difference?



Posted by: Denny Cherry
Back To Basics, Clustered Index, Index, Nonclustered Index

SQL Server has two basics kinds of indexes. They are clustered and nonclustered indexes. There are some fundamental differences to the two which are key to understanding before you can master index tuning.

January 26, 2009  12:00 PM

Back To Basics: What are indexes and what are they used for?



Posted by: Denny Cherry
Back To Basics, Identity theft, Index, Index Scan

A while back someone posted on the ITKE forum asking what Indexes where, and what they were used for. I put up a quick answer, but I felt that it deserved a more in depth blog post; so here it is.


December 15, 2008  9:00 AM

Back To Basics: Getting Data from an XML Document



Posted by: Denny Cherry
Back To Basics, T/SQL, XML

One of the most popular ways to get data multiple pieces of data in a single parameter from one stored procedure to another, or from a client application to the database is to use XML. This can be done in SQL Server 2000 by using the NTEXT (or TEXT) datatype, and in SQL 2005 using the XML...


November 27, 2008  12:15 PM

Back To Basics: Creating Indexes



Posted by: Denny Cherry
Back To Basics, CREATE INDEX, SELECT statement

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 24, 2008  1:00 PM

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



Posted by: Denny Cherry
Back To Basics, Index Performance, Index Scan, Index Seek, SQL Server, Table Scan

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...


October 25, 2008  11:00 AM

Slide Decks and Sample Code for SoCal Code Camp at USC



Posted by: Denny Cherry
Back To Basics, Federated Database, In Person Events, SoCal Code Camp, Storage

Here are the slide decks and sample code from my sessions at this weekends SoCal code camp.

  Bookmark and Share     4 Comments     RSS Feed     Email a friend


August 21, 2008  11:00 AM

SoCal Code Camp Sessions are posted



Posted by: Denny Cherry
Back To Basics, Code Camp, In Person Events, Service Broker, SoCal Code Camp, SQL Server 2005, SQL Server 2008, Storage

I and many of the other presenters have begun entering our sessions for the next SoCal Code Camp on on October 25th and 26th...


August 11, 2008  11:00 AM

Back To Basics: The RESTORE DATABASE Command



Posted by: Denny Cherry
Back To Basics, Restore Database, SQL

The restore database command is what is used to recover a database which has been backed up using the BACKUP DATABASE command.  The syntax of the RESTORE DATABASE...


July 22, 2008  11:00 AM

Back to Basics: The BACKUP DATABASE command



Posted by: Denny Cherry
Back To Basics, BACKUP DATABASE, SQL, SQL Server 2000, SQL Server 2005

Now that you have objects created within your database, and data within the tables you need to secure your database in case of a server failure or accidental data deletion.  This would be done by taking backups of the database.  Backups are taken by using the BACKUP DATABASE command. The...


July 7, 2008  11:00 AM

Back To Basics: The RECEIVE command (and END CONVERSATION)



Posted by: Denny Cherry
Back To Basics, RECEIVE, Service Broker, SQL, T/SQL

The RECEIVE command is the last of the Service Broker items to cover in the Back To Basics series.  The RECEIVE command is what is used to actually get the message out of the queue so that you can process the data within the message_body column.  The RECEIVE command works just like the


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: