Most people do this when they build dyanmic sql from a search form with many possible search options.

You start with 1 = 1 (100% of the rows)... then you start...

sqlnaive (5/10/2011)

---

Though it's for big recordset but columns are few (6-8). So i think somehow it should be more efficient. But how, donno. Please let me know if anything can...

Ninja's_RGR'us (5/10/2011)

---

You think 40 seconds to run this is slow??? Granted it's not blazing but certainly not slow.

That one is out of my expertise zone. Letting the other...

You think 40 seconds to run this is slow??? Granted it's not blazing but certainly not slow.

That one is out of my expertise zone. Letting the other ones...

The estimates seem completely out of whack.

#1 - Do you have the same indexes in both environements?

#2 - Run update stats

GilaMonster (5/10/2011)

---

😀 I didn't check where the link went before...

Upgrading is never an easy project... no matter how small.

You can look into unpivot in books online.

1 solution I recently tried is to insert that row into a table variable. Then do 1 union all per column. ...

GilaMonster (5/10/2011)

---

Patience. This is a discussion forum, not a chat room. We're all volunteers with our own jobs and own problems. bumping your post...

Cool script but I think that's only 1% of the problem. Those new identities need to be linked to the child tables. That part will have to be...

colin.Leversuch-Roberts (5/10/2011)

---

I always use profiler as the overall exection time of a complex proc is meaningless without the breakdown for each statement.

It's actually a much better route to follow -...

http://tinyurl.com/3zjrm3u

Here's what I did. Create the job, create the schedule to run every 12 minutes.

Script it out instead of doing OK.

Then in the script find the code that looks...

I can't open those.

Can you save the plans as .sqlplan and upload those files?

TIA.

This is for datafiles, but it would be an easy tweak for logs.

IF OBJECT_ID('tempdb..#dbs') > 0

DROP TABLE #dbs

IF OBJECT_ID('tempdb..#Drives') > 0

...