Good catch, Gianluca !

That is indeed a risk to assess, and that didn't even cross my mind. :crazy:

As it appears, my test data hasn't been adequate...

You could setup a test and rebuild a partitioned tables partitioned index and see how locking behaves by e.g. sampling sp_lock or trace locking

edited ... removed the quoted text :blush:

Can you use Row_Number() over ( partition by yourdatecol order by yourdatecol ) as RwNumber

and add that ( - 1)

e.g.

update x

set ...

How about :

;

With cteDocCounter

as (

...

Check out Jeff Moden's wonderful "DelimitedSplit8K" http://www.sqlservercentral.com/Forums/Topic943562-338-1.aspx#bm944589

It will get you started on resolving your quest 😎

I would create a synonym in the database, referring to the table in the other database.

Check "CREATE SYNONYM" in books online

ps I prefer still leaving a trace in the naming...

SQLRNNR (9/15/2011)

---

Tom.Thomson (9/15/2011)

---

Steve Jones - SSC Editor (9/15/2011)

---

Please let's not have quotes of every post that counts down from 95, 94, 93.

I'm going out of town for a few days....

Make up your mind. No guessing 😉

Jeff Moden (9/14/2011)

---

ALZDBA (9/14/2011)

---

jcrawf02 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

mtillman-921105 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article....

jcrawf02 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

mtillman-921105 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is...

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is all about the scary,...

Perry Whittle (9/14/2011)

---

Unless you're using...

This is a great recognition and thank you for all time, energy en knowledge Jeff developed and shares !

Congratulations, Jeff

We get to hear "Ho, ho, hoo" at SQLPASS 2011 !!!!

http://www.sqlservercentral.com/articles/Exceptional+DBA+Awards/75988/

Congratulations Jeff !!

Jan Van der Eecken (9/13/2011)

---

ALZDBA (9/13/2011)

---

I...