If you need this is a repeatable and automated fashion , as i guess as you say Not manually, then SSIS is probably a safe bet.

Now THAT sounds like a plan 🙂

Jack Corbett (2/9/2011)

---

Congratulations. I basically handed in my notice a couple of weeks ago, but I'm giving like 16-20 weeks notice, not required by law though, just letting them...

There are the same , count(1) get converted to count(*) by the optimizer / parser.

See this post on my blog

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2010/07/27/count-or-count-1.aspx

TheSQLGuru (2/9/2011)

My gut tells me that the server effort to clear gobs (tens/hundreds of thousands or even millions) of ad hoc plans from cache using either method you mention (i.e....

Thanks Chris (and all others) for well wishes, Its an uncertain market in uncertain financial times, hopefully ive done enough leg work over the past few years to...

Bummer ,

You may be able to ease your system usage by creating a plan guide and forced paramaterization.

http://msdn.microsoft.com/en-us/library/ms191275.aspx

Also post the full plan as per

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

It may help to see what the...

Brandie Tarvin (2/9/2011)

---

Actually, that's just the wind blowing up your kilt. @=)

Seriously, though, are you just...

Handed my notice in today , i can already feel the freedom 🙂

TheSQLGuru (2/9/2011)

---

Dynamic sql is almost always the most performant way to deal with this type of scenario. Beware SQL Injection as someone else stated and also watch out for...

errrm

CASE suc.status WHEN 'Completed' THEN 0 ELSE 1 END

Please finish reading that article, specifically the sentence following the conversion it states "This can be disastrous for performance!".

All you could ever wish to know about dates in sql server is documented here...

http://www.karaszi.com/SQLServer/info_datetime.asp

Or in profiler

File -> Save as -> Trace Table

Grant Fritchey (2/8/2011)

---

I'll bet if you forced a recompile in production the plan would change. Sounds like the statistics have aged and the plan created in test was different. Or,...