Toreador (6/26/2012)

---

ScottPletcher (6/25/2012)

---

Baloney.

"Defined" is inherently an action, not a state.

You cannot "define an index" on a table variable in SQL...

Having a different number of columns in the query vs. the answers is wrong. In no case would the query supplied have a 2nd column return NULL. I...

Having one of "those" days today, which really started last Wednesday, so I guess we're almost up to one of "those" weeks.

I chose the wrong answer (true, false) for all the reasons listed by others. I chose it knowing that there was a good possibility I'd be wrong because of...

L' Eomot Inversé (6/20/2012)

---

The thread seems very quiet. I've been away three days and there are only 62 new posts on it.

But I may not find...

Personally I'd probably use script component and handle it in .NET. .NET handles XML pretty well.

Hugo Kornelis (6/14/2012)

---

There are also a few people who didn't consider the possibility of unique constraints being defined in the same CREATE TABLE statement, for instance because they have the...

ASITKAUSHIK (6/14/2012)

---

You seems to be using a lot of functions on the fields in the select. Most of it is converting DateTime field to 112 format. IS that be avoided....

Okay, I got it wrong. I personally create constraints (other than PK and DEFAULT) separately from the CREATE TABLE statement, so when it says " execute a batch that...

For some reason I always seem to be the "dissenting voice". I'd like to think it's not because I'm a know-it-all, but because all to often decisions are...

Brandie Tarvin (6/4/2012)

---

Gianluca Sartori (6/4/2012)

---

70% of Italians own the house they live in.

Well, sort of.

Who owns the house while you're...

Wish I had the income to afford a $1.5 million house.

Wish I lived in Memphis where you can get a house for $100K.

The house we just bought was a short-sale...

I'm not sure where I fall. I'm not doing exactly what I want, but my job isn't bad. It's hard to beat a full-time telecommute position that pays...

SQL Server is going to grab all the memory it can regardless of how much you put in there. If you add memory I wouldn't adjust the max memory...

I'd definitely suggest adding a dedicated SSRS box. Until then I'd reduce the max memory for the SQL Server database engine to free up memory for SSRS and the...