SQL Server with Mr. Denny:

SQL Server


April 21, 2011  11:00 AM

Is there a best practice to advise a storage admin how to set a SAN up best for SQL Server OLTP & OLAP? or is this entirely company dependent?



Posted by: Denny Cherry
SQL Server, Storage

There are some general best practices such as separate data and log LUNs, separate TempDB from everything else.  For data warehouses make sure that the data is spread over as many disks as possible.  Anything more specific however is very company specific and would require a good understanding of...

April 18, 2011  2:00 PM

For SQL, best practice is to have data on one array, logs on another array and tempdb on another array. how does this work in san world? SAN people don’t really give all these options when assigning storage for database server.



Posted by: Denny Cherry
EMC, SQL Server, Storage

Even when using a storage array it is typically best practice to have the data on one LUN, logs on another LUN, and tempdb on another LUN.  Especially if you have the option to putting each LUN on different physical disks.  If you I talked a little more about this a


April 14, 2011  2:00 PM

So you’ve changed the text display settings, and SSMS still won’t show more than 256 characters.



Posted by: Denny Cherry
SQL Server, SQL Server 11, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server Management Studio

By default SQL Server Management Studio will only show you 256 characters per column.  The fix for this is pretty easy.  You click on Tools > Options to being up the options menu.  From there navigate to Query Results > SQL Server > Results To Text.  Change the "Maximum number of...


April 13, 2011  1:19 AM

Some job descriptions just have to be shared



Posted by: Denny Cherry
Interview, Job Opening, Social Commentary, SQL Server

So I'm going along doing my work thing, shrinking databases rebooting servers at random, etc. and I get an email some of which I've included below asking if I'd be interested in this job opening.  I've cut out the names, etc. to protect the stupid. Below is the response that I sent...


April 4, 2011  2:00 PM

Can tempdb data and log put on on RAID 1 one physical disk, or keep it separate physical disk?



Posted by: Denny Cherry
SQL Server, Storage, TempDB

It really depends on the amount of load that you put on the tempdb database.  Everything which is done within the tempdb database is going to be logged in the transaction log just like any other database so if the tempdb database has a very high IO then it may make sense to put the tempdb log on a...


March 28, 2011  2:00 PM

MySpace’s failures had next to if not nothing to do with the Microsoft stack or being in LA



Posted by: Denny Cherry
.NET, Social Commentary, SQL Server

If you were on twitter in the last couple of days you may have seen some links to a blog post titled "MySpace's death spiral: insiders say it's due to bets on Los Angeles and Microsoft" in...


March 25, 2011  2:05 PM

Microsoft has made the decision to unleash me on Tech Ed North America



Posted by: Denny Cherry
In Person Events, Manageability, SQL Server, SQL Server 11, SQL Server 2012, Tech Ed 2011, Tech Ed North America

Apparently someone at Microsoft has completely lost their mind.  They have signed me up as a speaker for Tech Ed NA 2011.  I'll be presenting a session titled 'What's New in Manageability for Microsoft SQL Server Code-Named "Denali"'. This is a 300 level session so it will be full of all sorts...


March 25, 2011  2:00 PM

SQL Backup Compression and Backup Dedup are mortal enemies



Posted by: Denny Cherry
Backup & recovery, compression, SQL Server, SQL University, Storage

If you have a modern tape backup solution you probably have some sort of dedup process in your backup environment.  What these deduplication processes do normally is look at the data which is being written to the backup platform and remove duplicate values in order to save space on the tape backup...


March 24, 2011  2:00 PM

What is faster SAN or DAS (local disk), and most importantly why?



Posted by: Denny Cherry
Replication, SQL Server, Storage

So here's an answer to the great myth of SAN, it isn't always going to be faster than local disk (or DAS, JBOD, etc.).  The reason for this is actually pretty straight forward. Local disk is cheap.  That's the reason in a nut shell.  Let me see if I can't explain in a little more...


March 23, 2011  2:00 PM

DAS, NAS and SAN oh my.



Posted by: Denny Cherry
SQL Server, SQL University, Storage

In the server world we have three different kinds of storage available.  Today, only two of these can be used with your SQL Server (as long as you want to keep the SQL Server in a supportable configuration).  Your three options are Direct Attached Storage (DAS), Network Attached Storage (NAS) and...


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: