SQL Server with Mr. Denny:

Database


August 7, 2013  2:00 PM

Back To Basics: Statistics



Posted by: Denny Cherry
Back To Basics, Index Performance, Index Scan, Index Seek, Indexing, SQL Server, Statistics

Statistics are magical little objects within the database engine that have the ability to make your queries run fast or painfully slow.  The...

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


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


March 13, 2013  2:00 PM

Deleting LOB Data and Shrinking the Database



Posted by: Denny Cherry
Andre Kamman, Database, Database Administration, DBCC PAGE, Mladen Prajdić, Paul Randal, SQL Saturday, SQL Saturday 194, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, System Objects, Tables

While attending SQL Saturday 194 in Exeter over in England one of the attendees came to Mladen...


February 28, 2013  9:00 AM

Get a discount when attending the SQLPASS BA Conference



Posted by: Denny Cherry
Database, PASS, PASS SIG, SQL PASS, SQL PASS 2013, SQL PASS BA CON 2013, SQL Server

The SQLPASS BA Conference is coming up in April, just a few short weeks from now.  At this conference you'll see some of the


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


January 2, 2013  2:00 PM

Blog Year 2012 In Review



Posted by: Denny Cherry
Community, Database, Social Commentary, SQL Server

Welcome my friends to the first official work day of the year 2013.  You enjoying that hangover yet?
It is time again to...


December 26, 2012  2:00 PM

Cross Database Chaining



Posted by: Denny Cherry
Data Security, Database, Database security, Security, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Cross database chaining in SQL Server is actually a fairly old feature, first introduced in SQL Server 2000 SP3.  However this feature isn't often understood mostly because it isn't often used. Database chaining is when permissions cascade from one object to another because they are used by the...


December 19, 2012  2:00 PM

Moving a Sharepoint Site Between Farms With Different Templates



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Database, PowerShell, SharePoint, SharePoint 2012, SQL Server

A client came to be with a pretty scary problem.  Their SharePoint site was totally down.  The databases were there but the actual SharePoint farm was totally dead.  All of the SharePoint tools said that the farm wasn't configured yet so there were some pretty big problems.  Thankfully they had...


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: