Sathvik (6/12/2014)

---

Hi All,

Recently we have migrated sql server 2008R2 server to 2012, But after migration one of the stored procedure is taking 2mins execute in 2012 server. It took...

Removing extra hits on a table is a HUGELY important thing in many tuning exercises, and it is good that you did that here. But you stated you got...

ramana3327 (6/10/2014)

---

Hi All,

I do have table Ex: customer. I do have some select statements based in where clause studentid.

I am retrieving

student name, age , marital status, contact no from...

1) SSMS Tools Pack. Not free, but you get WAY more than you pay for! Tell Mladen I sent you. 🙂

2) util_generate_inserts. OLDIE BUT GOODIE, and I...

Here's an oldie but goodie for deadlock troubleshooting: http://blogs.msdn.com/b/bartd/archive/2006/09/09/deadlock-troubleshooting_2c00_-part-1.aspx. Be sure to follow all 3 parts of the blog series.

Some deadlocks are a no-brainer to fix (once you...

The windowing function does indeed perform better than the double-hit. I just tested to 100K rows and it was anyway.

I was hoping the OP would work that out and either figure things out for himself or come back for some details....

singhgurvindersaini (6/9/2014)

---

We are in a situation where we have very busy OLTP system which is doing lot of deletes and then inserts,

the ghost cleanup task cannot keep up, its...

Can you tell us what you were trying to solve with this?

I note you get the same output with this:

SELECT

Country ,

MAX(CustID) ...

Agree - not possible.

I would use this construct (with each "check for error" being a rollback and terminate and message):

BEGIN TRAN

delete table1 where ...

check for error

delete table2 where ...

check for...

Yes. As can checkdbs. But just knowing something can be done doesn't tell you why they...

Wow - all that for 30GB of space?!? Sad to be worried about so little in today's age! :w00t:

tcronin 95651 (6/6/2014)

---

looking at migrating current sql 2008r2 active/passive node with log shipping to two servers, one for true DR the other used as report server read only. Questions...

No way I am trying to muddle through that many words of complex logic and actions/outcomes!! I doubt anyone else will bother either. Even if you can't post...

Shrinks SUCK!!! They will no matter what you try to do - unless you can do a truncate_only shrink and get back the space you need, but how often...