Thanks for the nice easy start to the week!

gregory.anderson (2/28/2011)

---

I have implemented this script but am getting the error "Invalid column name 'Value'" when running it. Is there something special that I need to do in order for...

mazzz (2/25/2011)

---

I have already identified the offending session. It's one stored procedure that does quite a lot of things, and runs for a good 2-3 hours to produce some sort...

YSLGuru (2/25/2011)

---

Just curious but why is it that you guys who like to put everything on a new line do this for the SELECT, WHERE, GROUP BY and ORDER BY...

Yes, a config_value of 0 is the default.

SPID 22 is probably a system session, so it shouldn't be causing the problem. (SPIDs under 50 are almost always system processes.)

I...

Thanks for the question, I learned something by it. (One of the thing was to check the date on blog posts, and if it is old you might want to...

mazzz (2/25/2011)

---

I've been running some tests on the test machine and managed to reproduce the error, which was 1204 ("The instance of the SQL Server Database Engine cannot obtain a...

Are you sure you are both running SQL Server 2008 R2? (Not one of you running SQL Server 2008 SP2?) It seems simple but a lot of people get them...

Interesting solution to the problem, thanks for sharing!

Interesting question, thanks! On the connect item it is listed as closed with "a custom resolution." So I am not sure voting for it is very valuable at this point.

You pretty much want the full package: SQLServer2008R2_RTM_CU3_2261464_10_50_1734_x64

The rest are subsets of the main CU for use when you only have portions installed. (You might want to look at the...

Looking forward to the rest of this series, thanks!

Thanks for the question. (It was easy since it has been modified to limit it to SQL Server 2005.)

I've done a little reading, both of blogs and BOL on Denali, and can see there are some cool things coming, but I will probably wait until at least CTP2...

tilew-948340 (2/21/2011)

---

That was a tricky question: I don't use window "server" and I know very little about them (my databases are small enought to put on "regular" window"), so for...