The best way to think of FLOAT is it will give you approximately the right answer. It is great when that is the result you need, but not so good...

The first thing you should do is use the query plan to see if new indexes might help. This often helps. My best win on this was when I...

• This reply was modified 3 years ago by EdVassie.

I agree with Ken that NOT EXISTS should run faster than NOT IN.

Imagine you have a room full of people wearing various colour shirts, and you want to see...

• This reply was modified 3 years ago by EdVassie.

It is too long since I last did replication to remember what is needed to answer your question.

However, I can say your problems will not end when you get this...

I have not come across this issue, but my policy was to never uninstall software if I wanted the server to keep running.

The uninstall process often gets less testing than...

• This reply was modified 3 years ago by EdVassie.

Hopefully the department will have built their apps to hold the forms in one Access db and the data in a second Access db.

If not then the first step is...

FOR XML PATH is the only way I know for your version of SQL. The syntax is a bit arcane but you can live on it. It will continue to...

I have never used WinRm so can only give some general troubleshooting advice.

The first step is to isolate the failure, and thr first step in that is to verify you...

Thanks Jeffrey, that was helpful

You are in Synchronous mode with SQL 2012 so how have you done the patching so far. I hope this is not a new install as SQL 2012 is 10...

STATA is a different product to SQL Server. From what I can see on the product site, it has its own database manager and stores its data in a proprietary...

I think that when you log on with your SQL account you have a security context of that account. When you then do the linked server bit there is a...

Developer Edition give all the facilities of Enterprise Edition.

Also, Developer Edition is not restricted to individual use. The restriction is on type of use. A whole team can use a...

My only advice is to build a test cluster to a similar spec and try out the various failure scenarios. Repeat the tests a few times to see if the...

Back in the old days before Microsoft fixed all security issues in Windows (: there was a thing called Unconstrained Delegation.  This was the default setting and resulted in an...