I don't know which indexes get scanned. I suggest you read Gail Shaw's article on how to post performance problems:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Anyway I guess you get the scans from the OR...

I know that some of the "Threadites" already chimed in, so I'm saying this for all the others: you really have to read Lynn's latest article[/url] and the discussion.

Awesome...

Excellent article, Lynn!

I'll make sure to include your oustanding UDF in my dev/production environment. I already have one that does the same thing, in a while loop :blush:.

Thanks for...

Peter E. Kierstead (9/18/2009)

---

Wow... you guys are extremely caustic... its a wonder any bother to post here anymore. I made a simple comment regarding how we use a facility. Take...

If you just want to query the stored procedure results, leave the function alone, way too complicated.

You could set up a loopback linked server (ilnked server pointing to the server...

This should work for you, working with joins as you requested.

Consider using Florian's solution too, depending on the execution plan.

SELECT t1.*

FROM #test t1

LEFT JOIN #test t2

...

I understand what you're trying to do, but there's no way to achieve it that way.

You will have to build a sql query in a variable and execute it with...

Sorry for double posting, looks like the site has some issues.

It says an error has occurred, but the post is added.

SELECT *

FROM

WHERE valuedate '20070731'

and valuedate '20070724'

SELECT *

FROM

WHERE valuedate '20070731'

and valuedate '20070724'

Tore Bostrup-382308 (9/16/2009)

---

Interesting article. I took a slightly different approach when needing to delete almost 99.5% of rows from two tables with a total of 200 million rows between...

Tore Bostrup-382308 (9/16/2009)

---

Interesting article. I took a slightly different approach when needing to delete almost 99.5% of rows from two tables with a total of 200 million rows between...

rja.carnegie (9/17/2009)

---

On the other hand, if junk objects aren't 90% of database size, how about leaving them alone because they aren't doing much harm. You aren't paid to be...

That's what I do. After 6 months in the 'drop candidates' schema, the object is dropped.

Nope: it's modeled on my dev env, that means two databases, app code, reports.

It works for me, it won't work for you...

The thing I want to stress here is that...