Viewing 15 posts - 31,471 through 31,485 (of 59,102 total)
As a sidebar, it looks like they've really messed up the colorization on the code windows again. I sent an email to the SSC webmaster and have gotten no...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2012 at 10:56 am
To add to the reasons not to use undocumented or, sometimes, even documented MS provided code...
The Developers of SQL Server will occasionally make significant performance mistakes in their code just...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2012 at 10:54 am
Sean Lange (1/6/2012)
I searched on google for "sql server convert sysjobschedules to datetime" and the very first hit has the following function.
Unfortunately, the function fails for certain date time combinations...
select...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2012 at 10:16 am
SQL Kiwi (1/8/2012)
this is only needed where the clustered index is NOT defined as UNIQUE (as it should be)
Ok... now I'm totally embarrassed. I totally missed that very...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2012 at 8:50 am
ChrisM@home (1/8/2012)
Jeff Moden (1/7/2012)
Absolutely incredible, Paul. Great bit of research...
No kidding. What Paul's modestly neglected to mention is the 5-fold performance lift provided by removing the table spool from...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2012 at 8:47 am
david.holley (1/7/2012)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 8, 2012 at 12:00 am
Absolutely incredible, Paul. Great bit of research. I've got to find a machine I can make it fail on and then try that fix. Nicely done.
JLS... perhaps...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2012 at 11:48 pm
Well, I thought I had the math worked out. :blush: My apologies. Creating the schedule is a bit tougher than I thought (correctly rotating the field of...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2012 at 5:59 pm
Actually, looking back at it, that does you no good because it's not actually a schedule. :blush: It doesn't contain "rounds" nor "fields of play". I'm working on...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2012 at 3:33 pm
If I understand correctly, you simply want it where all teams play all the other teams? Here's one way to do that...
--===== Declare and set the number of players...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2012 at 12:43 pm
SQL Kiwi (1/7/2012)
The only sensible move at this point seems to be to recommend that the quirky update is only ever used with the safety check in place.
P.S. I...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2012 at 11:21 am
Thanks for the feedback, Istvan.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2012 at 11:05 am
SQL Kiwi (1/7/2012)
I think that conclusion, smiley notwithstanding, risks offending those that have spent significant personal time looking into this.
Sorry ol' friend. Didn't mean to come across as snarky....
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2012 at 10:45 am
L' Eomot Inversé (1/7/2012)
Brandie Tarvin (1/6/2012)
At the risk of being virtually lynched, I can see the use in underscores in table names and especially in constraint names.
I use them in...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2012 at 10:29 am
GilaMonster (1/7/2012)
If I cared about counts I'd go and make pointless posts on every single thread here. Would get me...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2012 at 10:11 am
Viewing 15 posts - 31,471 through 31,485 (of 59,102 total)