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
Execution Plan test result.

SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example

August 1, 2010
Pinal Dave
SQL Tips and Tricks
Database, SQL Function, SQL Scripts

BINARY_CHECKSUM helps detect changes in a row. My working example shows how it works and why it misses a value changed from A to B and back to A.

Read More
Gouache painting: two squares of leather overlapped in the middle of a cutting table, one slate blue and one cream, offset diagonally

geometry STDifference: Keep the Subtraction Direction

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

geometry STDifference is directional. Two overlapping equal-area rectangles can produce equal remaining areas while retaining entirely different regions.

Read More
SQL SERVER - Check Advanced Server Configuration

SQL SERVER – Check Advanced Server Configuration

July 29, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Configuration, SQL Stored Procedure

How do you Check Advanced Server Configuration values? Turn on show advanced options with sp_configure, run RECONFIGURE, then run sp_configure to list them.

Read More
SQL SERVER - Computed Column - PERSISTED and Storage

SQL SERVER – Computed Column – PERSISTED and Storage

July 27, 2010
Pinal Dave
SQL Tips and Tricks
Computed Column, SQL Data Storage, SQL Scripts, SQL Server

How a computed column is created and why PERSISTED and storage go together: persisted columns take more space. Plus links to the whole series.

Read More
SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char

SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char

July 26, 2010
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

Error 8170 says there is insufficient result space to convert a uniqueidentifier value to char. The simple fix is to give the VARCHAR its full 36 characters.

Read More
SQL SERVER - Find Queries using Parallelism from Cached Plan

SQL SERVER – Find Queries using Parallelism from Cached Plan

July 24, 2010
Pinal Dave
SQL Performance
Best Practices, SQL DMV, SQL Scripts, SQL Server

A script by Feodor Georgiev that finds queries using parallelism from the cached plan, along with their plans. Please avoid running it on a busy production server.

Read More
SQL SERVER - Identifying Statistics Used by Query

SQL SERVER – Identifying Statistics Used by Query

July 19, 2010
Pinal Dave
SQL Performance
SQL Scripts

Can you find the statistics used by query? There is no direct tool or DMV for it, but I explain an indirect way through the indexes a query uses.

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

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