j.b.shteyn (4/9/2014)

---

Three people were there for the pizza, the rest for the presentation - none were there to mingle. I did talk to one person though, he...

Cody K (4/10/2014)

---

I don't think that's what certifications are for, so I'll pose this question: if you have two roughly equivalent applicants for a role:

- One has experience, and says,...

As someone who used to hire people....

Nope. I don't care.

I know the test says it's advanced and special and shows off a great deal of knowledge, but that's just not...

Awesome. Glad you figured it out.

You're experiencing page splits or rearrangement due to changes in the data and you're using, I suspect, a client-side cursor to retrieve the information. This is actually normal behavior. You've...

Rebuilding an index online means it will absolutely be accessible. An index rebuild without the online option will block access while the rebuild occurs. It's a bit of a dance...

In general, not always, but usually, the error message is telling you what's wrong and what you need to do to resolve it. You had an incomplete restore, specifically on...

Yeah, but even if they're "on the server" they're using SSMS, right? You could check the default connection settings for each. ANSI differences could be occurring. Not sure why that...

If you're looking at the Data Explorer and the event you're looking at is database_xml_deadlock_report, it's going to just have an XML output. You can open that as you've seen...

Prediction? No. But following coding best practices to write queries such that they access objects in the same order, that they don't have major performance issues, that they use indexes...

Please don't cross post questions to multiple forums. It just confuses the discussion.

Gail, I said the same thing on the other one.

Sounds like you need to do what it suggests, start the process over again. Be sure that the FULL BACKUP you're restoring is linked to the DIFFERENTIAL you're restoring.

First, follow the suggestion and increase your max worker threads. That will both alleviate the issue and make it worse at the same time. It sounds like your system has...

Don't run DBCC checks hourly. That's a very serious load on the system.

Since you've never run the consistency checks, I'm with Gail, let them run no matter how long it...

The entire idea behind backups is to have a complete copy of the database. A restore operation also is a complete copy of the database. This is not an import/export...