This article shows how to use ApexSQL Complete, a free intellisense add-in. You can download ApexSQL Complete, and play along through the article.
“What is the difference between SQL Login and SQL User in SQL Server?”
The next in line in this series of reports is the “ Memory Consumption ” Report from SQL Server Management Studio. This is a goldmine of a report in my humble opinion and lesser respected. When I used to be consulted or land into performance tuning exercises for customers in the past, there is one question that gets repeated and echoed every now and then – “My SQL Server is eating away my RAM and it is not releasing it back even in non-peak hours”.