Mr Quillz (7/20/2011)

---

Hi Guys,

I agree with most comments on this question, asking us how many rows would bereturned should not have been the way to put it. As we know...

Carlo Romagnano (7/20/2011)

---

I would replace the question "How many rows returned by executing all of the following?" in "How many rows returned by the last SELECT?" and add another answer:...

My choice of words was really...

bitbucket-25253 (7/19/2011)

---

[Rant]

After getting the supposed incorrect answer, I cut and pasted the code into SQL 2005 and then again into 2008. Ran each not less than 15 times and...

Jeff Moden (7/19/2011)

---

Ninja's_RGR'us (7/19/2011)

---

Wow Jeff must make a nice santa in...

Craig Farrell (7/19/2011)

---

Ninja's_RGR'us (7/19/2011)

---

Craig Farrell (7/19/2011)

---

So, the questions: Yes, you can apply MAXDOP to any DML statement.

I disagree with the above. Don't adjust maxdop serverwide, adjust the cost to...

Maybe not, but certainly is 98% of the time so I won't go down that...

Craig Farrell (7/19/2011)

---

So, the questions: Yes, you can apply MAXDOP to any DML statement.

I disagree with the above. Don't adjust maxdop serverwide, adjust the cost to initiate it (5...

Never EVER put maxdop 1 @ server level unless you're dam sure that's the best option for ALL normal queries. Since we're working on 1 query here I...

Same here...

I would definitely split the 2. Going to SP4 is not a small task especially if you are supporting a lot of applications and that they are not easily...

As a side note. I would never recommend using maintenance plans. They've been more than buggy over the years (yes it's getting better, but there's nothing like having...

tkoselke (7/19/2011)

---

My inexperience is going to show so please bear with me:

The SQL server is 9.0.3042. I don't know what version the tools is or where it's located.

Does...

kstjacques (7/19/2011)

---

Thank you for the responses. I was able to explain to the vendor with confidence that the database was indeed SQl Server 2008 and they no longer refused...

Don't know, but I'm seeing similar issues with the articles that I've read recently.

Like select @@version will...