SQL Server with Mr. Denny:



December 26, 2013  4:00 PM

Indexes on forign keys can make a big difference

Posted by: Denny Cherry
CREATE INDEX, Database Administration, Indexing, Nonclustered Index, SQL, SQL Server, Tables

It's amazing just how much difference having a non-clustered index on the child table of a foreign key can matter when the foreign keys have cascading...

January 23, 2013  9:00 AM

NOLOCK is not a turbo button

Posted by: Denny Cherry
CREATE INDEX, Database, Execution Plans, Indexing, SELECT statement, SQL Server, T/SQL, Tables

All to often when talking to developers they put the WITH (NOLOCK) table hint in place to speed up queries without understanding what the table hint does.  I've...

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


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: