Another question related to this. Tech Support people are saying that we didn't start having this problem until the server was upgraded. It went from a 4-core 8GB ram system,...

Okay, so what I see that we're down to is:

1. Upgrade to EE.

2....

Lynn Pettis (2/22/2012)

---

This may sound a bit ridiculous, but if you aren't using index hints what about periodically building a redundent index and then drop the fragmented one? Not...

GilaMonster (2/22/2012)

---

WayneS (2/22/2012)

---

I've thought about running each index to be re-indexed through SQLCMD, and then aborting it after a period of time (say, 30 seconds). This would let some pages...

Hey Threadizens,

Running into a re-indexing issue over here. All thoughts and advice appreciated!

Thanks,

Roy Ernest (2/10/2012)

---

Thx for all the advice. Yes, they have plans for me to go higher up in the management. I have been asked to manage all Development teams and...

jcrawf02 (2/9/2012)

---

Seems timely on the heels of Lynn's news, a big THANK YOU to everyone who sent good thoughts my way a few weeks ago, I was nervous because....we're having...

Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at...

bitbucket-25253 (2/1/2012)

---

Prior last post Posted Today @ 1:03 PM

Now 8:25 PM DECLARE @t TIME

SELECT @t = '7:22'

SELECT DATEDIFF(mi, 0, @t)

Which is 442 minutes

What did the site crash, this thread...

Brandie Tarvin (2/1/2012)

---

MysteryJimbo (2/1/2012)

---

Koen Verbeeck (1/31/2012)

---

Brandie Tarvin (1/31/2012)

---

Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list....

GilaMonster (1/23/2012)

---

WayneS (1/23/2012)

---

As long as one of the values is a decimal, the "/" will return a decimal value. So this will also work:

UPDATE TABLE SET COLUMN_A=COLUMN_A+(COLUMN_B/50.0)

However, Gail's comments about...

GilaMonster (1/23/2012)

---

Oooh......

As long as one of the values is a decimal, the "/" will return a decimal value. So this will also work:

UPDATE TABLE SET COLUMN_A=COLUMN_A+(COLUMN_B/50.0)

However, Gail's comments about lack of...

Good job of posting sample data, but the table definition is a bit unclear... everything is going to be stored as an integer.

So, based upon this sample data, what are...

Red-Gate's SQL Source Control[/url] works with SVN, and it sounds like it will do what you're asking.