Want an upper case shortcut in SSMS? Select a keyword and press CTRL+SHIFT+U to make it upper case, or CTRL+SHIFT+L to make it lower case.
SQLAuthority News – I am Microsoft Certified Trainer (MCT)
I am a Microsoft Certified Trainer and proud of it. This post shows how strict bureaucratic rules can make a well confirmed training project crash.
SQL SERVER – PowerShell Version Info
Two commands show your PowerShell version: $PSVersionTable and $host. Only one worked on Version 1, so I ask PowerShell experts to explain why.
SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats
How many pages does an index use, and how many B-Tree levels does it have? sys.dm_db_index_physical_stats shows index levels, page count and record count.
SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan
Want to share a graphical execution plan? Save it as a .sqlplan file and send it. Anyone can open it in SSMS without the tables or indexes behind it.
SQL SERVER – Parallelism – Row per Processor – Row per Thread
Do all processors handle an equal number of rows in a parallel query? The execution plan properties show the actual row per thread count, so you can check.
XML query: Keep the Selected Markup Intact
XML query retains selected markup and attributes. Distinguish an empty fragment from a missing document, and review the display type.