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
Two rows of tulips, one all red and one in randomly mixed colors.

Generating Random Numbers Per Row: RAND, NEWID and CRYPT_GEN_RANDOM

February 2, 2013
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function, SQL Random, SQL Server

Generate random numbers per row with NEWID or CRYPT_GEN_RANDOM, compare seeded RAND, inspect bucket spread, and pick a row without a sort.

Read More
SQL SERVER - Difference Between NOLOCK and NOWAIT Hints

SQL SERVER – Difference Between NOLOCK and NOWAIT Hints

February 1, 2013
Pinal Dave
SQL Tips and Tricks
Query Hint, SQL Lock, SQL Scripts, SQL Server

Should you use NOLOCK when NOWAIT errors out on a lock? Here is the difference between NOLOCK and NOWAIT, and why neither guarantees a valid answer.

Read More
A wall hatch in a kitchen pass with an entire loaded tray being sent through in one movement.

SQL SERVER – Significance of Table Input Parameter to Stored Procedure

January 31, 2013
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure

Pass a whole table into a stored procedure instead of forming and parsing XML. Here is why a table input parameter to stored procedure saves round trips.

Read More
Gouache painting of a jumbled heap of pencils beside a neat row with a red pencil sharpener between them

Autocomplete and Code Formatting in SSMS: What Works Today

January 30, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Coding Standards, SQL Server Management Studio, SQL Shortcut

Autocomplete and code formatting save time and prevent mistakes when they are set up well. This post covers the IntelliSense features in SSMS, the reasons they stop working, a simple formatting style, and a tested look at what formatting changes in the plan cache.

Read More
A hand threading loose bagels from a tray onto one long red string at a bakery stall

JSON_ARRAYAGG and JSON_OBJECTAGG: Building JSON From Rows in SQL Server 2025

January 29, 2013
Pinal Dave
SQL Tips and Tricks
JSON, SQL Function, SQL Server

Build customer arrays with JSON_ARRAYAGG and settings objects with JSON_OBJECTAGG in SQL Server 2025, with explicit order and null rules.

Read More
Set lock timeout' dialog window.

SQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query

January 28, 2013
Pinal Dave
SQL Performance
Query Hint, SQL Lock

SET LOCK_TIMEOUT works at the connection level, like the NOWAIT hint does for a query. I show how setting it to 0 stops a query from waiting on a lock.

Read More
A single brick building with four separate front doors in a row along the pavement, each with its own doormat and letter slot.

SQL Server Instance or Database: What Is the Difference?

January 27, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

A SQL Server instance is the engine and a database is one set of data inside it. What each level owns, why a login and a user are different objects, and which line to draw when you separate customers or teams.

Read More
A lit front parlour in use while the rooms beyond still sit under white dust sheets.

Piecemeal Restore: Bringing the Primary Filegroup Online First

January 26, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL High Availability, SQL Server

Rehearse a piecemeal restore that brings PRIMARY and current data online first, then restores archive filegroups with the right log chain.

Read More
SQL Server Query Execution Plan.

SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query

January 25, 2013
Pinal Dave
SQL Performance
Query Hint, SQL Lock

Everybody knows NOLOCK, but not everyone knows NOWAIT. A question at a Bangalore User Group session led me to explain how NOWAIT skips waiting on a lock.

Read More
A line of standing dominoes interrupted by one solid wooden block set across the run.

SQL SERVER – How to Use Instead of Trigger

January 24, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Trigger

Triggers come in two kinds, Instead of and After. Here is how an Instead of Trigger can intercept an insert, update or delete on a table, with an example.

Read More
Previous 1 … 351 352 353 354 355 356 357 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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