Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,076 through 27,090 (of 59,101 total)

RE: A Simple Formula to Calculate the ISO Week Number

Andy Warren (4/8/2013)
Jeff, that is a very nice write up and a very nice job of giving credit where credit is due. The code is interesting, the explanation is 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)

April 8, 2013 at 10:07 am

#1604485
RE: A Simple Formula to Calculate the ISO Week Number

SwePeso (4/8/2013)
This is one excellent algorithm to get the ISO week number.
However doing this by using 17530101 instead of 19000101 throws an error
Arithmetic overflow error converting expression to data type...
--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)

April 8, 2013 at 5:29 am

#1604337
RE: A Simple Formula to Calculate the ISO Week Number

cppprogrammer (4/8/2013)
My only feedback is I'm a big fan of sticking to integer arithmetic where possible so a few neat tricks there!
Me too! I knew it was going to...
--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)

April 8, 2013 at 12:25 am

#1604287
RE: A Simple Formula to Calculate the ISO Week Number

You can tell a lot about the stars this early in the game. There was an accidental "2", and then a "5" for a total of 7/2 stars. ...
--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)

April 7, 2013 at 11:58 pm

#1604284
RE: A Simple Formula to Calculate the ISO Week Number

cppprogrammer (4/7/2013)
Damnit! I went to vote 5 stars and the location of the 5th star changed so it hit 2?!? Can I change it?:unsure::blush:
Heh... no. I don't know 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)

April 7, 2013 at 11:29 pm

#1604283
RE: An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

amd.repetto (4/7/2013)
dwain.c (4/7/2013)
amd.repetto (4/5/2013)
The data will be send later as json with a format like ",<id>,<name_of_column>,<value>"
As a sidebar, that format is usually referred to as an "EAV", which stands...
--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)

April 7, 2013 at 1:06 pm

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

Hugo Kornelis (4/7/2013)
Jeff Moden (4/7/2013)
david.holley (4/7/2013)
Would wrapping the SELECT inside another work if the specific order is a concern? Something like...
SELECT @NewString = @NewString + NameInitials FROM
(SELECT NameInitials FROM Employees...
--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)

April 7, 2013 at 12:58 pm

#1604261
RE: The Command Shell

opc.three (4/7/2013)
Jeff Moden (4/6/2013)
If someone get's in as SA, it's not going to matter if you have xp_CmdShell turned off or not. 😉
You keep throwing this one back into the...
--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)

April 7, 2013 at 12:46 pm

#1604260
RE: Huge DIFF Backup, Normal T-Log Backups

homebrew01 (4/6/2013)
I have a 55 Gig database, and the differential backup for yesterday was 32 Gig !! It was about 5 gig the day before
So, I assumed 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)

April 7, 2013 at 8:28 am

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

david.holley (4/7/2013)
Would wrapping the SELECT inside another work if the specific order is a concern? Something like...
SELECT @NewString = @NewString + NameInitials FROM
(SELECT NameInitials FROM Employees WHERE OfficeId = 1001...
--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)

April 7, 2013 at 7:48 am

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

L' Eomot Inversé (4/6/2013)
Jeff Moden (4/6/2013)
L' Eomot Inversé (4/6/2013)
The order of elements in the result string is not guaranteed to be determined by the order by clause, so...
I've heard about...
--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)

April 7, 2013 at 7:39 am

#1604251
RE: The Command Shell

opc.three (4/5/2013)
The recommendation is to leave xp_cmdshell disabled. There is nothing xp_cmdshell offers beyond personal preference and familiarity that cannot be done in a more secure, auditable way, in the...
--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)

April 6, 2013 at 5:27 pm

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

jjturner (4/5/2013)
Thanks David - that was quick! I'll have a go at translating this into VBA and see what happens.
Although it does look like there's no way around firing...
--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)

April 6, 2013 at 5:20 pm

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

L' Eomot Inversé (4/6/2013)
The order of elements in the result string is not guaranteed to be determined by the order by clause, so...
I've heard about that but haven't been able...
--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)

April 6, 2013 at 5:17 pm

#1604240
RE: Is xp_cmdshell Security threat???

Nope. Not bored. Doing research. My take on it, so far, is that disabling xp_CmdShell to supposedly enhance security is like holding up a bath towel to...
--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)

April 6, 2013 at 5:07 pm

#1604239

Viewing 15 posts - 27,076 through 27,090 (of 59,101 total)