When SQL Server takes an exclusive lock, which it must have in order to maintain data integrity when modifying data, there is no way for any other process to get...

SQLRNNR (3/7/2014)

---

Yes you could benefit...

When you add a row to a table that has an index, the index has to be updated to reflect the new value added. When you modify a value that...

CXPACKET waits in and of themselves are no big deal. They're just indications of parallelism occurring within your system. Now, you may be seeing parallelism for some queries that are...

You might want to take a look at this article I wrote in SimpleTalk. It goes through how to retrieve versioned data[/url] from the table. Assuming you can identify the...

Right there with Gail. This is something I'd test the heck out of this before I got anywhere near production. It's far too big a change to do it any...

Sqlsavy (3/7/2014)

---

Thanks. Does updating stats on heap table is of any use?

How to reduce fragmentation <30?

IndexTypeavg_fragmentation_in_percent

CLUSTERED INDEX 97.67442

CLUSTERED INDEX...

True, but we know they have...

It's hard to know for sure, but on a guess, statistics. I'll bet they're not being well maintained on either machine. Minimum, start with sp_updatestats. After that, you may find...

For a quick hit, I agree with Lowell, pull information out of the cache. You can see what's going on there. For longer term though, you need to look into...

But... If they...

It looks like you've missed something on the security screens. Make sure, minimum, you add the current user. That's actually not always the best way to go about it, but...

I really don't care what naming standards we have. Let's just make them clear and let's enforce them. After that, it's all good.

I have a presentation where I spend about...

SQL Guy 1 (3/6/2014)

---

Try to backup with compression. In this case, the combined backup size will be around 150-200 GB, so there is a chance you'll be able to...

If it's an update statement, you could be seeing contention from other resources doing reads at the same time as you're trying to modify the data. That's a pretty classic...