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
Gouache painting of a long wooden boat hull in a yard with a vermilion-handled hammer on a plank

DBCC CHECKDB Running Slow? Check the MAXDOP Option

May 10, 2018
Pinal Dave
SQL Performance
MAXDOP, SQL Scripts, SQL Server, SQL Server DBCC

DBCC CHECKDB running slow can trace back to the MAXDOP option. A CHECKDB with no MAXDOP option uses the server’s max degree of parallelism, and one with its own option overrides it. This post times CHECKDB on a 2 GB database with four settings, adds PHYSICAL_ONLY, and lists the other causes to rule out.

Read More
An allocated chest has empty space inside while keeping its full shelf footprint.

SQL SERVER – How to Find Free Log Space in SQL Server?

May 8, 2018
Pinal Dave
SQL Tips and Tricks
SQL Activity Monitor, SQL Scripts, SQL Server, Transaction Log

Free Log Space is reusable capacity inside an allocated transaction log. I measure disk space and file size separately.

Read More
Gouache painting of a snail crossing a wooden gate with a vermilion wizard hat on the gatepost

Restore Database Wizard Slow to Open in SSMS

May 7, 2018
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server Management Studio

The Restore Database Wizard reads the backup history stored in msdb before it opens. When that history has grown for years, the wizard is slow. This post counts the history, deletes it in monthly steps with sp_delete_backuphistory, shows how to clean one database’s history, and sets up a regular cleanup so the wizard stays fast.

Read More
A distinctive token fits a literal slot among ordinary tokens

How to Search Special Characters in Table Column? – Interview Question of the Week #172

May 6, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Scripts, SQL Server

Can you find [blog.] in a column with LIKE? Most people I interview cannot. Here is how to search Special Characters in a table column the right way.

Read More
SQL Server Performance Tool Window.

SQL Server – Performance Comparison of Function Trim and LTRIM(RTRIM)

May 5, 2018
Pinal Dave
SQL Performance
SQL Function, SQL Scripts, SQL Server

A workshop question: what is the performance comparison of function TRIM and LTRIM(RTRIM) in SQL Server? Here are the test results.

Read More
Three braided bundles sit beside their separate groups of woven strips.

SQL SERVER – Split Comma Separated Value String in a Column Using STRING_SPLIT

May 4, 2018
Pinal Dave
SQL Tips and Tricks
CSV, SQL Function, SQL Scripts, SQL Server, SQL Server 2016

To Split Comma Separated Value String inputs, I use STRING_SPLIT with CROSS APPLY. The example associates each class with its student.

Read More
Sql query editor displaying variable.

SQL SERVER – Fix Error: Invalid object name STRING_SPLIT

May 3, 2018
Pinal Dave
SQL Tips and Tricks
Compatibility Level, SQL Error Messages, SQL Function, SQL Scripts, SQL Server, SQL String

A reader on SQL Server 2016 got Invalid object name STRING_SPLIT when trying the new function. Here is why the error shows up and how to fix it.

Read More
Previous 1 … 99 100 101 102 103 104 105 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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