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 - First Month as DBA Trainee - Disasters and Recovery

SQL SERVER – First Month as DBA Trainee – Disasters and Recovery

June 14, 2011
Pinal Dave
Personal
Best Practices

For T-SQL Tuesday on disaster and recovery, I share the lessons I learned in my first month as a DBA trainee, like never zipping native backups.

Read More
Two blank upright books stand behind a flat sage-green book topped by a small brass ring.

XQuery Node Order: Compare Source Document Positions

June 13, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

XQuery node order compares positions in an XML document, not their text. Source order, alphabetical order and a node compared with itself give different answers.

Read More
An open wooden case holding a terracotta tile beside blue and pale stones.

geometry STAsBinary: Carry the SRID Beside the WKB

June 12, 2011
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STAsBinary exports a geometry as WKB, while reconstruction takes a separate spatial reference identifier. I carry that identifier beside the bytes. Supplying a different identifier creates a differently tagged value from the same exported coordinates.

Read More
A brass balance scale with two pans holding equal piles of dried beans.

SQL SERVER – Integration Services Balanced Data Distributor – SSIS Balanced Data Distributor

June 11, 2011
Pinal Dave
SQL Tips and Tricks
SQL Documentation, SQL Download, SQL Server, SSIS

The SSIS Balanced Data Distributor (BDD) spreads incoming rows across outputs with multithreading. How it works and the scenarios where it improves performance.

Read More
A hand holds one cloth napkin free of a metal holder while the remaining stack stays inside

Destructive Reads: Pulling Work From a Queue Table With OUTPUT

June 10, 2011
Pinal Dave
SQL Tips and Tricks
Output Clause, SQL Delete, SQL Transactions, Temp Table

Claiming a job and finishing it are two different things. Try a delete claim, a rollback, and an update claim on a tiny queue.

Read More
A tray of cookies in rows with a few missing, fallen to the floor

SEQUENCE Cache Size, Gaps and Insert Throughput

June 9, 2011
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Constraint and Keys, SQL Identity, SQL Server

Compare SEQUENCE cache size, restart gaps, rollback gaps, and insert throughput with CACHE 50, CACHE 1000, and NO CACHE.

Read More
A small wooden sieve beside neatly sorted beans and a separate imperfect bean on a table.

Data Quality Checks Worth Running After Every Load

June 8, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, ETL

Run data quality checks for missing values, duplicate keys, invalid ranges, and count reconciliation before promoting a loaded batch to production.

Read More
Gouache painting: a taut linen thread runs around three wooden pegs set in a board, bending at the second peg into an L-shaped path

geometry STPointN: Read a One-Based Point Position

June 7, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

geometry STPointN selects a point from an instance. The example keeps its one-based position visible and returns NULL when the requested position exceeds the line point count.

Read More
A detailed cabinet opens one fitted compartment of wooden cubes for careful inspection.

Troubleshooting Cube Performance: Three Checks

June 6, 2011
Pinal Dave
SQL Performance
SQL Analysis Services, SQL Extended Events, SQL Monitoring, SQL Performance

Diagnose cube performance by comparing the same MDX query, processing changes and resource pressure before choosing a repair.

Read More
An old paraffin lamp beside a new rechargeable lantern on a porch step

T-SQL Features Added in Recent Versions

June 5, 2011
Pinal Dave
SQL Tips and Tricks
Compatibility Level, JSON, SQL Function, SQL Server, SQL Server 2022

T-SQL features added in recent SQL Server versions shorten common date, comparison, string, and JSON patterns when deployed deliberately.

Read More
Previous 1 … 415 416 417 418 419 420 421 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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