Grant Fritchey (12/15/2014)

---

The one thing that always validates whether or not any backup mechanism is any good is to run a restore.

So, use your bosses approach on 3-5 different...

triggers? foreign key constraints? ok out of ideas!

I wonder if 'NO_TRUNCATE' part of the command keeps these tlog records active, and they just accumulate? Whats the reason for using 'NO_TRUNCATE' in your case, just curious!

they look like differentials since theres not one instance of them decreasing in size.

How about something like this:

DECLARE @ID INT, @DAT VARCHAR(100)

SET @ID = 1

SET @DAT = 'TEXT 1'

INSERT INTO TEST1

SELECT @ID, @DAT

WHERE NOT EXISTS (SELECT ID FROM TEST1 WHERE ID = @ID)

SELECT...

Yeah that does sort of indicate that 257 million rows is a bit of data to push through looking for nearby neighbors....

Right off hand, you might want to try to convert that function into an inline calculation. Other experts might give better advice, but it might be the case that multiline...

Also check out this link: http://msdn.microsoft.com/en-us/magazine/jj133823.aspx

This talks about putting locations into "sectors" to chip away at the efficiency problems, maybe you can get some insight into some of the issues...

Post your data as all text, as insert statements into your demonstration tables. Obviously, works best if you don't post zetabyte databases this way LOL just post a sample set...

ZZartin (11/21/2014)

---

g.britton (11/21/2014)

---

good point, though...

Gary Varga (11/18/2014)

---

Stefan Krzywicki (11/18/2014)

---

...Companies are far too beholden to shareholders who contribute little to the company. They should be the last thought, not the first.

If you really want to...

Eric M Russell (11/18/2014)

---

patrickmcginnis59 10839 (11/18/2014)

---

Ed Wagner (11/18/2014)

---

Eric M Russell (11/18/2014)

---

I wonder how many ordinary people superficially maintain a FaceBook page, not for dumping their actual daily life, but just...

Ed Wagner (11/18/2014)

---

Eric M Russell (11/18/2014)

---

I wonder how many ordinary people superficially maintain a FaceBook page, not for dumping their actual daily life, but just for use as a presentable...

Brandie Tarvin (11/11/2014)

---

To clear up a misconception... we did stop the processes on the Test machine and I was immediately able to connect, as was the DBA sitting next to...

ShineBoy (11/10/2014)

---

Not quite sure exactly where you are coming from or what answer you expect. BUT surely you are right. SQL server requires CPU to do anything (else why bother...