Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,096 through 37,110 (of 59,072 total)

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

inampudianil (8/25/2010)
Hey Jeff,
Thanks for your help and time dude
I realize that there's a bit of a language barrier and that a lot of foreigners think the we like to be...
--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 10:34 pm

#1212052
RE: The Logic, Mathematics, and Utility of NULLs

Tom.Thomson (8/25/2010)
Steve Jones - Editor (8/25/2010)
I do agree that a qualifier of some sort, different for each domain, may be what is needed. In practicality, the issue is how do...
--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 10:21 pm

#1212048
RE: Are the posted questions getting worse?

Roy Ernest (8/25/2010)
@jeff. I never set up the netmeeting. I am going to see how that can be done.
When you figure it out, send me an email and then let'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)

August 25, 2010 at 9:58 pm

#1212040
RE: Creating new Database for a large Enterprise

djdhere (8/25/2010)
Hello All,
I need some help with creation of DB for a Bank ERP software
(Its having near about 300 branches )
Main Bank -> Their branches.
My queries are that -How we...
--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:50 pm

#1212037
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

Viewing 15 posts - 37,096 through 37,110 (of 59,072 total)