I'm thinking that you've squeezed just about all the speed you're gonna get out of...

I absolutely agree!

Insert of 3.3m rows.

Best run (no index). 270 - seconds

worst run (with index) 283...

Kurt W. Zimmerman (10/1/2007)

---

I've had to deal with very long running updates and processor intensive stored procedures that has been able to take my dual quad core w/ 8gb to...

... and what about the EndDates that are NULL? 😉

Post the entire test harness so we can do the same test, Tom 😉

Oh... and do be aware that STR uses FLOAT for it's main operand... 😉

I assume you're talking about adding leading...

nigelrivett (9/29/2007)

---

There is a case for auditing inserts - it depends on what you are using the audit trail for.

If you want to report on full history of the data...

Ninja's_RGR'us (9/29/2007)

---

Sorry Jeff, but I only audit full rows, not columns sot he 5:1 ratio doesn't apply.

2 what do you do about the rule that says that auditing data should...

Outstanding job Steve, Warren, and Andy!!! Yeah, I know... Warren and Andy are on the "sidelines" now, but that group of 3 started this! Nicely done!

Open Query Analyzer...

Press f8...

Drill down to table and "columns"...

I think you might need two roles... one for WebGroup and one for WebGroupAdmin which is where you'd put Tracey. Then maybe do some correct grants?

Simply put, there are more reasons than I could possibly post here as to why you should not, nay, must not store dates as 3 separate columns. The efficiency...

I gotta ask, because you're a newbie....

Why are you worried about reassigning barcodes? Bar codes can be made to easily exceed 2 billion (approximate max for an INT). ...

Hey there PoleCat... long time no "see"...

Is it the goal of this bit of code to update all but the "first" row for each customer what has been entered within...