Tag Archives: server

SQL SERVER – How to setup Database mail using FREE mail accounts

great article.. LOVE doing this.

Posted in SQL Server | Tagged , , , , | Comments Off on SQL SERVER – How to setup Database mail using FREE mail accounts

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 … Continue reading

Posted in SQL Server | Tagged , , , | Comments Off on Microsoft Tackles 'SQL Server Sprawl'

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 … Continue reading

Posted in SQL Server | Tagged , , , , , | Comments Off on SQL Server creates a histogram on the leading key but not on the other columns

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 … Continue reading

Posted in SQL Server | Tagged , , , , , | Comments Off on Supratimas – analysis tool for Microsoft SQL Server query execution plans

What is your favorite version of SQL Server?

I know that there are a lot of SQL Server editions out there.. What is your favorite?  Why? [polldaddy poll=5428631]    

Posted in Uncategorized | Tagged , , | Comments Off on What is your favorite version of SQL Server?