jared-709193 (10/5/2011)

---

Yes, but like you said. There is a reason to keep it enabled. I have not found a good reason to disable it.

EDIT: Also, I respectfully disagree. I...

That's a hard question to answer directly without knowing more about the nature of your application... the size of the database(s) and what sort of traffic load you'll be dealing...

Actually this web site is one of the awesome things about my job every day. I can share in discussions, answer questions and get questions answered and even be entertained...

I got two out of three, which is okay with me.

Of all of my skills and talents, the ability to recite every obscure factoid about relational databases (or any...

you can't use a comma separated set of values in a case of "where ID = @ID".

If @ID is not an integer then you'll need to use this: 'where (ID...

Have not seen this but obviously your install script encountered errors and did not complete. You need to try and find out why, although this may be one time deal.

GSquared (9/30/2011)

---

Which brings up, what happens if some credible expert votes for something, and five minutes later is told a better solution by someone who's completely new to the site,...

One way is to build a dynamic SQL query with it. Simple example:

set @values = '1,2,3,4,5'

set @query = 'select * from table where ID in ('+@values+')'

Just make sure whatever you...

Speaking of junk drawers.... how many unused tables and stored procedures exist in some of our production databases that have been out there for years?

I have one in particular that...

It looks to me like you could use an existence query instead of count() since you aren't really interested in the actual count, just that it is > 0.

"if exists()...

You should be using coalesce. I'm not sure if I understand exactly what you want but try something like this:

datediff(dd, DATE_2, coalesce(DATE_4,DATE_1,DATE_3))

How about something like this:

with cte (id, val) as (

select id, convert(money,totdays) as val from #TEST

)

select id, val from cte where val > 20.00

I'll second that. Until the current anti-business...

It is not uncommon for companies to hire on a temporary basis until they determine if you are competent. I don't blame them, why should they be penalized for firing...

GilaMonster (9/27/2011)

---

Neither does mine (well, actually mine just doesn't have a training budget as it's a consulting company). I'm paying for a 10 000 mile (each way) trip, close on...