Steve Jones - Editor (2/18/2009)

---

Since this thread seems to be the most popular, a question:

What features would really help you "high posters" here at SSC? Changes to the forums? the...

BobAtDBS (2/18/2009)

---

Dear Learned Ones:

I need help with a SQL Server problem. I don't understand exactly what's going on, or what I should be expecting, but my co-worker said I...

Roy Ernest (2/18/2009)

---

For me this is how it goes... I at first had problem with BOL, because the functions were different from Oracle. So it was frustrating. Now I have...

Heh... Thanks, James. Everyone kept bugging me to do something in the Star Wars fashion... I ran into a clip of a guy...

jcrawf02 (2/18/2009)

---

Jeff, I just made myself feel a whole lot better today, since I was helping someone work through a Pivot, and ended up doing much of what you demonstrate...

Speaking of CLR's and Perl...

There's only two classes of CLR's that I haven't been able to beat for performance (so far), but I've come damned close... RegEx and certain types...

Heh... p.s.

I know this is a 2k forum, but anyone want to challenge with a CLR? The only way I can see a CLR coming close on this one...

Steve Jones - Editor (2/18/2009)

---

5 days is plenty. Sorry, missed the OP date.

I'm interested to see the benchmarks. I know doing this in C would be complicated, but not tremendously...

Steve Jones - Editor (2/17/2009)

---

Give him or her time, might be on the other side of the world.

If you compare REVERSE with SUBSTRING or other string functions, how much slower...

... and if you can't trust them, you probably hired the wrong person and should spend more time on personnel evals and the firing process than approving travel for someone...

Ah... another "tweek"....

WHERE EmployeeID IS NOT NULL is a bit slower than WHERE EmployeeID > 0 assuming, of course, that you have no EmployeeID's <= 0... sometimes, quite a...

Lynn's suggested changes are a great way to start. What he failed to mention is... why. Even if you added a pot wad of indexes to the original...

p.s. ... and we did it without {gasp} tool tips in SQL. Yes, there are some grand improvements that could be made to SQL, but we've seen the...

I read the last paragraph with mixed thoughts on the subject of code metrics. I started playing back in my mind what many Developers do if left to their...

4DJ**** (2/17/2009)

---

simple recovery mode will still write to log file. but in bulklogged recovery model, these type of operations are not logged at all. so saveing time on IO, CPU...