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
SQL SERVER InMemory OLTP: Understanding Optimistic Multi-Version Concurrency Concepts

SQL SERVER InMemory OLTP: Understanding Optimistic Multi-Version Concurrency Concepts

February 3, 2016
Pinal Dave
SQL Performance
In-Memory OLTP, SQL Scripts, SQL Server

A reader asked what Optimistic Multi-Version Concurrency in InMemory OLTP really means. It sounds simple but is a loaded question, so here is a plain answer.

Read More
A small magnifying glass over blank index cards connected with plain cotton thread on wood.

Finding Where an Object Is Used Across a Database

February 2, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Use dependency metadata, definition searches, and runtime evidence to find object usage while accounting for dynamic SQL and external callers.

Read More
SQL SERVER 2016 - IF EXISTS Function on SQL Azure Databases and More

SQL SERVER 2016 – IF EXISTS Function on SQL Azure Databases and More

February 1, 2016
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Function, SQL Scripts, SQL Server, SQL Server 2016

Many SQL Server 2016 features reach Azure SQL Database first. Here is how I checked the IF EXISTS Function and other new features on SQL Azure databases.

Read More
SQL SERVER - Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql'

SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’

January 30, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Upgrade, System Database

After a patch, my SQL Server would not start because upgrade step ‘sqlagent100_msdb_upgrade.sql’ failed with error 537. Here is how I fixed it.

Read More
SQL SERVER - FIX: Msg 4335, Level 16, State 1 - The specified STOPAT time is too early

SQL SERVER – FIX: Msg 4335, Level 16, State 1 – The specified STOPAT time is too early

January 21, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

Preparing a point in time restore demo, I got Msg 4335: the specified STOPAT time is too early. Here is what the error means and how to get past it.

Read More
SQL SERVER - FIX: Msg 7395, Level 16, State 2 - Unable to start a nested transaction for OLE DB provider

SQL SERVER – FIX: Msg 7395, Level 16, State 2 – Unable to start a nested transaction for OLE DB provider

January 12, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

A linked server update in a distributed transaction failed with Msg 7395, unable to start a nested transaction for OLE DB provider. Here is the cause and fix.

Read More
SQL SERVER - FIX: sp_rename error Msg 15225 - No item by the name of '%s' could be found in the current database

SQL SERVER – FIX: sp_rename error Msg 15225 – No item by the name of ‘%s’ could be found in the current database

January 5, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts

Msg 15225 is a common sp_rename error: No item by the name could be found in the current database. Here is why it happens and the fix.

Read More
Previous 1 … 155 156 157 158 159 160 161 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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