A lesser known SSMS trick: drag and drop from Object Explorer into the query window to get table and column names typed for you. Handy for documentation.
SQL SERVER – SSMS – Script Out Multiple Objects
Do you script objects one at a time in SSMS out of habit? There is a quicker way to script out multiple objects in one go, and here is how.
Special Icon on System-Versioned Table in SQL Server 2016 – Interview Question of the Week #101
Expanding tables in WideWorldImporters in SSMS 2016, you see an icon like a watch. It marks a System-Versioned table, also known as a temporal table.
SQL SERVER Management Studio – Taking DB Offline Made Easier
A train ride with my family got me looking at familiar things with fresh eyes, like how SSMS now makes taking a database Offline easier. Here is how.
How to Find Longest Running Query With Execution Plan – Interview Question of the Week #098
How do you find the longest running query with execution plan in SQL Server? Here is a quick DMV query that returns the top 10 along with their plans.
SQL SERVER – Cannot Show Requested Dialog – Property Size is Not Available for Database
Opening tempdb properties in SSMS gave ‘Property Size is not available for Database’. The usual owner fix does not work on tempdb. Here is what did.
SQL SERVER – Configuring Startup Options for SQL Server Management Studio
SSMS is the first thing I open every day. Here is how to configure the Startup Options in SQL Server Management Studio so it opens the way you work.