Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,891 through 43,905 (of 59,063 total)

RE: Rolling up hierarchical costs

Vaughan,
I noticed zero replies on your post... did you eventually get this or do you still need help?
--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)

May 3, 2009 at 6:55 pm

#987892
RE: Need help writing query

WayneS (4/30/2009)
patrick ryan (4/30/2009)
I need help writing a query. I attached an excel file with sample data.
Hi Patrick,
It really helps all of the volunteers that help out on 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)

May 3, 2009 at 6:18 pm

#987890
RE: Updating records through query

nahid.mansuri (4/30/2009)
I have a update query as below.
Update equipment
set name = 'A'
where name = 'B'
And in the Update trigger, i will try to update some other columns too.
Like Address,...
--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)

May 3, 2009 at 6:14 pm

#987888
RE: Read from Text file

steveb (5/1/2009)
I did something like this recently and tried a few approaches but eded up using LogParser, its a free tool from microsoft that reads log files and can output...
--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)

May 3, 2009 at 6:11 pm

#987887
RE: SQL 2005 Selecting data Into a #TempTable then query it

Warren Peace (5/1/2009)
That was it.
Thanks, I got it going!
Could you post the code that solved the problem, please? 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)

May 3, 2009 at 6:06 pm

#987885
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Samuel Vella (5/1/2009)
Cross Apply usually results in hidden RBAR so no real benefit over an efficient cursor based procedure
Heh... as you said, "usually". We've recently done some experiments on...
--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)

May 3, 2009 at 4:27 pm

#987873
RE: Are the posted questions getting worse?

Florian Reischl (5/3/2009)
Sorry for disturbing the silence of The Thread but I have to get this off my chest...
I HATE EXCEL!! I'm about to finish my first article and want...
--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)

May 3, 2009 at 2:19 pm

#987850
RE: DATABASE-PROBLEM

satishthota (5/3/2009)
I had A HRMS Database
Is it necessary to maintain the HRMS_MASTER,HRMS_TRANS,HRMS_HISTORY DATABASES
i.e., one HRMS DATABASE split into 3 databases(HRMS_MASTER,HRMS_TRANS,HRMS_HISTORY)
Give me the reason for why we have to maintain ...
--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)

May 3, 2009 at 2:14 pm

#987849
RE: Matrix multiplication without cursors?

Yep... that an the fact the I shouldn't go near the forum when I'm having a really bad day. I feel better now... went out a chopped down an...
--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)

May 3, 2009 at 1:57 pm

#987847
RE: BCP command using TSQL without xp_cmdshell

Heh... it's a requirement on their part to make up for short comings in security by many DBA's. Instead, I'd rather challenge them to use it in an unauthorized...
--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)

May 3, 2009 at 9:48 am

#987830
RE: Matrix multiplication without cursors?

Lynn Pettis (5/3/2009)
Jeff Moden (5/2/2009)
If there's another thread with more detailed information, why the hell are we trying to answer anything on this thread? We're just spitting resources here.;-)
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)

May 3, 2009 at 9:30 am

#987828
RE: The Next Frontier of Performance Troubleshooting

I think it very ironic that people continue to find better ways to find performance problems caused by poorly written code that should never have made it to the database...
--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)

May 3, 2009 at 9:24 am

#987827
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Thanks for the offers of help guys. I love this team.
I've got 2k Dev, 2k5 Dev, and I'll soon have 2k8 Dev. I may also be shifting primary...
--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)

May 3, 2009 at 9:09 am

#987825
RE: SQL Server SQL Is ANSII Standard or ASCII?

http://www.google.com/search?hl=en&q=ansi+92
http://www.google.com/search?hl=en&q=ascii&aq=f&oq=
😉
--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)

May 2, 2009 at 8:55 pm

#987786
RE: Matrix multiplication without cursors?

If there's another thread with more detailed information, why the hell are we trying to answer anything on this thread? We're just spitting resources here.;-)
--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)

May 2, 2009 at 8:47 pm

#987785

Viewing 15 posts - 43,891 through 43,905 (of 59,063 total)