A data type decides what a column holds, what it costs in bytes, and how SQL Server compares it. Why NVARCHAR doubles your storage, why float will not compare cleanly, and the conversion that quietly kills an index.
SQL SERVER – Extension of the SQL Server Natively Compiled Stored Procedures
What are the .c, .dll, .obj and .pdb files created for Natively Compiled Stored Procedures in SQL Server 2014? A quick list of each extension and what it does.
SQL SERVER – Performance Dashboard – Historic Information
Travels with my daughter taught me the value of history. The Historic Information section of Performance Dashboard does the same for your SQL Server.
SQL SERVER – Database Taking Long Time to Create – Notes from the Field #047
Ever seen a database taking a long time to create? Tim Radney explains in simple words why it happens, based on a real question from a forum.
Current Activity Section: Performance Dashboard Reports Explained
The Current Activity section of Performance Dashboard shows what is running right now, split into user requests and user sessions, taken from two DMVs.
SQL SERVER – SSMS: Performance Dashboard Reports – Home Page details
Here are the Performance Dashboard home page details: lots of server information in one view. I walk through its six sections one after another.
SQL SERVER – SSMS: Performance Dashboard Installation and Configuration
Performance Dashboard reports are free custom reports from the Microsoft SQL Server Support team. Here is the Performance Dashboard installation and setup in SSMS.