Are you sure they're exactly the same version of SQL Server? Because it sounds like you're getting a version error. Could the one server be SQL Server 2008R2 and the...

Hate to backtrack if it's been asked, but have you looked at the wait statistics on this? I'd be curious as to what it is waiting on. Maybe it is...

Maddave (4/7/2015)

---

Thanks for the help Grant.

Do you mean as follows: (Obviously changing the values dynamically for each pass in the real code).

DELETE DocumentResultDataItem

WHERE DocumentResultDataItem.ResultItemRecordId BETWEEN 225392327

...

If you have an MSDN license, you can work with Azure for free, up to a certain limit each month. The pricing is here[/url]. Just keep the size of your...

GilaMonster (4/7/2015)

---

No. LSNs are never reused, they're unique within the database.

If an LSN ever reset to a lower value it would result in the database being suspect and needing...

Since you have the start and end values, instead of just say TOP 10000, how about just saying, delete 10000 rows of information. Pass the start value, then 100000 past...

Sorry, wasn't trying to be unhelpful. There just really isn't anything for putting...

To build a web front end for your database can be a lot of work. There are multiple third party products out there that should help. Assuming you have an...

Sagar-636902 (4/6/2015)

---

Thanks for the quick suggestion. i will check that when it run next time. but is there any idea why re-org should block the( it had schema lock), i...

Yep, LSNs are reused. It won't make for a great unique identifier.

Are you using the DMVs to look at the blocked and blocking processes? If not, sys.dm_exec_requests will show you which processes are blocked and which are blocking. You can then...

I'll go one further. I'd suggesting taking a look at Jeff Moden's article on Tally Tables[/url] and using that to take the comma delimited list and turn it directly into...

efyuzegeekgurl (4/5/2015)

---

Hi Grant

Thanks for replying.

Actually on our production server, we have a standard maintenance plan setup that runs the "Check Database Integrity Task" nightly before taking a full backup....

Yes. Although, generally, you don't see deadlocks from a procedure that only has reads.

Maybe I'm confused, but it just sounds like an INSERT... SELECT operation. Insert into the new table using the values of the old one. Or am I missing something? The...