Showing us your code may help us help you. Providing some sample data, and an expected output would also make things far easier.

My signature line contains a link on how...

Lately, there is little need for tuning. At least here.  Unless there is a query that is absolutely causing an issue, there is no time spent on performance.  Hurry up,...

Without any details, this does not sound like a great idea.  I'm curious as to what you are trying to accomplish.

xp_cmdshell requires admin rights to execute.

This article shows how non-admins...

Is there a question here?  Or are you saying that some operating systems do not support the installation of ODBC 17?

Question for the smart people, and the rest of you.

Would you endorse or get behind the statement: Some deadlocks are healthy. or Some level of deadlocks is healthy.

Or is...

Is it Friday?  I feel like it should be Friday.

I have a user 'Dev_User' in a new dev server which I am trying to drop and recreate. I generated a script using sp_help_revlogin proc from a an old...

What is the data type of "tab1.g, h, i, j, k, l?

If it is a datetime, then CONVERT(date, tab1.g) is all you might need, depending upon the regional setting of...

Of far more interest to me is the reasoning behind having 40 linked servers, and apparently each has the same database structure.

What kinds of things were you trying to accomplish...

My question is do you need to perform frequent restores, and why?

There are a few things when a failover is required.  One, drop and re-create the listener.  Two, modify the connection strings.  Three, modify the DNS records.  Four, use an alias.

Can you post a sample query?  Have you read the Stairway series of articles on this site?

https://www.sqlservercentral.com/stairways

That works.

Take a look at this link. It's way easier to read!

https://sqlserverbuilds.blogspot.com/

There was a security update released on 6/14.

I have a new SQL 2019 failover cluster which consists of two nodes and two SQL instances. The first instance is using port 1433 and the second 1439.

During failover...