In an environment where you are doing lots of inserts and with a uniqueIdentifier type, first consider that you are not using the 100% fill factor. From there you can...

In an environment where you are doing lots of inserts and with a uniqueIdentifier type, first consider that you are not using the 100% fill factor. From there you can...

"The SQL service frequently locks up without any apparent reason, causing all databases to drop."

What to you mean by locks up? and do you mean the databases drop from the...

I do wonder

WHEN order_phone = ' ' , what happens if the value is '   ' (3 spaces) ? The LEN function will still give you zero so that is...

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 3 months, 2 weeks 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...