jay holovacs (3/24/2010)

---

Andy-452557 (3/24/2010)

---

It's interesting that this is so much an "East vs. West" issue - but living in the Midwest (Nebraska - smack dab in the middle) it is...

Tom,

You don't have to autoshrink to get the data into ram. Rebuilding/reorganizing indexes will reduce the # of pages that hold data and allow SQL Server to load the...

While I have been critical of the decision by PASS, I agree that where ever the Summit is held it is worth going. I also will say that I'm...

Barry,

Glad to see you are back and appear to be doing well. Hope the surgery turns out to be a total success and that your back issues are over.

Gail,

I'm...

The Dixie Flatline (3/23/2010)

---

Another approach would be the use of a NOT EXISTS test in your WHERE clause, something like this

SELECT ...

FROM computer_lists

WHERE NOT EXISTS (select 1 from software...

GilaMonster (3/23/2010)

---

Jack Corbett (3/23/2010)

---

Personally I think the certification debate ought to be a priority for the organization. Setting some kind of continuing education should be important as well. I'll...

Phil,

This is my reply to your DM, just in case someone else has the same questions.

Any operator you can put in the WHERE clause can go in a JOIN....

Thanks. I just got some feedback on Twitter that you can as well. It is supported back one major version. So 2008 to 2005.

No problem.

I may try out SSRS 2008 DB on 2005 Engine in a VM later. Be an interesting blog post. Can you provide the link to the information...

CirquedeSQLeil (3/23/2010)

---

Jack Corbett (3/23/2010)

---

Michael Valentine Jones (3/23/2010)

---

Lynn Pettis (3/23/2010)

Actually there are still a good number of current Dungeons and Dragons players out here. Why not call it a "Guild"?...

CirquedeSQLeil (3/23/2010)

---

Jack Corbett (3/23/2010)

---

In my opinion, this is one of the areas where PASS should be leading. Either PASS should develop a better certification or it should be working...

GabyYYZ (3/23/2010)

---

GilaMonster (3/23/2010)

---

Dave Ballantyne (3/23/2010)

---

Not odd, ive always thought the exams are based around , can you remember obscure syntax for obscure functionality used once in a blue moon....

Michael Valentine Jones (3/23/2010)

---

Lynn Pettis (3/23/2010)

Actually there are still a good number of current Dungeons and Dragons players out here. Why not call it a "Guild"? Other professions...

blandry (3/23/2010)

---

What a topical editorial!

Just two weeks ago we were dealing with a client where two of their staff, one a DBA, and one a "SQL Expert" proved to me...

Right now Microsoft is offering a second-shot promotion where, if you register using the code, you get a second shot at the exam for free. Check out the Microsoft...