Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,536 through 50,550 (of 59,091 total)

RE: Performance Tuning meeting

fosco (5/15/2008)
Good Morning,
I need some advice on what to bring up at a meeting with some developers concerning the performance issues they have been experiencing, they said its 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)

May 15, 2008 at 3:49 pm

#816187
RE: getdate() accuracy

That's good info... but like JackO said, that's for DATETIME precision... not GETDATE precision. We're trying to figure out why a high speed loop seems to indicate that GETDATE...
--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)

May 15, 2008 at 8:07 am

#815900
RE: Tally Table

karthikeyan (5/15/2008)
Jeff,
vow...Plenty of uses...
Could you please give me examples for all those uses ? I am eagerly waiting for your reply.
Sure... do a search on "Tally Table" or "Number 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)

May 15, 2008 at 7:28 am

#815859
RE: Tally Table

Take a look at the following URL for additional uses such as
Encoding/Decoding a string
Removing text between delimiters such as in HTML
Doing a "moving" average
Finding/Counting Days of the Week
Finding/Counting Weekdays...
--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)

May 15, 2008 at 7:24 am

#815855
RE: Tally Table

Find bad characters in a string
Remove Digits from Strings
Remove Alpha from "numbers"
Change to Title Case
Histogram of characters in a column
Generate test data (not just dates)
Find gaps in serial numbers or...
--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)

May 14, 2008 at 11:27 pm

#815638
RE: getdate() accuracy

The following shows the accuracy you're talking about...
SELECT 1,CAST('2000-01-01 23:59:59.990' AS DATETIME) UNION ALL
SELECT 2,CAST('2000-01-01 23:59:59.991' AS DATETIME) UNION ALL
SELECT 3,CAST('2000-01-01 23:59:59.992' AS DATETIME) UNION ALL
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)

May 14, 2008 at 10:48 pm

#815623
RE: getdate() accuracy

The CPU does other things... it's not dedicated to running your code.
--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)

May 14, 2008 at 10:41 pm

#815621
RE: Obtaining year and week numbers from a date in SQL

Ack... double post... :sick:
http://www.sqlservercentral.com/Forums/Topic500305-5-1.aspx?Update=1
--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)

May 14, 2008 at 10:19 pm

#815612
RE: SQL Year and Week numbers

Ack... double post.... :sick:
http://www.sqlservercentral.com/Forums/Topic500664-338-1.aspx
--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)

May 14, 2008 at 10:18 pm

#815610
RE: SQL Year and Week numbers

When using DATENAME, it's already in a character format, so you don't need to use CONVERT or CAST...
SELECT DATENAME(yy,GETDATE())+RIGHT('00'+DATENAME(wk,GETDATE()),2)
--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)

May 14, 2008 at 10:08 pm

#815608
RE: Convert Float to Varchar

Better question to ask is why is the column in your table VARCHAR(18) instead of FLOAT like it should be?
--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)

May 14, 2008 at 10:04 pm

#815605
RE: The Lighter Side - Life is like an analogy

What a riot! I laughed out loud especially at the end. Well done, David!
In the same vein, someone needs to write an article on how to be politically...
--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)

May 14, 2008 at 3:15 pm

#815559
RE: You are a T-SQL developer who needs to...

Heh... no problem, Steve... I know about the QOD's and the fact that, like you said, they can't cover every caveat. It's one of those questions that someone asked...
--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)

May 14, 2008 at 1:52 pm

#815521
RE: How to random dates

MD (5/14/2008)
Jeff
I'm not sure if I can use this because it took so long to run. I mean, I can think of better things to do with my seven...
--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)

May 14, 2008 at 1:44 pm

#815515
RE: How to random dates

Thanks for the compliment, Todd... :blush:
Au4848... are you all set?
--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)

May 14, 2008 at 11:54 am

#815454

Viewing 15 posts - 50,536 through 50,550 (of 59,091 total)