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
A wooden mannequin in a red helmet slides safely down a railed slide while another gives a thumbs up

Stop Blaming the User: Let Constraints Catch Bad Data

July 23, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Developer, SQL Constraint and Keys, SQL Humor

Blaming the user is the oldest joke in IT. Here’s why it fails, and how NOT NULL, CHECK, UNIQUE and foreign keys stop bad data before it lands.

Read More
A cobbler's bench with a worn standard shoe last and a freshly carved custom last among wood shavings.

OPTIMIZE FOR and RECOMPILE Hints Compared

July 22, 2010
Pinal Dave
SQL Performance
Execution Plan, Parameter Sniffing, Query Hint, Recompile, SQL Server

OPTIMIZE FOR and RECOMPILE address parameter-sensitive plans differently; compare stable representative values with per-run compilation cost.

Read More
Rich still life of an open blank folio with a red bookmark and four closed slate and sage books.

Keyset Paging: Continue After a Date and ID Cursor

July 21, 2010
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Index, SQL Performance, SQL Server

Keyset paging continues after a saved ordering key instead of counting past an offset. A date and unique ID together keep equal-date rows in the sequence. A guarded disposable fixture makes the boundary conditions explicit.

Read More
SQL SERVER - SELECT * FROM dual - Dual Equivalent

SQL SERVER – SELECT * FROM dual – Dual Equivalent

July 20, 2010
Pinal Dave
SQL Tips and Tricks
Oracle

Oracle developers often miss the DUAL table in SQL Server. I explain what DUAL is, why SELECT * FROM dual fails with Msg 208, and the dual equivalent to use.

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
A travel plug held in front of a wall socket of a different shape, with the right adapter resting on a shelf below

Fast Exports With bcp

July 18, 2010
Pinal Dave
SQL Tips and Tricks
Command Line, CSV, SQL Server, SQL Utility

Fast exports with bcp compares native and character files, shows a format file, and explains where batch size helps and how to check a large export.

Read More
Garden edging with the flowers outside the ring and bare soil inside

Fixing Invalid Geography Polygons and Ring Orientation

July 17, 2010
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Datatype, SQL Server

Diagnose invalid geography polygons with STIsValid and IsValidDetailed, repair with MakeValid, and check ring orientation and EnvelopeAngle.

Read More
SQL SERVER - Datetime Function TODATETIMEOFFSET Example

SQL SERVER – Datetime Function TODATETIMEOFFSET Example

July 16, 2010
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

A quick example of the datetime function TODATETIMEOFFSET in SQL Server, and how it differs from SWITCHOFFSET when offsets change.

Read More
SQL Server offset settings.

SQL SERVER – Datetime Function SWITCHOFFSET Example

July 15, 2010
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts

SWITCHOFFSET changes a datetimeoffset value from its stored time zone offset to a new one. Here is a quick example of how it works in SQL Server 2008.

Read More
A figure with a metal detector digging at the first spot near the dunes, a vast unexplored beach beyond.

Row Goals: Why TOP and EXISTS Change the Plan

July 14, 2010
Pinal Dave
SQL Performance
Execution Plan, Query Hint, SQL Performance, SQL Server, SQL Top

Inspect row goals from TOP and EXISTS, read EstimateRowsWithoutRowGoal, and compare a targeted optimizer hint using actual plans.

Read More
Previous 1 … 449 450 451 452 453 454 455 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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