SQL Server with Mr. Denny:

SQL Server Indexes


November 25, 2015  4:00 PM

Inline Nonclustered Indexes

Denny Cherry Denny Cherry Profile: Denny Cherry
Index, SQL Server, SQL Server Indexes

One of the new features that I just recently learned about in SQL Server 2014 is the ability to create nonclustered indexes on a table inline with the creation of the table. This is handy in a couple of...

November 18, 2015  2:00 PM

I Don’t Want To Create Indexes Because It Will Slow Down My Application

Denny Cherry Denny Cherry Profile: Denny Cherry
Indexes, SQL Server, SQL Server Indexes

"I Don't Want To Create Indexes Because It Will Slow Down My Application." I hear that argument all the time from software developers at clients when I tell them that we need to create indexes. This is usually followed up by "If we add indexes it will slow down the INSERT, UPDATE and DELETE...


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: