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
Table of columns and datatypes.

SQL SERVER – sp_describe_first_result_set New System Stored Procedure in SQL Server 2012

March 31, 2012
Pinal Dave
SQL Tips and Tricks
SQL Stored Procedure

SQL Server 2012 adds the new system stored procedure sp_describe_first_result_set. I try it on a query and a view to see what metadata it returns.

Read More
SQL SERVER - Online Index Rebuilding Index Improvement in SQL Server 2012

SQL SERVER – Online Index Rebuilding Index Improvement in SQL Server 2012

March 30, 2012
Pinal Dave
SQL Tips and Tricks
SQL Index

Online index rebuilding with VARCHAR(MAX) or NVARCHAR(MAX) columns failed in SQL Server 2008. SQL Server 2012 changes that, and here is my test.

Read More
DatabaseStatus DATABASEPROPERTYEX.

SQL SERVER – Difference between DATABASEPROPERTY and DATABASEPROPERTYEX

March 29, 2012
Pinal Dave
SQL Tips and Tricks

What is the difference between DATABASEPROPERTY and DATABASEPROPERTYEX? I asked on Facebook, and here are the best answers from readers.

Read More
Gouache painting of a coiled measuring ribbon beside two growing stacks of blocks on a craft table.

Compound Assignment Operators in SQL Server: SQL in Sixty Seconds #009

March 28, 2012
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Operator, SQL Scripts, SQL Variable

Compound assignment operators such as += and *= combine an operation with an assignment in T-SQL. The tests here run all eight operators on SQL Server 2025, and show how NULL, integer division, overflow, truncation and precedence change the result.

Read More
Right align numerics SQL Server query execution options.

SQL SERVER – Right Aligning Numerics in SQL Server Management Studio (SSMS)

March 27, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

Numbers in SSMS results are hard to read when they do not line up. Right aligning numerics takes one query option, and I show where to find it.

Read More
Four ladders against separate apple trees in an orchard row, a full basket under each and one cart waiting at the end.

Loading Partitions in Parallel

March 26, 2012
Pinal Dave
SQL Tips and Tricks
ETL, Parallel, SQL Lock, SQL Server, Table Partitioning

Loading partitions in parallel uses separate staging tables, controlled workers, and partition switching to publish data without chaotic locks.

Read More
An open blank book with a plain fabric bookmark beside a natural wooden pencil on a quiet desk.

Getting Through a Technical Book You Actually Finish

March 25, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Read a technical book with a practical question, small SQL experiments, and reusable notes that turn each useful chapter into working knowledge.

Read More
An oyster knife opens one shell beside a row of shells whose meat still needs separate access

Plan Cache Key Lookups: Finding the Worst Ones With XQuery

March 24, 2012
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL Index, SQL XML

Not every key lookup needs fixing. Rank statements by reads, find the lookups with XQuery, then test the smallest index change on one call.

Read More
Gouache painting of a database character beside a stopwatch

MAXDOP 1 in SQL Server: SQL in Sixty Seconds #008

March 23, 2012
Pinal Dave
SQL Video
MAXDOP, Parallel, Query Hint, SQL in Sixty Seconds

MAXDOP 1 requests serial execution for one SQL Server query. I measured four variants of one query on SQL Server 2025, and the serial plan was the slowest in elapsed time with about the same CPU. The post shows the settings behind the hint and how to read the degree of parallelism a query actually used.

Read More
A ski boot remains attached to a ski by a closed heel binding beside the open toe release

Computed Column UDFs: Why Every Query on the Table Goes Serial

March 22, 2012
Pinal Dave
SQL Performance
Computed Column, Execution Plan, Parallel, SQL Function

A computed column that calls a scalar function can block parallel plans for queries that never read it. Here is how to spot it and test a fix.

Read More
Previous 1 … 382 383 384 385 386 387 388 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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