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 shop window with a clean rectangular section wiped in the condensation, showing part of the display behind

What Is a View in SQL Server?

March 11, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

A view in SQL Server is a saved query, not a saved copy. Nothing is stored, the text is run every time, and that single fact explains what a view is good for and why it never makes anything faster.

Read More
A tile suction lifter moves a ceramic tile between two padded supports

Cleaning Up Ownership Before Dropping a Departed User

March 10, 2012
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

DROP USER fails when the user still owns a schema, a role or a table. Here is how to find those owners and hand them over safely.

Read More
An old metal key rests beside a newer unmarked key on folded plain linen.

Finding Deprecated Features Before They Bite

March 9, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Find deprecated features with SQL Server counters, event metadata, and code searches, then separate future risk from features already removed.

Read More
Create Index on it.

Indexing Basics Course: Learning SQL Server Performance

March 8, 2012
Pinal Dave
SQL Video
Execution Plan, SQL Index, SQL Training

Vinod Kumar and I released an indexing basics course in 2012. This post keeps the original outline and cartoon, and adds tests on SQL Server 2025 for four of its practical topics: column order, functions on indexed columns, filtered indexes and disabled indexes.

Read More
Gouache painting of a database character beside a stopwatch

T-SQL Errors and Reactions Demo: SQL in Sixty Seconds #005

March 7, 2012
Pinal Dave
SQL Video
SQL Error Messages, SQL in Sixty Seconds, SQL Scripts

This T-SQL errors and reactions demo follows episode #002 with queries you can run. It shows what a CATCH block can read, how severity is stored, how to log a failure and keep going, and why THROW keeps the original error while RAISERROR replaces it.

Read More
A saved dressmaking pattern on a hook, fabric and red pins ready on the table

Optimized Plan Forcing: Cutting Compile Time in SQL Server 2022

March 6, 2012
Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL Performance, SQL Server 2022

Check optimized plan forcing in SQL Server 2022 through scoped configuration and Query Store replay flags, then compare compile duration.

Read More
A shallow wooden sorting tray holding plain folded fabric beside a closed storage box on a table.

Why Staging Tables Earn Their Keep

March 5, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, ETL

Use staging tables to preserve raw input, validate changes, separate extraction from publication, and make failed loads easier to diagnose and replay.

Read More
A shelf of thick matching binders in an engineering office, the spines blank.

SQL SERVER – Technical Reference Guides for Designing Mission-Critical Solutions

March 4, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL White Papers

While helping a friend, I found the Technical Reference Guides for Designing Mission-Critical Solutions, an interactive map of architecture guidance.

Read More
SQL SERVER - Various Leap Year Logics

SQL SERVER – Various Leap Year Logics

March 3, 2012
Pinal Dave
SQL Tips and Tricks
SQL DateTime

Dividing by 4 is not enough to find a leap year. Readers shared various leap year logics in the comments, and here are the best of them.

Read More
A flax comb with finished fibers held aside by a small retaining band

Stopping a Trigger From Firing Itself With TRIGGER_NESTLEVEL

March 2, 2012
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

A timestamp trigger that updates its own table can loop until SQL Server gives up. Here is the small guard that stops it, with a demo you can run.

Read More
Previous 1 … 384 385 386 387 388 389 390 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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