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
SQL SERVER - Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE

March 17, 2010
Pinal Dave
SQL Tips and Tricks
SQL Documentation, SQL Index, SQL Scripts, SQL Server

We are going to discuss something very simple topic. Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE.

Read More
Gouache painting: on a sports room wall, three identical brass whistles hang in a row from wooden pegs

XML value: Select One Typed Scalar

March 16, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

XML value extracts one typed scalar. Use a singleton path, review conversion, and distinguish first-item selection from uniqueness.

Read More
Execution plan comparison.

SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU

March 15, 2010
Pinal Dave
SQL Performance
SQL Scripts

The MAXDOP query hint limits how many CPUs a query can use, though not which ones. With OPTION (MAXDOP 1), the parallelism operator leaves the plan.

Read More
SQL SERVER - Checklist for Analyzing Slow-Running Queries

SQL SERVER – Checklist for Analyzing Slow-Running Queries

March 12, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

Before you call support, go through this Books Online checklist for analyzing slow-running queries: network, memory, statistics, indexes and more.

Read More
Execution plan.

SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint

March 11, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

How do you force index scan instead of a seek, or read a table without using any index? Two reader questions with a similar answer, using a query hint.

Read More
Execution Plan for Index Seek.

SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index

March 9, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

My T-SQL Tuesday #004 post on how a covered index can improve performance by reducing IO. Run the demo on a test server only, never on production.

Read More
Unmarked wooden spokes radiate from a brass hub toward blue, terracotta and pale stones.

ATN2: Keep the Quadrant When Calculating an Angle

March 8, 2010
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

ATN2 uses two components to calculate an angle while retaining its quadrant. I keep the argument order and angle unit visible. Dividing one component by the other would lose useful information and introduce a zero-denominator case.

Read More
Previous 1 … 262 263 264 265 266 267 268 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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