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
Fixing High CPU Consumption on SQL Server 2017.

SQL SERVER – How to Fix High CPU Consumption on SQL Server 2017 and 2016

March 23, 2018
Pinal Dave
SQL Performance
Cumulative Update, SQL CPU, SQL Server, SQL Service Pack, SQL Upgrade, TraceFlags

After a big upgrade, a client’s SQL Server showed high CPU Consumption, and they called me in twice. Here is what we found and the simple fix.

Read More
MSDDBData.

SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed

February 13, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Server, SQL Server Agent, SQL Upgrade, Starting SQL, System Database

One more cause of the script level upgrade failure for ‘sqlagent100_msdb_upgrade.sql’: Error 5041, MODIFY FILE failed. Here is how I fixed it.

Read More
SQL SERVER - Why Edition Upgrade is Not Upgrading Edition of SQL Server?

SQL SERVER – Why Edition Upgrade is Not Upgrading Edition of SQL Server?

July 17, 2017
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Installation, SQL Upgrade

A DBA friend ran Edition Upgrade from Standard to Enterprise, setup finished with no errors, yet SQL Server still showed Standard Edition. Here is why.

Read More
Sql server compatibility level.

SQL SERVER – How to Change Database Compatibility Level?

May 22, 2017
Pinal Dave
SQL Tips and Tricks
SQL Performance, SQL Scripts, SQL Server, SQL Server Configuration, SQL Upgrade

After watching my free webinar the most popular question, which I receive is about Database Compatibility Level.

Read More
SQL Server Setup failure dialog.

SQL SERVER – Edition Upgrade – Invoke or BeginInvoke Cannot be Called on a Control Until the Window Handle has Been Created

May 10, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Upgrade

An old client met me at the airport with an edition upgrade error: Invoke or BeginInvoke cannot be called on a control. Here is the workaround.

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
A bookbinder's bench with an old book's pages beside a new red cloth cover.

Converting Deprecated TEXT, NTEXT and IMAGE Columns Safely

August 10, 2013
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Deprecated Feature, SQL Server, SQL Upgrade

Inventory deprecated TEXT, NTEXT and IMAGE columns, convert to MAX types, move small values in row, and measure logging and space costs.

Read More
Previous 1 2 3 4 5 Next
  • Books
  • Testimonials
  • Privacy Policy

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