SQL Server with Mr. Denny:

SQL Server 2008 R2


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

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


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


December 11, 2013  2:00 PM

Clustering in Amazon EC2 – Tomorrow!



Posted by: Denny Cherry
Clustering, Database, Database Administration, DataCenter, High Availability, Microsoft Cluster Service, Microsoft Windows, MSCS, Recovery, Server Hardware, SIOS Technologies, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Tomorrow (December 12th) at noon Pacific Time I'm presenting a session with SIOS Technologies on using their SANLess Clustering Technology to build a clustered SQL Server for High Availability within Amazon's EC2 cloud. This session is...


October 30, 2013  2:00 PM

TempDB latch timeouts with lots of RAM



Posted by: Denny Cherry
Blocking, Database Administration, Microsoft CSS, RAM, SQL Server, SQL Server 2008 R2, TempDB

Recently I had an interesting problem where the SQL Server 2008 R2 instance would randomly in the middle of...


October 27, 2013  2:00 PM

If you could give an aspiring DBA just one piece of advice what would it be?



Posted by: Denny Cherry
Database, Database Administration, ITKE grandparent, SQL PASS, SQL Saturday, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Probably the best advise that I could someone entering the field of Database Administration would be to keep learning. If you think that you know...


October 16, 2013  2:00 PM

Replication and VLFs



Posted by: Denny Cherry
Database, Replication, SQL Server, SQL Server 2008 R2, Storage, System Objects, Transaction Log

Every once in a while you run across a problem that shouldn't be causing people as much problems as it is, yet there it is causing all sorts of problems for long...


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 27, 2013  2:00 PM

Using Event Viewer Logging for SSIS Performance Trouble Shooting



Posted by: Denny Cherry
BIDS, SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SSIS

So while working with a client recently I was going some performance tuning on SSIS for them.  While SSIS isn't exactly my normal workload, the...


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: