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
SQL SERVER - SSMS 2012 Reset Keyboard Shortcuts to Default

SQL SERVER – SSMS 2012 Reset Keyboard Shortcuts to Default

November 5, 2011
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio

Someone changed the keyboard shortcuts in my SSMS 2012 at a conference. Here is how to reset keyboard shortcuts back to the default settings.

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
Rinsed empty milk bottles on a doorstep at dawn waiting for reuse, one still wearing a red foil cap.

Temp Table Caching: Why Some Temp Tables Get Reused

November 1, 2011
Pinal Dave
SQL Performance
SQL Server, SQL Statistics, SQL Stored Procedure, SQL TempDB, Temp Table

Understand temp table caching in stored procedures, avoid cache blockers, inspect creation counters, and review retained statistics.

Read More
Gouache painting of a row of pebbles, a notched stick, a clay pot and a small red cabinet of drawers on a table

Relational, Document, Graph and Vector: Choosing the Right Data Model

November 1, 2011
Pinal Dave
SQL Tips and Tricks
Database, JSON, NoSQL, SQL Scripts

Choosing the Right Data Model means matching the shape of your data to the questions you ask. This post stores one bookshop four ways in SQL Server 2025, with relational tables, JSON documents, graph tables and a vector column, and runs the question each one answers best. It ends with a rule for choosing.

Read More
Previous 1 … 397 398 399 400 401 402 403 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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