Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,131 through 50,145 (of 59,099 total)

RE: CLR Table-valued function

nenad.prekupec (6/11/2008)
The reason of opinion that CLR is slower then T-SQl is just because people didn't get familiar with CLR and doing ridicules performance test to show CLR is slow.....
--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, 2008 at 5:14 am

#827154
RE: My Own Custom Table Partitioning

ammon (6/10/2008)
So, regarding one of my questions, how well does a table perform with over 2 billion rows?
Ya got me... I've worked with tables as large as 200 million rows,...
--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, 2008 at 10:17 pm

#827056
RE: Error Creating format file for bcp

For those that want to follow along in English...
http://msdn.microsoft.com/en-us/library/ms178129.aspx
There are many problems with the command that you have submitted. First, do you have a table already available called MyTestFormatFiles...
--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, 2008 at 9:03 pm

#827039
RE: My Own Custom Table Partitioning

I agree with Paul's assessment... it's a good thing to plan on that type of scalability, always... but I see no mention of "clustered" servers or the other things 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)

June 10, 2008 at 7:23 pm

#827031
RE: BETWEEN

Heh... No matter what, I'm happy I don't have to earn a living by taking Matt's tests 😛 They are thought provoking to say the least...
--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, 2008 at 7:08 pm

#827024
RE: My Own Custom Table Partitioning

Then, BigInt should do the 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)

June 10, 2008 at 7:25 am

#826627
RE: My Own Custom Table Partitioning

Just curious... Max size for INT is over 2 billion... that should handle your 10 million rows quite nicely for 214 tables. Why would you need unique numbers for...
--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, 2008 at 7:06 am

#826601
RE: The Bulldogs

Steve,
The link to "IT Project Failure" is broken.
On the subject of IT Project Failure... how often is it that IT is the one that "designs" a project? Normally, it's...
--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, 2008 at 4:58 am

#826530
RE: Compute Column

You bet...
--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, 2008 at 4:43 am

#826526
RE: Audit Trails and Logging Part I

Good tip! Thanks!
--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, 2008 at 4:38 am

#826522
RE: Numeric vss Bigint

Beat me to it, Gus...
--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 9, 2008 at 6:21 pm

#826406
RE: Numeric vss Bigint

Heh... I've gotta agree there... 2 billion is usually more than enough, never mind 4 billion... what is it that you're storing?
--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 9, 2008 at 9:31 am

#826168
RE: Nested Query-Sequential Dates Of Business Processes

Peso (6/9/2008)
I just clicked OP's "all post" to see if I didn't invent the wheel again.
If I hadn't, both you and me would present a working solution. What a waste...
--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 9, 2008 at 7:59 am

#826110
RE: Nested Query-Sequential Dates Of Business Processes

Peso (6/9/2008)
I see that now.
I responded to a PM and saw that OP posted same question on the forums.
Didn't notice the version.
Thanks for the feedback, Peter... Op seems happy with...
--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 9, 2008 at 7:39 am

#826091
RE: Nested Query-Sequential Dates Of Business Processes

Nicely done, Peter! I'm still kinda new to the 2005 world and I keep forgetting about stuff like that...
heh... especially on a 2k forum 😉
--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 9, 2008 at 6:59 am

#826069

Viewing 15 posts - 50,131 through 50,145 (of 59,099 total)