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
Gouache painting: a cream garment bag hangs from a wooden wardrobe rail, unzipped halfway so a slate-blue jacket shows clearly inside

FOR XML PATH: Decode Escaped Text Through TYPE

January 24, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Scripts, SQL String

FOR XML PATH escapes reserved characters. Use TYPE and scalar extraction to recover text instead of manually replacing entity spellings.

Read More
A child seen from behind against a door frame with pencil height lines, an adult hand marking a new higher line.

Slowly Changing Dimensions in Plain T-SQL

January 23, 2011
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, ETL, SQL Server

Slowly changing dimensions need explicit Type 1 and Type 2 rules; use T-SQL updates and inserts with tests for history and overlap.

Read More
SQL SERVER- Differences Between Left Join and Left Outer Join

SQL SERVER- Differences Between Left Join and Left Outer Join

January 22, 2011
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts

Is there any difference between LEFT JOIN and LEFT OUTER JOIN? A reader asked, and here is the short answer: none at all, they are the same.

Read More
A thick bound volume open flat with a brass page marker across it

SQLAuthority News – 1600 Blog Post Articles – A Milestone

January 21, 2011
Pinal Dave
SQLAuthority News

This blog now has 1600 blog post articles. To mark the milestone I share a few statistics, like 22 million views and 6200 feed subscribers, and thank my readers.

Read More
A bakery counter where cooled loaves are sold from the shelf while a fresh tray cools on a rack behind the counter.

Loading a Fact Table Without Blocking Reports

January 20, 2011
Pinal Dave
SQL Tips and Tricks
Data Warehousing, ETL, SQL Lock, SQL Server, Table Partitioning

Loading a fact table without blocking reports calls for isolated staging, aligned partition switching, short locks, and a tested reader path.

Read More
SQL SERVER - Shrinking Database is Bad - Increases Fragmentation - Reduces Performance

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance

January 19, 2011
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Server DBCC

Shrinking database is bad: it increases fragmentation and reduces performance. Here is a simple example with two tables that shows it step by step.

Read More
Three ivory bowls hold blue pebbles or remain empty, beside a walnut piece and red cord.

TRY_CAST: Parse Failure and Prohibited Conversion

January 18, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Server

TRY_CAST helps classify bounded integer text while preserving missing input separately. A prohibited int-to-xml request still needs error handling. A narrow text target can succeed while discarding characters.

Read More
SQL SERVER - A Funny Cartoon on Index

Index Write Cost: What Each New Index Adds to an INSERT

January 17, 2011
Pinal Dave
SQL Performance
SQL Index, SQL Performance, Transaction Log

Index write cost is the part of the create-an-index advice that the cartoon leaves out. This test inserts the same 20,000 rows with no extra index, one and three, and measures the log written each time. It also shows what the index saved on a lookup, so you can weigh both sides.

Read More
A maypole with five ribbons stretched out to stakes around it like a star

Star Schema Queries and How SQL Server Runs Them

January 16, 2011
Pinal Dave
SQL Performance
ColumnStore Index, Data Warehousing, Execution Plan, SQL Joins, SQL Server

Star schema queries join a large fact table to focused dimensions; learn bitmap filters, columnstore, and indexes that support the real workload.

Read More
A long wooden seed drawer with equal compartments, two hands lifting one out whole while an empty one waits at the end.

Partitioning a Large Fact Table

January 15, 2011
Pinal Dave
SQL Tips and Tricks
Data Warehousing, SQL Index, SQL Server, Table Partitioning

Partitioning a large fact table can simplify loading and retention when boundaries, aligned indexes, and switch rules are designed together.

Read More
Previous 1 … 430 431 432 433 434 435 436 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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