Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,126 through 37,140 (of 59,098 total)

RE: Are the posted questions getting worse?

Silverfox (8/25/2010)
Didnt realise your a MVP Jeff, Congrats...;-)
Thanks for the congrats. This is actually my 3rd year as an MVP. Like I said, I don't play it up...
--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)

August 25, 2010 at 9:26 pm

#1212034
RE: The DBA Financial Analyst

the cloud might be more trouble than it's worth
'Nuff Said! 😉 Next problem 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)

August 24, 2010 at 9:17 pm

#1211420
RE: Need help understanding performance issue

This should take seconds, not minutes. Any chance of you posting what the dynamic SQL renders out to during run time?
--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)

August 24, 2010 at 8:55 pm

#1211415
RE: XML Query for Hiearchy

Grant Fritchey (8/24/2010)
I need the XML query within Reporting Services, not a regular XML XQuery, the one that is part of defining a data set.
Sorry to bug you with 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)

August 24, 2010 at 8:12 pm

#1211411
RE: Normalize a table query

jayraj0071 (8/24/2010)
somebody provide sample data of table!!!
Heh... Why? OP is happy with the answer to lookup UNPIVOT. 😉
--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)

August 24, 2010 at 7:49 pm

#1211409
RE: Are the posted questions getting worse?

Grant Fritchey (8/24/2010)
This won't be a popular answer, but, you're an MVP. You have access to a full license. You just have to register and turn it on.
It's a 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)

August 24, 2010 at 7:46 pm

#1211408
RE: XP_cmdshell DIR

chrs-513176 (8/24/2010)
Yeah, I did try that but to no avail. I'll work on it a little more and let you know if I find a solution.
Heh... no need... there's more...
--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)

August 24, 2010 at 7:24 pm

#1211404
RE: Today's Random Word!

Ray K (8/24/2010)
Jeff Moden (8/23/2010)
dbowlin (8/23/2010)
Ray K (8/23/2010)
Brandie Tarvin (8/23/2010)
flood
"Noah . . . I want you to build an ark . . . "
Lord...What's an ark? (From 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)

August 24, 2010 at 7:10 pm

#1211401
RE: The Semantics of NULL in SQL Server 2008

Heh... nah... 5 pages about the philosophy of NULL instead. So much for not hijacking this thread.
--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)

August 24, 2010 at 7:07 pm

#1211399
RE: ssis and ssrs interview questions

Alvin Ramard (8/24/2010)
GilaMonster (8/24/2010)
Alvin Ramard (8/24/2010)
Don't you use a triangular join to join 3 tables? 😛
That means you'll need a CROSS JOIN for 4 tables. :hehe:
Yep.
I'm clueless about what...
--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)

August 24, 2010 at 6:58 pm

#1211397
RE: ssis and ssrs interview questions

Alvin Ramard (8/24/2010)
GilaMonster (8/24/2010)
It'll have to be a HASH join, it's advertised as the one that handles large numbers.
I guess that 6 tables would be one hex of a join....
--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)

August 24, 2010 at 6:54 pm

#1211396
RE: Plzz help me in replacing the cursor with Normal Sql Statements

inampudianil (8/24/2010)
Hey Wayne,
Any update on this..plzz help me out..:-)
I'd help but I just don't have the time to fix your data and table so they work together. If you...
--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)

August 24, 2010 at 6:49 pm

#1211395
RE: Plzz help me in replacing the cursor with Normal Sql Statements

WayneS (8/10/2010)
See how this works for you.
-- since you already have a clustered index, we need to dump the table to a temp table
-- where we can build the clustered...
--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)

August 24, 2010 at 6:41 pm

#1211394
RE: Plzz help me in replacing the cursor with Normal Sql Statements

Mike01 (8/13/2010)
How about using a CTE?
Mike... 2k forum. 🙂
--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)

August 24, 2010 at 6:40 pm

#1211393
RE: Performance tuning

TheSQLGuru (8/24/2010)
1) You should do it when it needs to be done. many variables to that answer.
And, remember, if you do it while you're writing code by following best...
--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)

August 24, 2010 at 6:34 pm

#1211391

Viewing 15 posts - 37,126 through 37,140 (of 59,098 total)