Jeff Moden

Forum Replies Created

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

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

RBarryYoung (1/24/2009)
Heh. You know, I always have to follow these links to make sure that you aren't talking about me. Thank goodness too, I prefer my pork chops...
--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:34 pm

#932296
RE: Are the posted questions getting worse?

Brian, that's absolutely awesome. I couldn't have said it better myself. Thank you. And thanks for putting up with me on that post "a while back". ...
--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:30 pm

#932295
RE: Are the posted questions getting worse?

Michael Earl (1/24/2009)
I am a big believer in "Le mieux est l'ennemi du bien" - for many one-time, small-record count operations I often use RBAR solutions just to get things...
--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 1:59 pm

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

seekwell_fan (1/24/2009)
Hi, guys!
Thank you all for your advises. I appreciated all of them
I can't answer to each of you, so I would like to answer only for some common ideas.
First,...
--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 1:22 pm

#932279
RE: Temp db get big in sudden from 200 mb to 9 gb why

200 MB is too small for a TempDB, anyway. Shoot... I START my servers with a 9GB TempDB.
There are several things that can cause TempDB to get so large......
--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 1:09 pm

#932276
RE: [newbie]

Jon (1/22/2009)
Thanks. As a matter of fact I had to re-create the table from scratch. Any idea if this feature is available in Server 2008?
You're not listening.... several...
--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 1:04 pm

#932274

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