Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,471 through 31,485 (of 59,101 total)

RE: HHMMSS int field to human-friendly time?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2012 at 10:54 am

#1430200
RE: HHMMSS int field to human-friendly time?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2012 at 10:16 am

#1430194
RE: Quirky Update query...works on server ...fails on PC.

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2012 at 8:50 am

#1430166
RE: Quirky Update query...works on server ...fails on PC.

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2012 at 8:47 am

#1430165
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

david.holley (1/7/2012)
Its for a scheduling module. Each date can have different start/end times. Since the majority of the start/end times will be the same, the idea is to speed entry...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 8, 2012 at 12:00 am

#1430112
RE: Quirky Update query...works on server ...fails on PC.

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2012 at 11:48 pm

#1430111
RE: Creating a round robin table with SQL & VB

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2012 at 5:59 pm

#1430093
RE: Creating a round robin table with SQL & VB

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2012 at 3:33 pm

#1430076
RE: Creating a round robin table with SQL & VB

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2012 at 12:43 pm

#1430064
RE: Quirky Update query...works on server ...fails on PC.

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2012 at 11:21 am

#1430048
RE: Add previous cell value - loop until funtion

Thanks for the feedback, Istvan.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2012 at 11:05 am

#1430045
RE: Quirky Update query...works on server ...fails on PC.

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2012 at 10:45 am

#1430037
RE: Are the posted questions getting worse?

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2012 at 10:29 am

#1430031
RE: Are the posted questions getting worse?

GilaMonster (1/7/2012)
I couldn't care two hoots about counts, here or elsewhere.
If I cared about counts I'd go and make pointless posts on every single thread here. Would get me...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2012 at 10:11 am

#1430026
RE: Are the posted questions getting worse?

Ninja's_RGR'us (1/7/2012)
Edit : I was going to say "same mold" but somehow it didn't look right.
Heh... Wow! I'll turn 60 this year... perhaps "mold" is a fitting...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 7, 2012 at 10:03 am

#1430023

Viewing 15 posts - 31,471 through 31,485 (of 59,101 total)