SQL Server with Mr. Denny:

Database Administration


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

March 12, 2014  5:00 PM

Learn Before You Plan



Posted by: Denny Cherry
Data Normalization, Database Administration, Database Design, Query tuning, SQL, SQL Server, SQL Server stored procedures, T/SQL, Tables

Walking into a new shop every couple of weeks has its challenges. What sort of problems are they going to throw at me. Recently I had the...


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


February 12, 2014  2:00 PM

How Much Is That Query Costing?



Posted by: Denny Cherry
Database Administration, Execution Plans, Indexing, SQL, SQL Server

When we think about the cost of the query we typically think about the cost which SQL Server assigns to execute the query. However when we look at performance tuning queries there is another cost that we need to think about. This additional cost is the cost to the company while the query is...


January 29, 2014  2:00 PM

Log Shipping Databases and Permissions Problems



Posted by: Denny Cherry
Attaching Database, Data Security, Database, Database Administration, Error 3013, Error 3119, Error 4319, Full Recovery Model, Log Shipping, Recovery Model, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Recently I was doing log shipping for a client in preparation to move their databases from one data center to another, when I was asked to change the drive that one of the target databases was being restored to. No problem, I'll just use ALTER DATABASE ... MODIFY FILE (name='xxx',...


January 15, 2014  2:00 PM

Fixing TempDB database problems when starting SQL using a minimum config



Posted by: Denny Cherry
Data Loss, Database, Database Administration, SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, T/SQL, TempDB

So the other day I typo'ed something. Usually this isn't that big a deal, but in this case when fixing tempdb for a customer I told SQL to put two logical files into the same physical file. I was able to get it to let me do this because I first added the files, then realized that I had put them...


January 7, 2014  8:46 AM

SQL 2012 Cluster, Windows 2012 R2 OS, Windows 2008 R2 Domains



Posted by: Denny Cherry
Allan Hirt, AlwaysOn, Clustering, Database, Database Administration, DataCenter, Error 1069, Error 1194, High Availability, Microsoft Cluster Service, Microsoft Windows, MSCS, SQL Server, SQL Server 2012, SQL Server 2014, Windows 2008 R2, Windows 2012 R2

Recently I was installing SQL Server 2012 on a new Windows 2012 R2 cluster for a client and ran across a bit of a problem. When the SQL Installer was attempting to start SQL Server for the first time SQL Server was throwing Windows errors 1069 and 1194 which basically say...

Cluster...


January 2, 2014  2:00 PM

Why would I want to use a non-durable in memory table?



Posted by: Denny Cherry
Database Administration, Database Design, In Memory Tables, Non-Durable In Memory Tables, SQL, SQL Server, SQL Server 2014, Tables, Transaction Log

With SQL Server 2014 we were introduced to in memory tables, and specifically the ability to use non-durable in memory tables....


December 26, 2013  4:00 PM

Indexes on forign keys can make a big difference



Posted by: Denny Cherry
CREATE INDEX, Database Administration, Indexing, Nonclustered Index, SQL, SQL Server, Tables

It's amazing just how much difference having a non-clustered index on the child table of a foreign key can matter when the foreign keys have cascading...


December 18, 2013  2:00 PM

Encryption and Compression



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Data Loss, Data Security, Database, Database Administration, Database security, Indexing, Security, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, Storage, Tables

We have a variety of options when it comes to compression and encryption in SQL Server. When using both compression and encryption you...


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: