Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

December, 2010

12
December 6, 2010  2:00 PM

Microsoft SQL Server’s MDS has come a long way.



Posted by: Denny Cherry
SQL Server, SQL Server 11, SQL Server 2008 R2

OK, now that I have your attention pretty much nothing has changed in Denali's Master Data Services.  The install procedure is a bit different now but that is about it.  To install the Denali version of MDS just run through the normal SQL Server installer.  When you get to the service list page...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

December 2, 2010  2:00 PM

Will separation of data file and log file of SQL sever help if all are on the SAN? From performance perspective not management.



Posted by: Denny Cherry
EMC, IBM, SQL Server, Storage

Most likely yes, but it really depends on the storage array and the storage array configuration.  If the array is a shared everything array like an IBM XIV then their may not be any benefit to breaking everything onto separate disks as each LUN is spread over every spindle in the device.  However...

  Bookmark and Share     2 Comments     RSS Feed     Email a friend

12