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 chalk line reel beside a persistent blue mark and cord ready for another snap

The Outbox Table: Publishing Changes Reliably From a Transaction

March 4, 2014
Pinal Dave
SQL Tips and Tricks
Output Clause, SQL Lock, SQL Transactions

Orders commit and the message vanishes? Save both in one transaction, then let a worker claim, send and retry with a lease. Duplicates are still possible.

Read More
A kitchen drawer crammed with rolled canvases so full it cannot close

Storing Images in varbinary(max): Size, Reads and Backups

March 3, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Datatype, SQL Server

Store images in varbinary(max), read file bytes with OPENROWSET, inspect LOB allocation, and evaluate backup and retrieval costs.

Read More
Displaying table and columns for SQL query.

SQL SERVER – Listing Primary Key of Table with Stored Procedure sp_pkeys

March 2, 2014
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys

Here is how to list the primary key of a table with the stored procedure sp_pkeys, a follow up to my earlier post on sp_fkeys.

Read More
Sp_fkeys output window.

SQL SERVER – Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys

March 1, 2014
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys

A quick trick to list all the foreign key relationships of a table with the stored procedure sp_fkeys, with a sample script on AdventureWorks2012.

Read More
Casey, Ace and Quinn face a busy night at the Clipboard Diner while a gray shadow falls across the floor, and Casey's clipboard unrolls into a list that runs right out the door. Casey says, "One wait a night. Slow is a list we can read."

Learning SQL Wait Stats: The Complete Series Guide

February 28, 2014
Pinal Dave
SQL Performance
SQL DMV, SQL Performance, SQL Wait Stats

Learning SQL Wait Stats is the fastest way I know to find out why a SQL Server is slow. This guide lists every post in my wait stats series, told as one story about an all-night diner, and answers the questions readers ask before they start.

Read More
Log file viewer.

SQL SERVER – Dude, Where is the SQL Agent Job History? – Notes from the Field #017

February 27, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

A job failed but you cannot find the SQL Agent Job History? John Sterrett explains this common problem he sees in the field and what to do about it.

Read More
Search box for percentage.

SQL SERVER – Find Anything in Object Explorer in SSMS

February 26, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

It is easy to find anything in Object Explorer, but how do you find every object where a string exists? Here is my chat with Vinod Kumar about it.

Read More
A basketball net above a basketball with a different practice ball kept outside

Makers That Sell PCs but Not Laptops: HAVING With Conditional Counts

February 25, 2014
Pinal Dave
SQL Tips and Tricks
SQL CASE, SQL Group By, SQL Sub Query

One WHERE clause cannot say ‘has a PC but no laptop’. Here are three queries that can, and the NULL trap.

Read More
An old accordion on a chair with deeply creased, worn bellows from constant squeezing and stretching

Finding Databases With Auto Shrink or Auto Close Turned On

February 24, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, Shrinking Database, SQL Server Configuration

Find auto shrink and auto close settings, generate reviewed correction commands, inspect model, and check the effects of prior shrink work.

Read More
A small one-person tent and a large family tent side by side at a campsite

Azure SQL Database or Managed Instance

February 23, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Migration, SQL Server Agent

Azure SQL database or managed instance is a choice about compatibility, cross-database work, Agent, networking, and the cost of each service.

Read More
Previous 1 … 310 311 312 313 314 315 316 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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