Hey, anyone know if there is a way to extract out all of the 200+ posts for this thread into a single document? I would very much like to...

Agreed on all counts Frank. There is almost never a one-size-fits-all rule or statement. Which is one of the primary reasons that experience is so important in this...

>>Why store the running totals when it is fast to compute them on demand? What you don't store can't hurt you....

Yes, in fact, it can. We store precalculated data...

1) Aren't ALL jobs scarce in Michigan, not just SQL Server ones?? 😉

2) The Research Triangle area of NC is really good for tech work right now....

>> My problem, lately, is that people know so little about SQL Server in the Detroit area, they think any ol' GUI programmer or network admin can maintain and...

Can't say I agree with that title. Just did a first visit at a new client last week for a performance review. They had a relatively new product...

Sure hope for some good news!!

ALZ - CLR is known to have some memory management/usage issues. Perhaps using the -g parameter you could start up sql server with more memtoleave (512 perhaps?). Not...

Don't mean to co-opt the thread but can you please email me a link to the regex code you found optimal for CLR? I have a client in DIRE...

I have not personally worked with any RDBMS other than SQL Server for over 10 years now. I am clearly heavily invested in the SQL Server stack and thus...

[RANT ON]

Absolute rubbish!! SQL 2k5 SP2 was a disaster. The number and severity of bugs in (for example) SQL 2005 SP2 is completely unacceptable and unconscionable, IMNSHO. ...

Off Topic

Hey Matt - I got your remote "Hello" at the Raleigh Code Camp today. Some guy came up to me and said "Hey, your TheSQLGuru (had that on...

Jeff Moden (2/16/2008)

---

TheSQLGuru (2/15/2008)

---

2) use of a table variable voids the use of parallelism which can significantly reduce performance for large dataset processing./quote]

Kevin, do you, by any chance, have a...

Boy, I go off to a CodeCamp dinner and come back and BAM - 15 more entries on this thread! 🙂

2 points

1) SELECT ... OVER(ORDER BY...) does guarantee the order...

>>Well...There's got to be a way to use the CTE and ROW_NUMBER() and guarantee an ordered update...

Sorry, but there doesn't have to be. Just because we really wish something...