What data type is the column?

Does "1.0000" qualify as having a decimal point in it? Or does it need to have a non-zero value after the decimal to be...

mister.magoo (11/19/2011)

---

One word - ROWVERSION - I don't think you can break this...

BEGIN TRAN

-- Let's have a test table with an identity (to be forced out of order)

-- and a...

p-nut (11/21/2011)

---

GSquared (11/21/2011)

---

In that case, I'd start looking into using snapshots for the reports to operate off of. You're almost certainly on Enterprise Edition, which means that's a real...

You mean you don't just automatically do all of those things every day?

I have a job that runs them automatically every day, right in the middle of peak business hours,...

Koen Verbeeck (11/20/2011)

---

Sean Lange (11/18/2011)

---

I don't think you can increase...

Here's a sample:

DECLARE @XML XML = '<values><Names First="GSquared" /></values>' ;

SET @XML.modify('delete /values/Names/@First') ;

SET @XML.modify('insert attribute xsi:nil {"true"} into (/values/Names)[1]') ;

SELECT @XML ;

In that case, I'd start looking into using snapshots for the reports to operate off of. You're almost certainly on Enterprise Edition, which means that's a real option for...

Second the motion.

Instead of using the Microsoft wizard plans, I have a "DBA" database with configurable procedures in it, that manages all of that for me.

Much more granular control of the thing,...

http://www.salary.com already has this data, plus a LOT more info. I haven't had trouble getting just SQL Server DBA data from it for the regions I've looked up.

Please always...

Do a join from TableA to the master table, then from that to TableB. Select Distinct on just the columns from TableA and TableB in that. That will...

p-nut (11/17/2011)

---

GSquared (11/17/2011)

---

p-nut (11/17/2011)

---

Ok, as it turns out she believes the reason is 2-fold. Her words: The first is that the nature of our data does not leave open...

It's pretty usual for queries of many sorts to run slower after a reboot, because of caching issues for both data and execution plans.

This sounds, however, like a good case...

If you pull all of them into a table variable, it will be faster than a temp table, because it avoid the distributed transaction coordinator. That will often give...

They are the same.

Better is a matter of opinion on this one. It doesn't really matter which you use, but be consistent with whichever you choose.