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.
SQL SERVER – Outer Join Not Allowed in Indexed Views
Why is OUTER JOIN not allowed in indexed views? A reader was confused by the white paper answer, so I explain it with an example and ask for yours.
SQL SERVER – Default Statistics on Column – Automatic Statistics on Column
Does a column need an index to have statistics? No. A quick demo shows automatic statistics on column data when AUTO_CREATE_STATISTICS is on.