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.
A Monthly Health Check You Can Run in Ten Minutes
Run a SQL Server health check that reviews backups, integrity-check evidence, file growth, users, build level, and space without guessing health.
SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian
Getting NULL when reading a value from XML? Most of the time the XPath expression is wrong. A guest post by Jacob Sebastian on writing it correctly.






