SQL Server with Mr. Denny:

ITKE grandparent


July 17, 2013  7:00 AM

Nolock and your financial application



Posted by: Denny Cherry
Index Performance, Indexing, Nonclustered Index, Query tuning, SQL Server

The NOLOCK indexing hint gets used way, way to frequently.  The place that I hate seeing it the most is in financial applications, where...

July 10, 2013  7:00 AM

Preventing Locking, Blocking and Deadlocks in the vCenter database



Posted by: Denny Cherry
SQL Server, vCenter

As our VMware environments become larger and larger with more and more hosts and guests more thought needs to be given to the vCenter...


July 5, 2013  5:02 PM

Recommended reading from mrdenny for July 05, 2013



Posted by: Denny Cherry
SQL Server, Top 10

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.


July 3, 2013  7:00 AM

Backups & the Buffer Pool



Posted by: Denny Cherry
Back To Basics, Backup & recovery, BACKUP DATABASE, SQL Server, Storage

    As we know with Microsoft SQL Server everything is processed from disk and loaded into the buffer pool for processing by the query engine.  So...


June 26, 2013  2:00 PM

Performance Tuning a Spotlight for SQL Server Query



Posted by: Denny Cherry
Database Administration, Execution Plans, Indexing, Nonclustered Index, Quest Software, SoSSE, SQL Server, Table Scan

The other day I was looking at parallel query plans on a customers system and I noticed that the bulk of the parallel queries on the...


June 19, 2013  5:00 PM

A week of using my Surfii (when you have more than one Microsoft Surface)



Posted by: Denny Cherry
Cubby, Microsoft Surface, SQL Server, Surface Pro, Surface RT

So while at the TechEd North America conference Microsoft gave the attendees, speakers and booth staff the ability to purchase some Microsoft Surfii (surf-I)...


June 10, 2013  12:00 PM

SQL Server 2014 Standard Edition High Availability



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Community, Social Commentary, SQL Server, SQL Server 2014

With all the announcements about SQL Server 2014 this last week there have been a lot of questions about what’s going to happen for SQL Server 2014...


June 5, 2013  2:00 PM

What does the RCSI overhead mean?



Posted by: Denny Cherry
AlwaysOn, Availability Groups, Clustered Index, Index, Indexing, Nonclustered Index, SQL Server, Tables

Earlier I posted a blog post which talked about the fact that when you turn on readable secondary replicas there are an


May 28, 2013  4:27 PM

Extra Bytes Per Row With AlwaysOn Availability Groups



Posted by: Denny Cherry
AlwaysOn, Database Administration, Execution Plans, Index, Index Performance, Index Seek, Indexing, SQL Server, SQL Server 2012

One of things to keep in mind with SQL Server 2012 AlwaysOn Availability Groups is that when the availability group has readable secondary replicas any...


May 24, 2013  5:04 PM

Recommended reading from mrdenny for May 24, 2013



Posted by: Denny Cherry
SQL Server, Top 10

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


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: