Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,406 through 54,420 (of 59,098 total)

RE: Formatting the date

In MS Word...
{Edit}{Paste Special}{Unformatted Text}
--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)

October 29, 2007 at 5:23 pm

#746429
RE: Formatting the date

Greg,
Lot's of folks keep a bit of handy test table code around for these types of tests. It's built using the same method I showed you to build a...
--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)

October 29, 2007 at 7:06 am

#746229
RE: More junk with dates

And, you've validated the dates how?
I normally don't say "never" to anything... but this would be one of them.
--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)

October 29, 2007 at 6:48 am

#746224
RE: More junk with dates

It's never good to store a date as a VARCHAR... if you want VARCHAR, you would do that in a SELECT... not as a matter of storage.
--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)

October 29, 2007 at 5:01 am

#746159
RE: Improved Query: Better Duration: More reads? More CPU?

Hey SoulTower! Wondered when you'd get a login... especially after the apparent demise of Belution.
--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)

October 29, 2007 at 4:58 am

#746157
RE: Formatting the date

Kenneth Wilhelmsson (10/29/2007)
Oh really?
Then I assume that what was 'desired' was something else than what was written?
You're actually saying that the below example is 'incorrect', or 'undesired', or simply plain...
--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)

October 29, 2007 at 4:43 am

#746154
RE: Temp Table 'vs' Table Variable 'vs' CTE.

Gail... nice explanation! Short, sweet, and to the point.
Sandy... think of a CTE the same as you would any "inline view" or "derived table" except that they are cited...
--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)

October 29, 2007 at 4:37 am

#746151
RE: SQL Log File Size is Growing

It's not likely that a log file would have the extension ".txt"...
--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)

October 29, 2007 at 4:25 am

#746142
RE: Clarity vs Speed

Now, that's what I'm talking about... 43 minutues vs 3... both have the correct answers... which one do you want running on your machine? 😉
--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)

October 29, 2007 at 2:35 am

#746109
RE: Formatting the date

Man, you talk a lot about nothing...
First two sorts are incorrect because they did not sort in the desired order.
--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)

October 29, 2007 at 2:29 am

#746106
RE: SQL query need help!!! urget

Do you have a specific question or do you just want us to do all of your homework for you?
You're in class to learn this stuff and these...
--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)

October 28, 2007 at 8:57 am

#746053
RE: DTS is extreamly slow to transfer data for just 1 small table. Please help!

Check for triggers, as well.
--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)

October 27, 2007 at 11:31 pm

#746030
RE: SQL query need help!!! urget

C'mon man... do your own homework... you haven't even tried...
--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)

October 27, 2007 at 11:29 pm

#746029
RE: Clarity vs Speed

Heh... ok... guess I'll get up on the soap box, then...
ALWAYS use the fastest, most effecient code possible... ALWAYS use comments to explain the code unless it's just too, too...
--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)

October 27, 2007 at 7:07 pm

#746021
RE: Date

Jason certainly had the right idea... and this goes just a bit further for forcing a format... but it's not 100% bullet proof...
DECLARE @test-2 TABLE (SomeDate VARCHAR(20))
INSERT INTO...
--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)

October 27, 2007 at 6:59 pm

#746019

Viewing 15 posts - 54,406 through 54,420 (of 59,098 total)