One thing about the CHOOSE function is that it seems to provide a tempting way to avoid having a normalised database with its lookup tables. I would be picky about...

Jeff. I'll take a crack at your question:

In your example, are you assuming the date column is indexed and would be used?  What if that is not the...

Jeff. I'll take a crack at your question:

In your example, are you assuming the date column is indexed and would be used?  What if that is not the...

Jeff. I'll take a crack at your question:

In your example, are you assuming the date column is indexed and would be used?  What if that is not the case, the...

I have to add that if blocking and query speed is an issue there are deeper problems going on with the system in use. The use of nolock as a...

• This reply was modified 1 years, 7 months ago by MMartin1.

Thank you for the article and taking the time to put it together.  I do have a couple of notes :

1. "Use a Staging Environment: Replicate your production environment to...

Thank you for the nice introduction. Has there been any investigation into the response times to queries , DML, and DDL operations when TDE is operating on a database versus...

"Avoid using Encrypting File System (EFS) and file-system compression because they cause asynchronous I/O to become synchronous and therefore slower. For more information, see the Asynchronous disk I/O appears as...

DBCC SHRINKFILE ?

You want to do this on the primary. I know growing them will propagate the same to the secondary nodes, but have not done a shrink before. You...

For readability I suggest indents , but more importantly this looks like it could use EXISTS clauses and not sure why the same values criteria appear more than once.

This is a very relevant article and far too often code is written in such a way that Log space is consumed as a result of attempting to delete...

We had the same  problem today.

I wrote a script that does the following:

• Starts a transaction
• retrieves the last id number of the table
• uses sp_rename to rename the...

I used to look at job requirements as rigid in that the company knew exactly what they wanted. Over time I saw it for being more of a ask/bid model....

"Enter the subscription, resource group, cluster and administrator account details."

---- these items are not predefined and just thrown into the context. This read assumes prior knowledge of cloud service architecture....

Hmm. I am not so sure. I had an issue where the query plan kept regressing due to an issue with memory grant on a table with a large varchar...