This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Save As dialog box.

SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan

July 3, 2010
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Scripts, SQL Server Management Studio, SQL XML

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.

Read More
Execution Plan Properties.

SQL SERVER – Parallelism – Row per Processor – Row per Thread

July 2, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio

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.

Read More
Gouache painting: on a market stall board a short branch of tomato vine has just been cut by a small knife, keeping its green stem, two leaves and a cluster of ripe red tomatoes still attached

XML query: Keep the Selected Markup Intact

July 1, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

XML query retains selected markup and attributes. Distinguish an empty fragment from a missing document, and review the display type.

Read More
SQL SERVER - Outer Join Not Allowed in Indexed Views

SQL SERVER – Outer Join Not Allowed in Indexed Views

June 29, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Joins, SQL Scripts, SQL Statistics

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.

Read More
SQL SERVER - Default Statistics on Column - Automatic Statistics on Column

SQL SERVER – Default Statistics on Column – Automatic Statistics on Column

June 28, 2010
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts, SQL Server

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.

Read More
A compact first-aid tin stands open with neatly arranged plain bandage rolls on a shelf.

A Monthly Health Check You Can Run in Ten Minutes

June 25, 2010
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Run a SQL Server health check that reviews backups, integrity-check evidence, file growth, users, build level, and space without guessing health.

Read More
SQLAuthority News - Guest Post - SELECT * FROM XML - Jacob Sebastian

SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian

June 23, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL XML

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.

Read More
Previous 1 … 254 255 256 257 258 259 260 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com