Lynn Pettis (4/29/2013)

---

sql-lover (4/29/2013)

---

Lynn Pettis (4/29/2013)

---

sql-lover (4/29/2013)

---

The best way to fix deadlocks is via T-SQL code, changing the order of your transactions.

Deadlocks occurred because two transactions pin each other, so...

Lynn Pettis (4/29/2013)

---

sql-lover (4/29/2013)

---

The best way to fix deadlocks is via T-SQL code, changing the order of your transactions.

Deadlocks occurred because two transactions pin each other, so the 1st one...

There is no tutorial for that, because each application is different. And it is very hard to give a "cook recipe" or one quick answer.

You need to get a baseline...

The best way to fix deadlocks is via T-SQL code, changing the order of your transactions.

Deadlocks occurred because two transactions pin each other, so the 1st one can't complete because...

Perry Whittle (4/24/2013)

---

When using storage multi pathing one would sort of hope that the hardware would be in place to support the topology otherwise a switch hardware failure will leave...

The MCS policy was set to "round robin".

Now, I do believe we are using the default Microsoft MPIO driver, but where can I check than on Windows and confirm? I...

Hi Perry,

The shared storage is a Dell Compellent SC8000 SAN, connected via iSCSI / MPIO to both nodes. The Windows Cluster runs on Win2008R2 SP1. MS-SQL runs SQL2012 Standard.

I also...

matt.gyton (4/23/2013)

---

Hi there,

We currently have an issue with one of our SQL 2008 R2 Clusters. The cluster contains 2 virtual nodes with 2 SQL instances, and both of the...

Geoff A (4/22/2013)

---

might be that allocating 150GB is what is taking up some of your time. when a failover occurs, tempdb is re-created. by pre-allocating the space, the server has...

sqlfriends (4/18/2013)

---

Thanks, that is a good alternative. I ended up adding that account temporily into database as dbowner when backing it up, after done, I removed it from original database.

So...

Two things ...

DBCreator is a server role. dbowner is a database role. So you are...

Because DBCREATOR role...

Well,

Couple of things. I ran the validation test and passed with a few warnings. Some of them saying that I have mutiple NICs on same network segment, but this...

jamessfrench-839278 (4/18/2013)

---

I'll have to check on the LUN with another person. I was focused on the file groups as a way to avoid backing up all the data, so...

runal_jagtap (4/18/2013)

---

All went well at Migration... on server (XXX)

One issue i have encountered..

While scheduling the jobs on server (XXX) the jobs are scheduled properly from a local server machine.. &...