Are you saying that [font="Arial Black"]all [/font]the T_R tables are Truncated before data is added? If so, then, yeah, you could go to SIMPLE recovery mode. Keyword is...

If you throw in the appropriate partition clause, it get's even simpler...

Declare @t Table(i int)

Insert Into @t

Select 1

Union All

Select 1

Union All

Select 1

Union All

Select 2

Union All

Select 2

Union All

Select 3

Union All

Select 3

Union...

Very cool... 2 seconds huh? That was going to be my next question. What kind of hardware are you running? I'm running a 6 year old P4...

Heh... what I'd like to do is to be able to show emoticons AND leave a hanging parenthesis in the same post. None of the emoticons use just a...

This will fly... even in the face of a million rows...

--===== Create the same test data as before.

-- This is NOT part of...

Um... I'm thinking that's not what you want. Look at the ACTUAL execution plan for that... tell me where, with only 11 rows in the original table, you come...

If you didn't use Gail's solution, would you mind posting your solution, please?

Can't the TEXT column be changed to a VARCHAR(MAX) column?

Create a temporary stored procedure, instead. You know... one that begins with a "#" sign. 😉

Heh... one religous battle coming up... ready?

NEVER DELETE! NEVER REUSE PK's!

Sorry... forgot to post the results I got... single P4 1.8Ghz, 1GB RAM, 80GB IDE hard drive, SQL Server 2005 Dev Edition SP2...

(1 row(s) affected)

Table '#Client_____________________________________________________________________________________________________________00000000006E'.

Scan count 1,...

Actually, I'll take door #3 😛 ... performance is the same as WHERE EXISTS and it's even easier to read especially for newbies that may be on the team...

SET STATISTICS...

Christopher Stobbs (12/1/2008)

---

HI All,

Which would you consider to be a better query:

I would go with query 2 cause it uses a join rather than like in query one it uses...

Periodic "Log Shipping" or on demand "Replication" would do it.

Heh... now THAT's funny!