SQL Server with Mr. Denny:

SQL Server


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


May 22, 2013  2:00 PM

The Optimizer Isn’t As Smart As You Might Want It To Be



Posted by: Denny Cherry
Database, Database Design, Index Performance, Performance, Performance Problems, Problems, SELECT statement, SQL Server, SQL Server 2008 R2, Stored Procedures, T/SQL, Tables

A little while back I got one of those phone calls.  You know the one, the lovely 6am phone call about random performance problems.  There were two...


May 17, 2013  5:04 PM

Recommended reading from mrdenny for May 17, 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


May 15, 2013  2:00 PM

Error Handeling and DBCC CHECKDB



Posted by: Denny Cherry
Database Administration, Error Message, ERRORLOG, SQL Server, SQL Server stored procedures, Stored Procedures

A client that I've been working at for a while needed to start doing DBCC CHECKDBs on their production server.  We hadn't been for a little...


May 5, 2013  2:38 PM

Two Factor Authentication Shouldn’t Depend on One Factor



Posted by: Denny Cherry
Bank of America, Data Security, Security, Social Commentary, SQL, SQL Server, Technology, Two Factor Authentication

Bank of America has decided to implement two factor authentication on their website when doing specific things like adding a remote...


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: