May 13, 2011 7:54 PM
Posted by: Denny Cherry
SQL PASS,
SQL PASS 2011,
SQL Server,
Stacia MisnerI'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
Posted by: Denny Cherry
EMC World,
EMC World 2011,
GreenPlum,
SQL Server,
VMware,
VNX,
VNXeYesterday 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
Posted by: Denny Cherry
EMC World,
EMC World 2011,
SQL ServerSo 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 5, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
StorageI would say that the SAN admins are nuts if they think that the DBAs aren’t going to worry about storage performance. There is no magic SAN dust which keeps everything running fast all of the time. If you put enough load on the array then performance will be impacted, no matter how many disks...
April 25, 2011 2:00 PM
Posted by: Denny Cherry
Index,
Index Scan,
Index Seek,
SQL Server,
StorageThere are a few things which you will want to look at. First make sure that you have enough RAM for the database to use. Without enough RAM in the SQL Server you’ll begin putting extra load on the disks because the same data is being pulled into the buffer cache from the disk over and...
April 21, 2011 11:00 AM
Posted by: Denny Cherry
SQL Server,
StorageThere 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
Posted by: Denny Cherry
EMC,
SQL Server,
StorageEven 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
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 StudioBy 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
Posted by: Denny Cherry
Interview,
Job Opening,
Social Commentary,
SQL ServerSo 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...
