Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,476 through 32,490 (of 59,099 total)

RE: Performance issue with tally solution

Now THAT's funny! 🙂
--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)

September 25, 2011 at 8:47 am

#1386213
RE: Query optimizing 2

J Livingston SQL (9/25/2011)
First off....I agree with Jeff's test results having run on both 2005 std and 2008R2 dev.
personally, I really dont like hardcoding pivot columns, and more often than...
--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)

September 25, 2011 at 8:46 am

#1386212
RE: cross tab query

kshatriya24 (9/19/2011)
for example, if i run report tuesday it will give me only informationon for sunday and monday.
So... if you run the report on Thursday, are you expecting information...
--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)

September 24, 2011 at 11:42 pm

#1386169
RE: MVP Branding

I have no idea on question b) but on question a), yes... even though it probably shouldn't mean a thing, MVPs are frequently regarded simply for being MVPs. Part...
--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)

September 24, 2011 at 11:34 pm

#1386168
RE: how to send rows to columns data in ssis

asranantha (9/19/2011)
hi friends,
source data comes like id,name,location
...
--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)

September 24, 2011 at 10:46 pm

#1386166
RE: pass table name as a parameter in stored procedure

mjbkm (9/24/2011)
Hello. This post was a huge help for me. I am able to get it to work in a stored procedure. Is it possible in 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)

September 24, 2011 at 10:43 pm

#1386165
RE: Question variable substritution

Oracle_91 (9/24/2011)
Yes. you are right. I wanted to know reason for it.
The only reason I can think of is "that's the way they built 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)

September 24, 2011 at 10:41 pm

#1386164
RE: A time-out occurred while waiting for buffer latch

balasach82 (9/24/2011)
Provided clarifications below:
1. We placed the tempdb.mdf and ldf files in a separate drive.
2. dbcc dbreindex(XXXXXX,'',90) with no_infomsgs
dbcc dbreindex('XXXXXX') with no_infomsgs
Version: 2005 with...
--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)

September 24, 2011 at 9:28 pm

#1386163
RE: Performance issue with tally solution

Just in case anyone is still following this thread and may have missed the article... the performance problem wasn't with the Tally Table itself. It was with the concatenation...
--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)

September 24, 2011 at 8:52 pm

#1386162
RE: Many DeadLocks

It was a while back so I don't remember any specific details like the name of the proc or anything like that. I do remember the problem though. ...
--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)

September 24, 2011 at 7:15 pm

#1386155
RE: An alternative to GUIDs

nick 2435 (9/20/2011)
Interesting. What are you using to prevent the spelling out of random swear words?
Not thought of that one - but no one has ever reported any! There's...
--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)

September 24, 2011 at 6:49 pm

#1386153
RE: UPDATE without listing all columns?

Apparently the OP has left the building. 😉
--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)

September 24, 2011 at 6:30 pm

#1386149
RE: Nested While loop

Thanks for the great explanation and, I agree... the control loop for this would not be a performance problem. As a sidebar, man, I'd love to take a crack...
--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)

September 24, 2011 at 6:28 pm

#1386147
RE: SQL 2008 - T-SQL query assistance

R.P.Rozema (9/23/2011)
Hi Jeff, did you find some time to work on some examples for us on nested sets?
It would appear that Mr. Celko has some examples at the ready and...
--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)

September 24, 2011 at 5:52 pm

#1386144
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Thanks, Marilu. Those are a pair of awesome compliments. "Miss Liberty" is one of my favorite "people" and it was my pleasure to serve.
Heh... having a bit...
--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)

September 24, 2011 at 4:36 pm

#1386142

Viewing 15 posts - 32,476 through 32,490 (of 59,099 total)