Viewing 15 posts - 5,326 through 5,340 (of 5,841 total)
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...
February 19, 2008 at 6:14 pm
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...
February 19, 2008 at 6:11 pm
>>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...
February 19, 2008 at 4:33 pm
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....
February 19, 2008 at 12:10 pm
>> 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...
February 19, 2008 at 11:36 am
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...
February 19, 2008 at 10:23 am
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...
February 19, 2008 at 7:24 am
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...
February 18, 2008 at 1:35 pm
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...
February 18, 2008 at 1:09 pm
[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. ...
February 18, 2008 at 8:54 am
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...
February 16, 2008 at 9:44 pm
Jeff Moden (2/16/2008)
TheSQLGuru (2/15/2008)
Kevin, do you, by any chance, have a...
February 16, 2008 at 9:40 pm
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...
February 15, 2008 at 7:02 pm
>>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...
February 15, 2008 at 5:50 am
Viewing 15 posts - 5,326 through 5,340 (of 5,841 total)