SQL Server with Mr. Denny:

May, 2011


May 30, 2011  2:00 PM

How to use the WITH MOVE when you don’t know the logical database file names.

Denny Cherry Denny Cherry Profile: Denny Cherry

When doing a database restore and you want to move the physical database files from one disk to another, or from one folder to another you need to know the logical file names.  But if you can’t restore the database how do you get these logical file names?  By using the RESTORE FILELISTONLY...

May 30, 2011  2:00 PM

If you have 12 disks to hold DB Data files and decide to use RAID10, would you create 1 RAID 10 group or 2 RAID 10 groups made of 6 disks each for best read/write performance?

Denny Cherry Denny Cherry Profile: Denny Cherry

I would probably make 2 RAID 10 RAID groups one for the data files, and one for the transaction log.  Without knowing what percentage of data access will be read and what will be write I’m just guessing here.  Depending on the load RAID 5 may work just fine for the data files. Denny


May 26, 2011  2:00 PM

Running on EMC Clarion CX4 – Windows reports disks are not aligned, SAN admin says that because of caching, the partition alignment from windows does not matter (and SAN is setup per "best practices". Is this true?

Denny Cherry Denny Cherry Profile: Denny Cherry

Caching has nothing to do with disk alignment.  It sounds like your sysadmin should have gone to my SQL PASS pre-con.  All the caching does is accept the writes from the host into D-RAM instead of writing to the disk directly. Now if the LUN is aligned on the array by setting the offset on the...


May 23, 2011  2:00 PM

On an EMC array is it possible to assign WRITE cache to wherever your transaction log files are?

Denny Cherry Denny Cherry Profile: Denny Cherry

Yes, provided that your transaction logs have their own LUN from the other files as the write cache is enabled and disabled at the LUN level.  By default read and write cache will be enabled for every LUN which is created on the array. There aren’t to many cases where you would want to...


May 19, 2011  11:00 AM

Should a VMs virtual disks all be on the same storage?

Denny Cherry Denny Cherry Profile: Denny Cherry

A question that comes up when building a new virtual SQL Server is how should the disks be laid out when using the default VMDK (VMware) or vDisks (Hyper-V)?  Should the disks be on a single LUN, or different LUNs, etc. I’m sure that it will surprise no one when I say that it depends.  On a...


May 16, 2011  2:00 PM

Getting rid of those annoying backup successful messages

Denny Cherry Denny Cherry Profile: Denny Cherry

If you have a SQL Server, and you are doing transaction log backups on the database server you’ll notice that 99% of the messages in your ERRORLOG file are worthless.  All they say is that the log was backed up successfully.  Personally I don’t care that every 15 minutes all 30 databases had...


May 13, 2011  7:54 PM

Let your opinion be heard for SQL PASS.

Denny Cherry Denny Cherry Profile: Denny Cherry

I'm a couple days late getting this post out, thanks to being at EMC World, but here it is. This year the PASS Summit is asking for your help in deciding what sessions should be presented at the SQL PASS summit in Seattle later this year.  To do this they have created the


May 11, 2011  4:16 PM

EMC World Day 2 (2011)

Denny Cherry Denny Cherry Profile: Denny Cherry

Yesterday was EMC World day 2 and it was another great day at the conference. I started the day a little late as I was out pretty late on Monday night at a party. I was abe to great some great sessions in during the day however. The first session that I hit was "SQL Server on VMware -...


May 10, 2011  2:00 PM

EMC World 2011 Day 1

Denny Cherry Denny Cherry Profile: Denny Cherry

So today was the first official day of EMC world. I had a great time meeting some fantastic people like Chuck Hollis from EMC. There were also some fantastic sessions. This year EMC is doing something new and putting the sessions online through an iPad app as well as putting them on their...


May 9, 2011  2:00 PM

EMC World 2011 Day 0

Denny Cherry Denny Cherry Profile: Denny Cherry

So today began EMC World 2011.  It started in true EMC style with a great party, sponsored by UniSys.  The party was held at the Hotel pool which seems a little strange but EMC made it work.  It was a little windy last night, apparently not even EMC can control the weather. I met some great...


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: