Jeff Moden (6/10/2014)

---

GilaMonster (6/10/2014)

---

Jeff Moden (6/10/2014)

---

Grant Fritchey (6/9/2014)

---

SQL Server prevents changes from occurring at the same time. It's part of the Atomicity, Consistency, Isolation, and Durabality (ACID) properties of the...

jasona.work (6/10/2014)

---

dax.latchford (6/10/2014)

---

Also as mentioned my colleague has created a domain account with the rights to backup to a UNC location. Is it safe for me to do the following...

It sounds like a good approach, but, one point. You do know that it's actually not likely to speed up your restore process. Assuming you script your restores, currently you...

Yep, John has nailed it. I'd add a +1 if we had that capability here.

Compatibility mode is supposed to be a temporary fix as part of the migration of your database to the new server, allowing time for the code and application to catch...

Assuming we're talking SQL Server 2012, you don't have to set the traceflag any more. The system_health extended event session captures deadlock information automatically.

Deadlocks are fundamentally a performance problem. So,...

SMALLDATETIME only runs January 1, 1900, through June 6, 2079. It sounds like the value you're trying to convert falls outside that range. Or, as Koen already said, it's not...

Just a suggestion, instead of granting permissions to a user, create a role, assign that role permissions, add the user to the role. That way, you can give multiple users...

John Mitchell-245523 (6/10/2014)

---

vijay.singh 14112 (6/10/2014)

---

Hi John,

Please find the error message below.

Msg 3169, Level 16, State 1, Line 1

The database was backed up on a server running version 8.00.0760. That version...

But it's like Karen already said. You can create a table in Azure without a clustered index, but you can't put data into it, so what's the point? If anything,...

You can try to kill the process that is running, but, if it's part of a transaction, then you'll still have to wait for the transaction to complete it's rollback...

Well, I have used Visual Studio 2013 to create a MASD database before, so I'd be inclined to think it might be something to do with your configuration possibly. Maybe...

mikeg317X (6/9/2014)

---

Grant Fritchey (6/9/2014)

---

You are posting in a SQL Server 2008 forum. Since you're using Sybase, you're more likely to get specific assistance by posting the question in a forum...

A full backup records everything going on in the system, all the transactions that are running during the backup process, those that finish, those that don't. It all gets written...

And you see that where, in the properties? No, I can't say that's one I've run into. It sounds like something might be broken. Can you save the execution plan...