audiocool (5/18/2015)

---

Hi,

Many thanks for your valuable advise. Could you please guide me through the steps to troubleshoot the problems in my environment. I had around 10 databases with 2...

From what you're describing here, just a backup and restore will work. But if you're only looking to move the structures and the DDL for the database, you might consider...

If you look at the plans, the very first operator, the SELECT operator, has a little exclamation mark. That's a warning. If you open the properties for this, you'll get...

Jeff Moden (5/16/2015)

---

I was interviewing one person who claimed over 10 years working as a Senior DBA and "tuning experience". Here's how the clustered index segment went.

Me: Tell...

David Webb-CDS (5/15/2015)

---

Your customer comes to you and says the query he has run daily for the last two years is suddenly taking hours instead of seconds. You gather...

Better to understand why you're getting different plans. Usually this is because of differences in statistics between the machines. But, it could be other stuff. For example, differences in the...

Sean Lange (5/15/2015)

---

Luis Cazares (5/15/2015)

---

It's important for us that you'll be a good fit in our team, so the following question will define if you get the job or not.

Leading...

Luis Cazares (5/15/2015)

---

It's important for us that you'll be a good fit in our team, so the following question will define if you get the job or not.

Leading commas or...

Eric M Russell (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2, Couchbase,...

Alvin Ramard (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2, Couchbase, DocumentDB,...

What Gail says ( pretty much what I always say).

The way I usually put it, build your structures and write your queries with the fact that there is an optimization...

Biggest thing to remember is that you're going to have to maintain a two-phase commit on your transactions. You have to successfully write to both SQL Server and Couchbase in...

mdsantos (5/15/2015)

---

It's getting complicated to get the bad execution plans. I'm using profiler -> performance events -> show plan all and show plan XML

But after some minutes I get "...

Just this, all by itself, is going to lead to poor performance:

ltrim(ppt_ClaimsManagerDescriptionManual)

If you can't bring in a consultant, and I'm with Kevin, you need to, second best choice, get...

Careful, those are two very different possible solutions to a bad parameter...