Have '0' as in just '0' for the date, or 0 in front of the date.

Can you provide some sample data of problematic rows?

Depends. If it's...

don.schaeffer (12/9/2014)

---

For me it's a good time to finally apply the latest service pack to our servers. And tentatively disable some of those sysadmin accounts that seem to sprout...

Take it. You can submit a draft online using the "Write for Us" link to the left of the browser window.

We've got this: [/url]

If you want to tackle things differently, maybe more PP, that would be fine. Should get to your article today or tomorrw.

Alejandro,

That would be interested. If you can tackle this from a technical perspective, show some real world examples of what works and doesn't, that would be good.

Alejandro,

That would be interested. If you can tackle this from a technical perspective, show some real world examples of what works and doesn't, that would be good.

andrew gothard (12/9/2014)

---

App set up so exactly the same call is made a shedload of times? I've actually seen a 'database problem' where things were admittedle on the slow...

A good weekend for me. A bye, but good performances from my players. Let's hope they can continue next week in the consolation bracket.

Maxer (12/5/2014)

---

Just for fun, I DISABLED Instant File Init on both servers and ran the same create statements:

fast server - 5 seconds, 7 seconds one time

slow server- 80 seconds (so...

It depends.

Object Explorer has a connection to the server instance. If the connection has a context of...

Oh, that's good, Conor. That would be interesting to know.

If you ran SSMS to connect, the Object Explorer might have taken the single connection and prevented this from working.

Perry is correct here. The log backups apply to the log backups. They're based on linking each other together, not with the full.

You do need a full backup to get...

Hard to know. I suspect you're too worried about this particular VM. It's likely (I think) and Azure thing, but perhaps you did something? Do you have completely scripted setup...