Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,276 through 46,290 (of 59,095 total)

RE: Partioned View

It's gotta "touch" the index to find out what the partition is... and that's all it does... it doesn't actually seek any rows in table 1 but it get's listed...
--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)

December 30, 2008 at 8:27 pm

#919414
RE: Common Mistakes in T-SQL

Yep... I agree with all of that as being the biggest mistake. The easiest way to start thinking in the set based pardigm is to stop thinking about what...
--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)

December 30, 2008 at 7:09 pm

#919399
RE: Calculate pmt in t-sql (like excel)

Scott T (12/30/2008)
For any math calculation avoid FLOAT use Decimal you will get Write result.:D
Any bets on that? 😉
--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)

December 30, 2008 at 7:02 pm

#919396
RE: Generating random 6 digit numbers

Yeah... you're right on both counts... not enough coffee here... 😉
--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)

December 30, 2008 at 6:29 pm

#919391
RE: How to calculate the Bi-weekly in SQL

Heh... wha? Moi? Oh... you mean I started it all with my "statement prefix"? 😛
--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)

December 30, 2008 at 6:22 pm

#919388
RE: How to calculate the Bi-weekly in SQL

BWA-HAA! See why I hate the damned things? You guys are still going on about punctuation marks... :P:hehe:
--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)

December 30, 2008 at 6:00 pm

#919383
RE: Semi joins

Bob Hovious (12/30/2008)
Peculiar... on our 2008 development box (which is pretty quiet this week), I ran Jeff's original test and all three ran almost neck and neck. ...
--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)

December 30, 2008 at 5:48 pm

#919381
RE: Break Views by modifying tables

Heh... Z'actly...
--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)

December 30, 2008 at 5:41 pm

#919379
RE: Determining Physical Size of Tables/Indexes etc..

Thanks, Perry.
--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)

December 30, 2008 at 5:31 pm

#919377
RE: CTE Performance

jason brimhall (12/30/2008)
Binary Trees in the MLM industry.
Heh... I thought binaries were illegal in the U.S. I thought uni-level was the only legal method for an MLM.
--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)

December 30, 2008 at 5:28 pm

#919376
RE: Determining Physical Size of Tables/Indexes etc..

Change the commented code in the script I posted and you'll be 2k compatible in the blink of an eye. 😉
--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)

December 30, 2008 at 4:08 pm

#919361
RE: How can i drop database

jaydeep (12/30/2008)
Yes I found the same one.
Thank you.
Cheers,
Jaydeep
Does that mean you were able to drop it by matching case?
--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)

December 30, 2008 at 6:33 am

#918987
RE: CTE Constant

Perhaps it's time to post what the tables look like and what the data looks like. Please see the link in my sigature below for how to get 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)

December 30, 2008 at 6:30 am

#918985
RE: SSIS Lookup using a Script Component

Thanks... guess the rowcounts you gave will do just fine. Don't worry too much about the data... I guess I can gin something up.
--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)

December 30, 2008 at 5:45 am

#918961
RE: Are the posted questions getting worse?

GilaMonster (12/30/2008)
Just because a lot of people use it badly, doesn't make it a bad tool.
Heh... yeah, I keep forgetting stuff like that in my old age. Look what...
--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)

December 30, 2008 at 5:31 am

#918949

Viewing 15 posts - 46,276 through 46,290 (of 59,095 total)