Thanks Michael.

With SQL AlwaysOn AG Clustering, some have mentioned to use 64K unit allocation sizes for the SQL Data and SQL Logs, is this still necessary, or will it...

It doesn't matter then. The Equalogics are basically one big drive.

Where is tempdb going to be located?  That is probably most critical in a VM environment.

Also, there are multiple types of SCSI adaptors in VM Ware. The default is an...

Thanks guys.

Unfortunately, testing before and after changes would prove troublesome.  I don't have the Dynamics CRM skill, or a clone of the environment to do the testing myself -...

Hi there,

if you want to detach a database you would right click on the DB->Tasks->Detach

What are the motivations behind doing this? I suspect if you want to make edits...

The employment and unemployment situation is fouled up.  Go figure.

My daughter in law is actually taking home more money now than when she works because of the 600.00 in extra...

It's great to see this article!  I'm going to sit this pie fight out though.  Two items I would toss in fwiw:

<li style="list-style-type: none;">

1. The return type of...

Curiously, why would you NEVER use an identity?

Good job!

There is one things that could probably be added to this.  An identity is incremented when an attempt to insert is performed.  Even if the insert fails, the identity is...

If this code was run many times a day, it may be worth spending more time on it. It is executed once a month.

But, it's not the code that can...

I feel like I'm missing something. An inner join is necessarily an existence check, why not:

SELECT u.UserId
  FROM UserTable u
  JOIN TableA a ON...

I think the most obvious way to rewrite that query would be:

SELECT u.UserId
  FROM UserTable u 
 WHERE EXISTS(SELECT * 
    ...

All of them.  The system is only 9 months old.

Lynn, there are a lot of index...

Here's the query.  There's not any understanding on how the the language works, index usage (or lack of usage), and what these things do.

It works in...

Obviously, it's time for you to move this all to the cloud where you can easily add a bazillion CPU's to scale out for this horribly complex problem.  After...