Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,556 through 45,570 (of 59,095 total)

RE: Slack SQL Server

Steve Jones - Editor (1/26/2009)
majorbloodnock, well said. SQL Server does work extremely well for the basics of what we need and it's definitely one of the most stable pieces of...
--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 26, 2009 at 11:25 am

#932742
RE: SQL or Oracle

Luke L (1/25/2009)
Unfortunately, the reason why some very large companies end up dong this is that someone comes along and says he we need to represent x data y way......
--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 26, 2009 at 11:21 am

#932738
RE: Limiting users to views only in database

Grant Fritchey (1/26/2009)
Risking a pork chop, I'm going to disagree with Jeff on this.
You should look at option 1, but as was mentioned before, create a schema for the views....
--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 26, 2009 at 11:15 am

#932729
RE: The Set-Based Limit

Heh... if it's not in the "SQL Dictionary", I usually don't get it, either. I learned one just recently that very well describes some of the source of "flames"...
--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 26, 2009 at 11:02 am

#932723
RE: Are the posted answers getting worse?

GilaMonster (1/25/2009)
Jeff Moden (1/25/2009)
The ironic part about all of this is that very example actually strengthens the argument that the quirky update does always work as advertised. I'm going...
--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 26, 2009 at 10:54 am

#932719
RE: How to replace a cell value with a cell value in previous row

Sorry folks... I got busy on other stuff. I'll take a look and see if I can answer some of the questions folks directed at me, tonight.
--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 26, 2009 at 10:49 am

#932716
RE: Hidden RBAR: Triangular Joins

My absolute favorite standard is "MIL-TP-41".... "Make It Like The Print for once". 😛
--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 26, 2009 at 10:44 am

#932713
RE: What is RBAR? How can I avoid it?

Thanks for the feedback. And, as you can see, avoiding RBAR is quite a hot topic with most of the power 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 26, 2009 at 10:10 am

#932693
RE: Are the posted questions getting worse?

GSquared (1/26/2009)
Jeff, something I have to ask:
You keep mentioning that recursive CTEs are worse than cursors. I can see that in some cases, but in cases like a hierarchy...
--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 26, 2009 at 9:49 am

#932679
RE: Replace Command

Just convert to INT and you're done...
--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 26, 2009 at 9:44 am

#932674
RE: DBAs and the art of persuasion

anil.mahadev2009 (1/24/2009)
Hi Jeff,
I used a tool called SQLDOC 🙂 from Red-Gate.
Cheers!
Anil
Cool... 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)

January 25, 2009 at 9:11 am

#932375
RE: Temp Tables vs. Physical Tables

Thanks for the links, Johan... I'll take a look (am I spelling your name correctly?)
--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 25, 2009 at 9:09 am

#932374
RE: [newbie]

Whew! Thanks for the feedback, Jon... thought you were falling on a sword and didn't want to see that happen. 🙂
--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 25, 2009 at 9:07 am

#932373
RE: How to delimit ‘-’ string?

jan michael woo cerna (1/25/2009)
hi jeff, thanks for the adviced. I'm working on a large data for a particular client. Are there any other options w/o using 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 25, 2009 at 9:04 am

#932372
RE: Are the posted answers getting worse?

Guess I'll be the one to break the "real" ice on this thread...
It's not an answer on a thread that I really messed up on... no... it's much worse. ...
--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 25, 2009 at 8:43 am

#932368

Viewing 15 posts - 45,556 through 45,570 (of 59,095 total)