In the deep past, SQL 2K time frame, when SQL wish implemented many of my suggests. Since 2008 or so, everything has come back: not common enough. Of course they are considering multi-core processors not common enough, so I regard Connect as a waste time, either work around the problem, or look for another product

I generally do not get involved in high-end SAN systems. It is almost impossible to find meaningful information on the hardware architecture from the vendor. And it is just as impossible to get configuration information from the SAN admin. The high-end SAN is usually a corporate resource managed in different department from the database. ...

this article EMC’s Data Warehouse/Business Intelligence Competency Center Now Open, is dated Dec 2008 http://sqlmag.com/database-administration/emc-s-data-warehousebusiness-intelligence-competency-center-now-open Also, EMC World 2013 starts tomorrow http://www.emc.com/microsites/emcworld/2013/index.htm

Symmetrix is an ''enterprise'' product, whatever that means other than extremely expensive. It may do management tricks. I am of the opinion that enterprise storage is so the SAN admin gets a really expensive toy that will let him/her grant storage with minimum effort or concern to actual storage performance requirements. Because the main line ...

Back in late 2011 to early 2012, I was asked to look into issues for a SQL Server system supporting kCura Relativity. Relativity is an e-discovery platform, that is, a document search management system frequently used for document discovery is legal cases. So it also has auditing to prove that a search was done. Normally I would post ...

Source code is only available for my consulting customers. The code is place to render a treeview of the plan even though this is not visible anymore. It would take some work to render a graph. SQL Sentry already has a product to render Execution plans, so I did not want to duplicate that. Since this is an old post, I suggest you contact me ...

hello Kevin, nice to know there are still other people talking about benchmarks. I second that there is useful information or hints of information in the full reports. Its too bad we have to dig for it. The benchmark reports document, per full disclosure requirements, all the tuning details, but provide very little explanation. One thing I would ...

The unfortunate thing is that when I get to a customer site, almost always the storage system has already been purchased and configured. I have to work with what is already there. Sometimes I try to get it reconfigured, but that means taking the database offline. At one site, they had two EMC Clariion with 210 (possibly 240) 15K disks each. What ...

Many of us have probably seen recent headlines titled Excel Error - major catastrophe, end of the world blah blah blah. No where in any of these is it cited that there was actually an error made by Excel. But if there was a mistake, people would rather imply that it was in the technology, and not the idiot using the technology without checking ...

thanks for clarifying the Fast Cache, EMC has a way of describing features in a way that is confusing, given that the details are not provided, So for both the main line-of-business transaction and DW server, my strong preference on storage is to rely on sheer force of numbers - IO channels and HDD/SSDs, rather than on ''intelligence'' features ...