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 long wooden peg board with a row of round pegs and one empty hole in the row, a red peg standing just past the gap.

Identity Column Quiz: Why Did My IDs Skip a Number?

January 4, 2012
Pinal Dave
SQL Puzzle
SQL Constraint and Keys, SQL Identity, SQL Table Operation, SQL Transactions

This Identity Column Quiz starts with three rows and one rolled-back insert, then asks what ID the next row gets. The answer is 5, not 4. A tested script proves it and shows two more ways numbers go missing.

Read More
A hand checking an unlit firework rocket standing in a bottle on a garden wall, the matches still closed.

SET NOEXEC and PARSEONLY: Checking a Script Without Running It

January 4, 2012
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Dependency, SQL Server, SQL Stored Procedure

Use PARSEONLY and NOEXEC to inspect scripts without executing them, understand deferred references, and check existing module dependencies.

Read More
A wooden door with three brass bells hanging on cords, each with a small red tassel.

Types of Triggers Quiz: Which Trigger Can Fire on a View?

January 3, 2012
Pinal Dave
SQL Puzzle
SQL Error Messages, SQL Table Operation, SQL Trigger, SQL View

This Types of Triggers Quiz asks which trigger you can put on a view that joins two tables. The answer is INSTEAD OF INSERT. A tested script shows the error an AFTER trigger gives and how the working trigger splits one insert into two tables.

Read More
A writing desk by a window with a half-written letter and a red fountain pen resting on it, an empty chair pulled up close.

ANSI Isolation Levels Quiz: Which Level Lets You Read Uncommitted Data?

January 2, 2012
Pinal Dave
SQL Puzzle
Snapshot, SQL Lock, SQL Transactions, Transaction Isolation

This ANSI Isolation Levels Quiz asks which level lets one session read a price that another session has not committed. A two-window test on SQL Server 2025 shows what each level returns. It also shows how READ COMMITTED SNAPSHOT removes the wait.

Read More
Interview

SQL SERVER – Interview Questions and Answers – Perspectives of an Author

January 1, 2012
Pinal Dave
SQL Interview Questions and Answers
SQL Server

Today is the first day of year 2012 – Happy New Year!. This blog post is written by my co-author of SQL Server Interview Questions.

Read More
Painting of an old stone village well on a sunny morning, with five wooden buckets waiting on the flagstones and one vermilion bucket drawn up full of water

Give It Away: Why Sharing What You Know Makes You Better

December 31, 2011
Pinal Dave
Personal
Blogging, Career Advice, SQL Training

Sharing what you know does not empty you. Like a village well, knowledge fills faster the more people draw from it. A year of publishing every day taught me why giving it away makes the giver better.

Read More
Gouache painting of three books beside a notebook, fountain pen and warm drink on a writing desk

SQLAuthority News – A Quick History of Writing Three Books in Year 2011

December 30, 2011
Pinal Dave
Personal
SQLAuthority Book Review

Writing three books in 2011 grew from years of answering questions and writing every day. This personal account looks back at emails, research, blogging and workbooks at home.

Read More
A striped wool blanket over a chair, its stripes blending into the wall behind

SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow

December 29, 2011
Pinal Dave
Personal

My year end brain teaser in two parts: find the hidden tiger in a picture, and explain why a disabled login’s user shows no red arrow.

Read More
Server properties window.

SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup

December 28, 2011
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore

A reader’s database backup got much smaller with no code change. The reason was the compressed backup setting at the server level. Here is the story.

Read More
Recovery Broker options.

SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012

December 27, 2011
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Function

Target Recovery Time is a new database option in SQL Server 2012. Set it above 0 and SQL Server uses indirect checkpoints to limit recovery time.

Read More
Previous 1 … 391 392 393 394 395 396 397 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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