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 small cream wooden panel with two toggle switches on a plaster wall, one flipped up with a vermilion tag and one flipped down

Msg 8152 Still Showing in SQL Server 2019: Check Compatibility Level

January 13, 2020
Pinal Dave
SQL Tips and Tricks
Compatibility Level, SQL Error Messages, SQL Scripts, SQL Server 2019, SQL String

Msg 8152 still appears in SQL Server 2019 when the database runs at compatibility level 140. At level 150 you get Msg 2628, which names the column. The setting VERBOSE_TRUNCATION_WARNINGS also controls it.

Read More
Sorted paper fills a worktable while excess slips rest in a side basin

What is TempDB Spill in SQL Server? – Interview Question of the Week #259

January 12, 2020
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Memory, SQL Scripts, SQL Server, SQL TempDB

When SQL Server uses TempDB when any query does not have enough memory to do its operation, it is called TempDB Spill. Let’s learn today.

Read More
Gouache painting of a row of three identical small wooden watchman huts, with the third hut having a vermilion door and a closed shutter

Could Not Log History: Log Shipping Copy and Restore Jobs Fail

January 9, 2020
Pinal Dave
SQL Tips and Tricks
Log Shipping, SQL Error Messages, SQL Scripts, SQL Server Agent, SQL Server Security

The Could not log history error stopped the Copy and Restore jobs of a client’s log shipping. The Agent account was a sysadmin on the primary and secondary, but not on the monitor server. A third Profiler trace showed it.

Read More
configurations

SQL SERVER 2019 – New Values in Sys.Configurations

January 8, 2020
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Configuration

I have written quite a few blogs about this release. In this blog, we would see the new options available in sys.configurations catalog view.

Read More
An outdoor lamp remains connected to a remote source through an extension cable

How to Map Network Drive as Fixed Drive? – Interview Question of the Week #258

January 5, 2020
Pinal Dave
SQL Interview Questions and Answers
Computer Network, SQL Command, SQL Scripts, SQL Server, SQL Stored Procedure

Question: How to Map Network Drive as Fixed Drive in SQL Server?
love little problems like this one as they are indeed a lot of fun to resolve. 

Read More
Gouache painting of a vermilion triangle block resting in a wooden ring beside sage cubes and cream rings on a playroom rug

ISNUMERIC Function Returns 1 for 12e5: What to Use Instead

January 2, 2020
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL String

The ISNUMERIC function returns 1 for strings that are not plain numbers, such as 12e5, a lone dollar sign and a lone plus. This post shows what it accepts, why, and which tests to use instead. It covers TRY_CAST and its blank string quirk, TRY_PARSE, and the digit pattern checks readers suggest.

Read More
Gouache painting of four garden tools hanging on a rail, the second one a vermilion trowel and the others grey and sage

Parameter Sniffing Fixes Compared: Which One to Use

January 1, 2020
Pinal Dave
SQL Performance
Parameter Sniffing, Query Hint, Recompile, SQL Scripts, SQL Stored Procedure

Parameter sniffing fixes compared on one table show a clear order, from a cheap guess to a better index. This post runs the plain procedure, a local variable, OPTIMIZE FOR UNKNOWN, a scoped setting, OPTION (RECOMPILE) and a covering index on the same skewed table, and prints the page reads of each in both call orders.

Read More
Previous 1 … 51 52 53 54 55 56 57 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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