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
An SQL Server results window.

SQL SERVER – Introduction to CUME_DIST – Analytic Functions Introduced in SQL Server 2012

November 8, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

An introduction to CUME_DIST, a new analytic function in SQL Server 2012 that returns the cumulative distribution of a value, with an example.

Read More
A fish scaler beside two headless fillets with smooth and overlapping scaled skin

Checking Data Compression Settings on Every Table and Index

November 7, 2011
Pinal Dave
SQL Performance
Database, SQL Scripts, SQL Server

A table is not simply compressed or not. Here is how to read the setting for each index and partition, and the mistake that leaves indexes full size.

Read More
SQL SERVER - Updating Data in A Columnstore Index

SQL SERVER – Updating Data in A Columnstore Index

November 6, 2011
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts

A reader got an error when updating data in a columnstore index table. Here is why the table becomes read-only and what you can do about it.

Read More
Wool carders beside eight nearly equal bundles of cream wool

Splitting Work Into Equal-Sized Batches With NTILE

November 4, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

NTILE deals 100 customers into eight batches in one query. The catch is keeping those batches stable while new rows arrive.

Read More
An open blank notebook with several plain bookmarks beside a small magnifying glass on wood.

How to Read a Stored Procedure You Did Not Write

November 4, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Learn to read stored procedure code by tracing inputs, writes, transactions, errors, and dependencies before trying to understand every line.

Read More
Two plain ceramic mugs beside an open blank notebook and pencil on a quiet wooden table.

Interview Questions That Actually Reveal SQL Skill

November 3, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Use SQL Server interview questions that reveal reasoning about joins, NULLs, performance, and recovery instead of rewarding memorised trivia.

Read More
A fitted spaetzle maker shapes pale batter into evenly sized pieces

CODEPAGE 65001: Importing UTF-8 Text Files Without Garbled Accents

November 2, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

Your import turned Élodie into odd symbols. Here is how CODEPAGE 65001 fixes the reading, and why the column type still matters.

Read More
Previous 1 … 214 215 216 217 218 219 220 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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