Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,441 through 43,455 (of 59,063 total)

RE: Week numbers and week start dates

First, do not use BETEEN for this. It will give the incorrect answer.
Second, the following code is totally untested because you've provided no test data. If you're interested,...
--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)

June 12, 2009 at 12:33 pm

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

Bruce W Cassidy (6/11/2009)
[font="Verdana"]Jeff: it's a great article, and the fundamental basis for so many optimisation techniques that I have seen you and many other people talk about.
I have 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)

June 12, 2009 at 11:51 am

#1008834
RE: Random problems

benoit.rocco (6/11/2009)
Thank you very much for your answer but I already found the response. I deleted my message but apparently it didn't work.
Cool. Tell us what it was. ...
--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)

June 11, 2009 at 9:19 pm

#1008370
RE: How do you get the size of a database - sql server 2005

Heh... that chart shows a high potential for performance problems... 2Mb temp table. 😉
--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)

June 11, 2009 at 9:15 pm

#1008369
RE: convert from varchar to datetime

I'd still like to know what the OP is going to do with the dates once they are converted.
--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)

June 11, 2009 at 9:13 pm

#1008367
RE: Week numbers and week start dates

balars_2000 (6/10/2009)
Jeff, I have a problem.
The query is working fine and listing all week numbers and dates.
However, I am interested in week day starting Mondays which is 05/01 for current...
--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)

June 11, 2009 at 9:00 pm

#1008362
RE: Mining for Quitters

GSquared (6/11/2009)
Don't disagree with you about the need for human involvement in the process. I just think a system that can do things like track average national and local salaries...
--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)

June 11, 2009 at 9:12 am

#1008067
RE: Programming Training

http://www.sqlservercentral.com/Forums/Topic695088-149-1.aspx#bm695796
bpowers (4/13/2009)
Not quite sure how to go about the suggestions. To say I am a novice is an understatement. Here is the table I put together. How do I implement...
--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)

June 10, 2009 at 10:15 pm

#1007772
RE: convert from varchar to datetime

abhavsar (6/10/2009)
SELECT date_id
FROM Summary_D
Brings data in following format.
May 17 2009 12:00AM
May 18 2009 12:00AM
May 22 2009 12:00AM
May 26 2009 12:00AM
May 27 2009 12:00AM
Jun 1 2009 12:00AM
May 20 2009 12:00AM
May...
--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)

June 10, 2009 at 9:41 pm

#1007767
RE: Differences between Unicode Text and ASCII text file

jagadish_sds (6/10/2009)
That differences I knew, I am asking what is the differecne between Unicode & ASCII text file in SQL Server, both are generating .sql file and content also same....
--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)

June 10, 2009 at 9:37 pm

#1007766
RE: Random problems

christian_nowicki (6/10/2009)
Peso (6/9/2009)
And it's also well established that
ABS(CHECKSUM(NEWID())) % 100
gives random numbers between 0 and 99 with very high, good and even distribution.
I like this solution - it is simpler...
--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)

June 10, 2009 at 9:35 pm

#1007765
RE: Differences between Unicode Text and ASCII text file

RBarryYoung (6/10/2009)
What you should be able to see however is that the Unicode .sql file is about twice the size of the Ascii one.
Any idea if SQL Server supports UTF-8?
--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)

June 10, 2009 at 9:16 pm

#1007762
RE: Week numbers and week start dates

balars_2000 (6/10/2009)
thanks jeff.
You bet. Thanks for the feedback. So, are you all set or do you have a remaining question?
--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)

June 10, 2009 at 8:39 pm

#1007755
RE: Differences between Unicode Text and ASCII text file

It's what you can't see that makes the difference... the following is a very good article on the subject...
http://www.joelonsoftware.com/articles/Unicode.html
As a side bar, it took me about 2 minutes 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)

June 10, 2009 at 8:27 pm

#1007753
RE: Updating diff columns & multiple rows of same table

{insert jeaopardy them song here} Heh... I'll just bet someone talked him into a cursor solution.
--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)

June 10, 2009 at 8:00 pm

#1007747

Viewing 15 posts - 43,441 through 43,455 (of 59,063 total)