Seek and Scan is not under your control unless you specifically instruct SQL Server Optimizer to do it using Hints. In the above case it has nothing to do with...

I found this from...

I take this opportunity to talk about the probable root cause of schema difference between Dev and Prod. Unless we work on root cause, there would many such recurring opportunities...

You have used COALESCE function but haven't supplied multiple arguments. I can see only one argument to your COALESCE function and that may be causing the error.

Either remove COALESCE function...

When you say Page File usage is up to 200% of the memory, what you are talking about is the size of the page-file not the page file actually...

Hi Jonathan - Have tried Task Manager and it has now totally confused me 🙁

Out of around 26 GB configured for SQL Server, only 475 MB is getting used. Please...

I'm hoping to have some useful suggestion on this topic.

You gave great insights on the Index Maintenance, Rebuild and Reorganize. Thanks for your time spent on the experiments and as a result of which we have such a wonderful...

Max Memory capping is applied on the instance.

Total Available Memory : 32 GB

Max Memory configured : 26 GB

As far as I know, nothing additional running on the instance, except the...

Any suggestions would be much appreciated !

I just finished running a stored proc that loads 5.5 million rows into a table variable as part of a cursor loop, then writes all of those rows...

Your original query refers to Survey_Answers table and fetches only 3 columns and has a WHERE clause too. This has been done as part of subquery. Since you have not...

Grant has suggested 2 features.

1)  Availability Group : is available both in SQL Server as well as Azure (Azure SQL is also SQL Server. You will be able to leverage...

Your query is perfectly doing it's job as it's written.

If your intention is to identify & update the duplicate records basis certain set of columns then try to make use...

Your requirement is just to maintain the copies of the DB or you are also thinking to implement HA/DR solution out of it? Also, mention the version and edition of...