SQL Server with Mr. Denny:

Back To Basics


April 2, 2014  5:00 PM

How I Setup TempDB



Posted by: Denny Cherry
Back To Basics, Database Administration, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, TempDB

How TempDB should be setup is a question that comes up a lot, mostly because there is a lot of bad information out there.  So here's how I typically setup TempDB for the bulk of my clients, and these settings will probably work for you as well.

Number of Files

The number of files that...

February 26, 2014  5:00 PM

TechEd 2014 Here I Come



Posted by: Denny Cherry
Back To Basics, Database Administration, SQL, SQL Server, SQL Server 2012, SQL Server 2014, Tech Ed, Tech Ed 2013, Tech Ed 2014, Tech Ed North America

I'm pleased to be able to tell you that I will be speaking at TechEd 2014 North America. This year I'll be giving a very similar...


August 21, 2013  2:00 PM

Back To Basics: Files, File Groups and Disks



Posted by: Denny Cherry
Back To Basics, SQL Server, Storage

SQL Server has three different storage terms which you need to know when dealing with physical file storage.  These...


August 14, 2013  2:00 PM

Back To Basics: Recovery Models



Posted by: Denny Cherry
Back To Basics, Recovery Model, SQL Server

The recovery models tell the SQL Server how much transaction log data to keep within the transaction log, and how much data recovery...


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


December 27, 2011  2:00 PM

Back To Basics: Why isn’t maintenace automatic?



Posted by: Denny Cherry
Back To Basics, Backup & recovery, Recovery, SQL Server

One of the questions which I see pop up from time to time (especially when I used to work for a VAR that wrote software for small businesses) is why doesn't SQL Server do the maintenance automatically?  Things like checking for corruption (DBCC CHECKDB), index defragmentation, backups, etc. The...


August 5, 2011  2:00 PM

The SQL peps are invading the NETDA meeting in Redmond next week



Posted by: Denny Cherry
Back To Basics, In Person Events, NETDA, SQL Server

That's right SQL People, the .NET folks at the Redmond, WA NETDA user group has invited me to come and speak at their user group meeting on Monday August 8th, 2011 in the Building 41 cafeteria on the Microsoft Campus. I'll be giving a session...


April 5, 2010  12:00 PM

Events, events, events. When the hell am I suposed to get work done?



Posted by: Denny Cherry
Back To Basics, In Person Events, Plagiarism, Sean McCown, SQL Server, SSWUG

This week I've got a few speaking events to let everyone know about. On Tuesday April 6th, at 6pm I'll be speaking to the LA C# User Group.  The meeting is held at the Manhattan Beach Library at 1320 Highland Ave in Manhattan Beach, CA 90266.  The group...


March 12, 2009  11:00 AM

Back To Basics: Reading an Execution Plan



Posted by: Denny Cherry
Back To Basics, Execution Plan, Index Performance, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008

All to often when helping people look at query performance problems I'll ask them to look at the execution plan, and see what it says.  Most query performance problems can be resolved simply by looking at the execution plan and seeing where you need to add an index. All to often I (and others)...


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: