Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,571 through 45,585 (of 59,101 total)

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
RE: Are the posted questions getting worse?

I'm not sure its "bad" advice in that lots of folks do get this information from the internet but never test it. Shoot, I'm in the process of fixing...
--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:07 am

#932366
RE: SHOWPLAN permission denied in database 'tempdb'

I'm pretty sure you need at least DBO privs to do a SHOWPLAN.
--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 24, 2009 at 7:41 pm

#932314
RE: Group By with 2 parameters and datetime and add next dateTime.

I believe that the reason you're not getting any bites on this problem is that most people don't want to work so hard trying to test your data. Please...
--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 24, 2009 at 7:10 pm

#932306
RE: The better server

Gosh... there's a thousand reasons. Here's some of the biggest reasons for me...
Server Audits
Database Audits
Performance Data Collection
Resource Governor Improvements
SQL Server Change Tracking (above and beyond Database Audits)
PARTITION TABLE Parallelism
Data...
--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 24, 2009 at 6:51 pm

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

RBarryYoung (1/24/2009)
Just to clarify my earlier response to Hemin's question: I was assuming that he was asking about using SELECT pseudocursors to do this. There are of course lots...
--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 24, 2009 at 6:25 pm

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

There are no guarantees that what you're doing will stay small and there are no guarantees that someone won't look at that RBAR code and decide it's ok for them...
--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 24, 2009 at 6:11 pm

#932303
RE: DBA job without experience? Is it possible?

george sibbald (1/24/2009)
so go to the interviews and tell them the above but be prepared to back it up. But be careful about going in there saying you are as...
--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 24, 2009 at 6:03 pm

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

bjesmith2 (1/23/2009)
Hi,
I'm new to t-sql and I do not know much regarding how to write efficient queries.
I read an article which referred to RBAR and set based programming (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 24, 2009 at 5:54 pm

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

Sankar Reddy (1/24/2009)
Jeff, point taken. I will avoid that next time. I was just demonstrating a technique.
Heh... understood and thanks. I was picking on you a bit I don't...
--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 24, 2009 at 5:45 pm

#932298

Viewing 15 posts - 45,571 through 45,585 (of 59,101 total)