rg (9/8/2008)

---

Just wanted to follow-up to above: Currently suspecting network latency, as SQL test and Oracle prod servers are located in West Coast data center, whereas SQL prod server is...

Thanks, Gaby... 🙂

I haven't used DiskKeeper in 10 years, but the folks at work swear by it. Your SysAdmin probably did a great job insisting that it be installed.

It'[s pretty simple with Bulk Insert and a BCP format file. Take a look in Books Online. If your were to provide the first 100 lines of the...

That works great, but if you go back to the very first post,...

If you read the table using WITH (NOLOCK), you will be able to see the progress of the updates. Of course, that requires a separate parallel process.

Heh... sure... we've already established that it could... you still...

Yep... that'll work... just as soon as you identify what you want to order by, like I said.

Joseph (9/5/2008)

---

Hi friends,

can any one tell me how can we run a long script or query in smaller batches. sometimes I hear my boss telling to developer...

You MUST change the defaults for TempDB or you'll end up having 73 fragments by the time it grows to 1GB.

I normally start out a new system with 1000MB allocated...

Just how do you identify...

It would be easier to simply delete the hacked rows and insert the repaired rows. If the ID column is important for identification of the row, you can use...

p.s.

We have some fairly large systems... in my last job, we booted TempDB at 9GB and in my current job, we boot it at 6GB. TempDB is an important...

The default settings for TempDB are to start at 1MB with 10% growth. If you do the math, it'll take 73 growths to get to 1GB... 73 growths also...

Can't tell from your last post if your serious or not so I'll assume you're serious. 🙂

It's a clever bit of code that Peso wrote. Use...