Microsoft Tackles 'SQL Server Sprawl'

Hewlett-Packard has partnered with Microsoft to introduce a preconfigured system for companies that want to perform analytics on data spread across many SQL Server databases. The HP ConvergedSystem 300 for the Microsoft Analytics Platform can draw structured data from SQL Servers and unstructured data from other sources. Diverse data sets can be brought into Microsoft’s SQL Server Parallel Data […]

SQL Server creates a histogram on the leading key but not on the other columns

the leading key should be the most selective column—number in our case. Allegedly (according to the recommendation), SQL Server creates a histogram on the leading key but not on the other columns; so if you follow the recommendation, the optimizer can produce better cardinality estimates, which tend to lead to more optimal choices. http://sqlmag.com/t-sql/optimization-tips-multiple-range-predicates-part-1

Supratimas – analysis tool for Microsoft SQL Server query execution plans

I found the GREATEST tool ever.. for analyzing SQL Server Query Plans.  I can’t wait to spend some more time with this! http://supratimas.com/ FEATURES Color Coding Nodes with cost of more than one per cent are colored blue. That makes it easier to find them. Output Display number of rows and total size of data […]