sqlbuddy123 (1/13/2011)

---

You can't allocate memory at the individual query level.

...

Koen (da-zero) (1/13/2011)

---

Grant Fritchey (1/13/2011)

---

Koen (da-zero) (1/12/2011)

---

TheSQLGuru (1/12/2011)

---

I am curious what you mean by "advisor" here. Hopefully you do NOT mean Database Tuning Advisor!! Avoid that like the...

Sachin Nandanwar (1/12/2011)

---

It can be done for a particular login using resource governer but not for a query or a SP.What you do basically is create resource pool and assign...

So I gave up daisy chaining in favor of scripting out deletion of the old merge articles between 2000 and 2000 and creating new merges between 2008 and 2000 stores....

Linked on my LinkedIn profile. I wonder how wide the scope of this issue is. I have seen rename used many times and I bet there are alot of DBA's...

GilaMonster (8/14/2010)

---

Start saving up. I've been paying for myself the last 2 years.

By speaking at the conference, the conference fee...

While I agree that SQL Server has come a long way, after spending a week with 2 professional and experienced IBM DB2 DBA's and 2 professional and experienced Oracle DBA's,...

Get a great job in a great company like Centriq Training of Kansas City! 🙂 We are always on...

Wow, I really missed it 🙂

I missed it!!! I was in New Orleans this year...

hehe.... the first words out of my mouth today were, " I would never recommend doing this but IF you wanted to..."

🙂 I have always known it could be done...

Yes, I tried it and it works. And I could even modify it carefully and it still works.

Thanks for the info!

BTW, and I am aware that using a plan is...

To use it in conjunction with a T-SQL statement... could I use it with an OPTION (USE PLAN...) clause? The examples I have found are calling .xml... It looks...

Question Guy (7/20/2010)

---

My title is DBA, but I have no official responsibility for database backups, clustering, or restores, or anything to do with hardware. I don't even have access to...

jeff.mason (7/20/2010)

---

Some do, some don't. It's the same old thing -- people all say that you need a DBA but no one accepts what a DBA says because they...