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
Diagram of the three steps to check a table for Stretch Database: open the Stretch Database Advisor, select the database to analyze, and read the analysis report, which says the sales table needs its Default Value constraints removed

Stretch Database in SQL Server 2016: Notes from the Field #127

June 9, 2016
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Azure, SQL Scripts, SQL Server, SQL Server 2016

Kenneth Urena shows how to use Stretch Database, the SQL Server 2016 feature that moves cold table data to Azure while hot data stays on premises. Microsoft has since discontinued it.

Read More
An open storage chest has empty internal compartments within a separate surrounding storeroom.

SQL SERVER – How Much Free Space I Have in My Database?

June 7, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server

Free Space inside data files differs from unused space on the Windows volume. I check both when planning growth.

Read More
The same ceramic buttons are arranged by color in one tray and by size in another

Sort Query Using Dynamic Variables Without EXEC – Interview Question of the Week #074

June 5, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Order By, SQL Scripts, SQL Server

How do you sort query results by a column passed in a variable? Here is how to sort query output dynamically without EXEC or sp_executesql.

Read More
SplitMyString SQL Server result set.

SQL SERVER – Puzzle – Solve Splitting Strings Puzzle

June 2, 2016
Pinal Dave
SQL Puzzle
SQL Function, SQL Scripts, SQL Server, SQL String

A Splitting Strings puzzle: take a column holding delimited values, split them and return how many values each row has. How would you solve it?

Read More
Every place in an egg carton contains an egg

What is NOT NULL Constraint? – Interview Question of the Week #073

May 29, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Constraint and Keys, SQL NULL, SQL Scripts, SQL Server

A client table full of NULL values was hurting query plans. Here is what a NOT NULL constraint is, how to add one and why it helped performance.

Read More
SQL Server - InMemory OLTP Hash Collisions Performance Overhead

SQL Server – InMemory OLTP Hash Collisions Performance Overhead

May 27, 2016
Pinal Dave
SQL Performance
In-Memory OLTP, SQL Scripts, SQL Server

A customer’s InMemory OLTP tables ran slowly because of a very low hash bucket count. Here is the hash collisions performance overhead and how to avoid it.

Read More
SQL SERVER - FIX: Error 1807 Could not obtain exclusive lock on database 'model'. Retry the operation later – Part 2

SQL SERVER – FIX: Error 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later – Part 2

May 25, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

Msg 1807, could not obtain exclusive lock on database ‘model’, still shows up in SQL Server 2016. Here is another cause of Error 1807 and how to fix it.

Read More
Previous 1 … 147 148 149 150 151 152 153 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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