News...

Oct 26, 2009 - Know thy indexes
Posted by Tariq Ahmed on 10/26/09 11:50AM for Technology & Business | 737 Views

Whenever I do a round of interviewing for a developer position one of the things I find is that many people do not have a firm grasp of database indexes, specifically SQL Server indexes (since that is what we use).

I'm probably the furthest thing from a DB guru, and many teams have dedicated DBA's who handle all that stuff, but I believe it's important for developers to have a strong understanding of how databases work as that's often the single point of failure.

SQL Server Central has a recent introductory article on indexes that is a very worthwhile read that I encourage you to have everyone you know read.

"Clustered indexes define the logical order of the table. The leaf level of the clustered index has the actual data pages of the table. Because of this there can only be one clustered index per table. A table that does not have a clustered index is referred to as a heap."

Read the full article

Comments (0)

Add Comment

Identify yourself: (Required)
Mail: (Won't be displayed)
Link/URL:
Type in these characters: 7IB (Required)
What's your beef:

Tariq Ahmed
Postings by Category
Adobe Flex (78)
Agile Development (1)
ColdFusion (53)
Companies (1)
Database (2)
General (5)
Management & Business (4)
Products (5)
Usability/User Experience (2)

Flex 3 In Action - Become Effective Fast
Flex 3 In Action Using your existing Web Development skills FiA ramps up your knowledge of Flex quickly and easily by giving you a foundation of understanding and the skills needed to become productive in a short timeframe. Various ways of doing the same thing are explained in depth so that you understand your options… and most importantly, FiA makes learning Flex fun!
PROMOTION: Each purchase includes the book, plus the PDF eBook, and the Flex 4 In Action eBook

$31.49 on Amazon
Flex In Action Blog
Free: Flex Layout and Navigation
Free: Testing and Debugging Flex Apps

    Copyright 2010 Tariq Ahmed. All rights reserved.