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 glued boards held in red clamps on a workbench while the next board waits.

Waiting for an Agent Job to Finish Before the Next Step Runs

February 9, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Scripts, SQL Server, SQL Server Agent

Wait for an Agent job to finish by polling its current sysjobactivity row, enforcing a timeout, and checking sysjobhistory outcome.

Read More
SQL SERVER - Backup and Restore Database Using Command Prompt - SQLCMD

SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD

February 8, 2013
Pinal Dave
SQL Video
SQL Backup and Restore, SQL in Sixty Seconds, SQL Scripts, SQL Server, sqlcmd

Good DBAs automate the boring work. Here is a simple script to run Backup and Restore of a database from the command prompt with SQLCMD.

Read More
Gouache painting of colored beads spilling from a wooden scoop into a shallow brass-railed tray.

Generate Random Values in SQL Server: SQL in Sixty Seconds #042

February 6, 2013
Pinal Dave
SQL Video
SQL Function, SQL in Sixty Seconds, SQL Random, SQL Scripts

To generate random values in SQL Server, pick the function by the job: RAND for one value, CHECKSUM(NEWID()) for a value on every row, CRYPT_GEN_RANDOM for tokens. The tests here count 100,000 draws and show where the common formulas go wrong.

Read More
An egg poised on a small piercer before cooking

Warning Before SQL Login Passwords Expire With DaysUntilExpiration

February 3, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

A Friday-night login failure is avoidable. One small query warns you weeks ahead, if somebody owns the warning.

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
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 … 192 193 194 195 196 197 198 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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