Miksh, I am trying to understand this better, why was dropping and recreating the table not a desirable solution that you left as a "last resort"? I ask because we...

So did you ever find out why the same thing ran slow on one server and fast on another?

And could someone please explain what you mean by "parameter sniffing"? Thanks!

GilaMonster (5/25/2010)

---

Oksana March (5/25/2010)

---

Or in other words, is it possible to see a list of ALL possible questions that may be in the exam?

I know memorizing the answers is not...

Gianluca Sartori (5/25/2010)

---

Brain dumps are not allowed and violate the NDA. Don't look for the exact questions, try instead to take the chance of this exam to learn as much...

I have an idea...

Are your dates all numeric characters like 01-01-2010 ? Or are they like Jan-01-2010 ?

If they are all numbers, like 01-01-10 or 01-01-2010, since you said you...

Bru Medishetty (1/7/2010)

---

The_SQL_DBA (1/7/2010)

---

Bru Medishetty (1/7/2010)

---

You can start creating databases one by...

emily-1119612 (11/25/2009)

---

This may be a good resource.

http://msdn.microsoft.com/en-us/library/bb522901.aspx%5B/quote%5D

Thank you for the link, but I have no idea what all that means... anybody can tell me?

Jeff Moden (12/4/2008)

---

When is it ok to use it... correct answer is NOT "When you...

Steve Jones - Editor (12/2/2008)

---

One interesting thing Andy and I talked about years ago when he had similar issues is that people can be successful in their job, and show...

Jeff Moden (12/2/2008)

---

jeffkretz (12/2/2008)

---

Gaby Abed (12/2/2008)[hr

Agreed...I'm working on my MCTS for SQL 2005 but I plan to emphasize my experience first on the resumes and keep the certification at the...

My dear friend Jeff Kretz,

yes, learning is very important but if I was in your place and make so much money as you, I would not get critical on myself...

Hi,

It sounds like very nasty problem and the reasons it happens are so many!

Look at these threads because I think they are similar to yours and a lot of people...

Thank you for answering this one, by the way!

GilaMonster (11/29/2008)

---

Oksana March (11/29/2008)

---

I have a question about corruption. How often does it really happen? The previous DBA said it never happen...

Hi Gail,

"Stop SQL" you mean stop SQL Server Agent in the Control Panel--Services? And I just want to confirm: if I create a database to test this *corrupting on purpose*,...

I have a question about corruption. How often does it really happen? The previous DBA said it never happen to us in 7 years that she was here and we...