Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,966 through 52,980 (of 59,098 total)

RE: Read only Rights with Create View - Help

Thanks for the feedback on what you did.
Heh... I sometimes forget just how lucky I am... we "clone" the database everynight at midnight to a "do what you want, users"...
--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)

January 12, 2008 at 10:33 pm

#767470
RE: When first starting a new job, how do you catch up to speed with DB's and Applications

Now, that's a pretty good idea. Thanks, Steve.
--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)

January 12, 2008 at 10:24 pm

#767469
RE: The Weekly Editorial

I agree that they shouldn't be abuse or cursed at... heh... just quietly fired 😀
--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)

January 12, 2008 at 9:40 pm

#767456
RE: SQL6.5,7,2000 and 2005

Karthik,
You, of all people, should know better... get onto the Microsoft web site and look for "What's new in" each of the different versions. Do some of your own...
--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)

January 12, 2008 at 9:27 pm

#767452
RE: The Weekly Editorial

they take pride in what they do, and they don't want to hear they've built a POS when they're doing their best
I've gotta disagree with you there, ol' friend. ...
--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)

January 12, 2008 at 9:21 pm

#767451
RE: Add incremental count to group of rows

And, I gotta disagree... this isn't a triangular join... internally generated rows to not form the classic triangle. No table has more rows spawned than either of the original...
--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)

January 12, 2008 at 9:03 pm

#767450
RE: Add incremental count to group of rows

I was just busting your chops earlier - you know that right?
Oh yeah... just got me thinking...
--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)

January 12, 2008 at 8:59 pm

#767449
RE: Performance of Scripts in SQL Server 2000

Ok... you certainly shouldn't post that data... it contains private information and understood about the source code.
Here's the real key... you're using an application to insert 2.2 million rows, one...
--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)

January 12, 2008 at 3:51 pm

#767440
RE: Add incremental count to group of rows

On second thought, it's not a triangular join... for a count of 3, a triangular join would generate...
1
1 2
1 2 3
... to get the count... 6 rows total. This...
--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)

January 12, 2008 at 12:57 pm

#767437
RE: Add incremental count to group of rows

Heh... yeah... it is... 😛
Difference is that all rows it touches are generated in the output... nothing wasted. Like I said in the article, they're not all bad...
... I...
--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)

January 12, 2008 at 12:49 pm

#767434
RE: counting value in a field and outputing a table

Heh... what happened to 150 questions?
The real problem with the way you wanted to do it is that if most of your questionaires only have 50 questions and you have...
--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)

January 12, 2008 at 12:33 pm

#767431
RE: Performance of Scripts in SQL Server 2000

It sounds like you're getting data from a file, cleaning it up, and then inserting it into a database... For 2.2 million rows, this shouldn't take more than a minute...
--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)

January 12, 2008 at 12:02 pm

#767428
RE: counting value in a field and outputing a table

Heck yeah there would be performance issues... performance would increase because you could properly index it 😀
--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)

January 12, 2008 at 11:08 am

#767426
RE: Add incremental count to group of rows

simon.letts (1/9/2008)
Thanks for that effort, it looks very complicated for what I want though.
To make it easier ...lets say that I just have a table with just one column, trans_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)

January 12, 2008 at 10:30 am

#767422
RE: plz help me outttttttttt

You would get a lot of help if you'd at least identify what it is what you want to do... 😉
But I understand... sometimes you're in a bit of 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)

January 12, 2008 at 9:44 am

#767419

Viewing 15 posts - 52,966 through 52,980 (of 59,098 total)