August 5, 2011 2:00 PM
Posted by: Denny Cherry
Back To Basics,
In Person Events,
NETDA,
SQL ServerThat's right SQL People, the .NET folks at the Redmond, WA NETDA user group has invited me to come and speak at their user group meeting on Monday August 8th, 2011 in the Building 41 cafeteria on the Microsoft Campus.
I'll be giving a session...
April 5, 2010 12:00 PM
Posted by: Denny Cherry
Back To Basics,
In Person Events,
Plagiarism,
Sean McCown,
SQL Server,
SSWUGThis week I've got a few speaking events to let everyone know about.
On Tuesday April 6th, at 6pm I'll be speaking to the LA C# User Group. The meeting is held at the Manhattan Beach Library at 1320 Highland Ave in Manhattan Beach, CA 90266. The group...
March 12, 2009 11:00 AM
Posted by: Denny Cherry
Back To Basics,
Execution Plan,
Index Performance,
SQL,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008All to often when helping people look at query performance problems I'll ask them to look at the execution plan, and see what it says. Most query performance problems can be resolved simply by looking at the execution plan and seeing where you need to add an index.
All to often I (and others)...
February 2, 2009 1:31 PM
Posted by: Denny Cherry
Back To Basics,
Clustered Index,
Index,
Nonclustered IndexSQL 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
Posted by: Denny Cherry
Back To Basics,
Identity theft,
Index,
Index ScanA 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
Posted by: Denny Cherry
Back To Basics,
T/SQL,
XMLOne 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
Posted by: Denny Cherry
Back To Basics,
CREATE INDEX,
SELECT statementAfter 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
Posted by: Denny Cherry
Back To Basics,
Index Performance,
Index Scan,
Index Seek,
SQL Server,
Table ScanThere 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
Posted by: Denny Cherry
Back To Basics,
Federated Database,
In Person Events,
SoCal Code Camp,
StorageHere are the slide decks and sample code from my sessions at this weekends SoCal code camp.