Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,291 through 46,305 (of 59,101 total)

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
RE: CTE Constant

josemyj (12/30/2008)
Is a good aproach, but keeps a very big SQL when we reach the 2000 fields.
The problem: Users have a list of their shops, and choose between 4000 arbitrarily....
--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:22 am

#918942
RE: Take off in my Query

Double post. Please don't post here. Follow the link below to the other post.
http://www.sqlservercentral.com/Forums/Topic627219-373-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)

December 30, 2008 at 5:11 am

#918938
RE: How to design new query to take off invoice?

You have 2 activity columns... what are they really called?
And please... not nice to double post.
--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:09 am

#918937
RE: Opinions, performance implications of 1 bidge table vs 2 bridge tables

Just to be sure... creating a view doesn't necessarily improve any performance and, if it's done badly, can be quite the performance hog.
--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:59 am

#918931
RE: How to validate a CSV import file?

Good thread. I like the sp_MakeWebTask trick.
--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:55 am

#918928
RE: How can i drop database

Adi Cohn (12/30/2008)
If you do have admin privileges, then maybe you misspelled the database’s name. If the server was installed as case sensitive, the database’s name is also 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 4:50 am

#918925
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Thanks, Anzio.
--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:46 am

#918923
RE: Adding integers in a table

Heh... so which is it that you actually want? A running total, or a current balance for new rows... there is a slight difference.
--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:42 am

#918920
RE: Are the posted questions getting worse?

GilaMonster (12/30/2008)
Jeff Moden (12/30/2008)
Seems like the intent of Microsoft was to make things easier for folks that don't know how to do it in T-SQL...
I don't agree with 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 4:37 am

#918918

Viewing 15 posts - 46,291 through 46,305 (of 59,101 total)