15 votes
Accepted

SQL Server: Max memory same as Min memory?

this is stupid advice That book might better serve you by keeping a coffee table level or something. When you set min server memory equal to max server memory, SQL Server can no longer use memory ...
Erik Darling's user avatar
  • 40.5k
8 votes

A query I ran yesterday isn't in the plan cache, but older and newer ones are. Why?

From Plan Cache Internals: Determining which plans to evict is based on the cost of the plan, which will be discussed in the next section. When eviction starts is based on memory pressure. When SQL ...
Erik Darling's user avatar
  • 40.5k
7 votes

What is the collation used while comparing Unicode string literals in SQL Server 2019?

My understanding is that the collation for comparing Unicode string literals is determined by the database collation. Yes, this is correct. In fact, the local database's default collation is used for ...
Solomon Rutzky's user avatar
7 votes
Accepted

When should I inspect the Error Log?

I've had a varied career, but I have never found relevant information in the SQL Server Error Log. I'm happy you've had an easy time with SQL Server :) Under what circumstances should I consider ...
Sean Gallardy's user avatar
5 votes

When should I inspect the Error Log?

Well darn. It looks like I should be checking that thing more often. Usually, it's just flooded with info telling me that my log backups are working great. If you’d like a free tool that narrows the ...
Erik Darling's user avatar
  • 40.5k
3 votes

When patching SQL FCI, how to ensure there will not be a failover to the node being patched; and how to do a manual failover after patching?

The correct and documented procedure is to use the /FAILOVERCLUSTERROLLOWNERSHIP parameter when calling the upgrade source.
Sean Gallardy's user avatar
3 votes

Do deprecated features matter when changing compatibility level?

Not exactly, deprecated features are planned to stop working but discontinued features actually do not work in the later version. Data migration assistant will be very helpful & also the comment ...
Stephen Morris - Mo64's user avatar
3 votes
Accepted

My backup failed DBCC CHECKDB. Now what?

One day, DBCC CHECKDB reports that things are very wrong. What corrective steps should be taken in a (thankfully hypothetical) situation such as this? Depends on what it reports as the failure and ...
J.D.'s user avatar
  • 37.1k
3 votes
Accepted

Can I regularly log ship from a source to a target, while running DML on the target?

Except for the changes caused by a stored procedure that I need to regularly run in Target, I want Source and Target to be identical and sync'd up roughly once a day. Is log shipping a suitable ...
J.D.'s user avatar
  • 37.1k
3 votes

When should I inspect the Error Log?

Here's three more cases, in addition to Sean's list: When the instance won't start properly (as vonPryz noted). In similar vein, when a database won't come back online. When a user is encountering ...
J.D.'s user avatar
  • 37.1k
2 votes

When should I inspect the Error Log?

A few small additions to the good answers from Sean Gallardy and J.D.: I've used the SQL Error Log when troubleshooting problems with encrypted connections. In the first ten or twenty seconds after ...
Doug Deden's user avatar
  • 1,698
2 votes

Do deprecated features matter when changing compatibility level?

Beware of the inligning UDF.... Sometime because of the Intelligent Query Processing, that transform UDF into SQL code integrated to the query, the behaviour changes and an error could be diplayed (...
SQLpro's user avatar
  • 485
2 votes
Accepted

76% of the RAM usage on my server is TEXT_MIX_PAGE in tempdb. What does this indicate?

The idea of the command is that it shows what percentage of your server's RAM is being used by what type of pages in each of your databases. It'll show you what type of pages are in the buffer pool ...
Sean Gallardy's user avatar
1 vote

When do physical reads indicate a lack of RAM?

For monitoring waits, there are certain benign waits you can usually ignore. A quick lookup on SQLSkills suggests that SOS_WORK_DISPATCHER can probably be ignored so I would look at the next wait ...
David Wiseman's user avatar
1 vote
Accepted

Is Monitoring Buffer Pages Too Noisy To Be Useful?

Get-DbaDbMemoryUsage uses the sys.dm_os_buffer_descriptors DMV. I think this is an interesting DMV but I've never used it to diagnose any performance issues. I have seen it be a significant ...
David Wiseman's user avatar
1 vote

How can I restore everything except stored procedures, functions, users from SQL Server 2019 native backup into another DB Server.?

How can I restore everything except stored procedures and functions from SQL Server 2019 native backup into another DB Server? Is it possible in SQL Server 2019? No, not directly. Backups need to be ...
J.D.'s user avatar
  • 37.1k
1 vote

Full Database Backup failing

General Ola Error Debugging The error message in your question looks like the job step error message. The full details are normally stored in a TXT file with the name similar to this: DatabaseBackup_&...
John K. N.'s user avatar
  • 17.6k
1 vote
Accepted

How does SSMS grab the name of my server?

You accepted Alocyte's answer, but you want more evidence. Let's give it a try. I have a SQL Server. The server's name is 100002-DB28. The instance name is Fam7_Test. We'll start with ... The control ...
Doug Deden's user avatar
  • 1,698
1 vote

How does SSMS grab the name of my server?

Derived from you connection string. Try target public IP, or URL, or internal IP, or netbios name... will mirror whatever you use.
Alocyte's user avatar
  • 422
1 vote

ReFS Vs NTFS for SQL Server 2019, server 2019

When you first create the Disk and are at the format stage you can increase the metadata size for the File Record for the drive by using the following format command on NTFS systems. format <...
BPODFWPonder's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible