Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,296 through 41,310 (of 59,069 total)

RE: ssis and ssrs interview questions

malli.chitturi (11/2/2009)
Its not about memorizing the Q&A. Its about SQL is easy to Learn but hard to master. So Its just helping what part of SQL they have to concentrate...
--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)

November 3, 2009 at 12:58 am

#1074139
RE: ssis and ssrs interview questions

pleasehelpme (11/2/2009)
gilamonster,
it's not your business how people like to answer the questions in the interview. Stop whining ok, you are annoying.
Heh... nah... what's realy annoying is people in interviews who...
--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)

November 2, 2009 at 3:07 pm

#1074029
RE: query to modify

Not to worry.... it happens. 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)

November 2, 2009 at 3:01 pm

#1074023
RE: Query to find the row size in a user table

DBA-640728 (10/29/2009)
hi, would that be the column Average Record Size? in
DBCC SHOWCONTIG WITH TABLERESULTS
I need to find the average size of a columm in my table to be able...
--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)

October 30, 2009 at 11:26 pm

#1073472
RE: query to modify

Heh... now I've really learned my lesson. The op has visited the forum several times since I've posted the code and not so much a simple "Thank 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)

October 30, 2009 at 11:19 pm

#1073471
RE: Sending multiple rows to the Database from an Application: Part II

It would be interesting to do a large performance test and find out if "performance" using this method belongs in the "Pro" or "Con" column.
I also concern myself with such...
--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)

October 30, 2009 at 11:12 pm

#1073469
RE: splitting long sentence into multiple lines

mister boom (10/26/2009)
I know it's RBAR, but this also works for me, and may be easier for newbies to follow:
Thanks for the feedback, Alun, but that's exactly what I'm worried...
--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)

October 30, 2009 at 10:38 pm

#1073468
RE: splitting long sentence into multiple lines

T.S.
Alun was correct... I forgot to count the trailing space after each word. By changing LEN to DATALENGTH in my previous code, the answer is correctly resolved. Here'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)

October 30, 2009 at 10:35 pm

#1073467
RE: The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

GSquared (10/29/2009)
Also, the number of servers per DBA will vary depending on what they are used for. A server that is purely overnight ETL and reporting is much easier...
--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)

October 30, 2009 at 10:18 pm

#1073465
RE: TSQL Question about getting data

Apologies, Brad... the new job is keeping me pretty busy... so is the hour commute each way.
Are you all set with this or do you still need some help in...
--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)

October 30, 2009 at 10:03 pm

#1073464
RE: Would you be concerned??

Heh... damn... another pork chop opportunity lost. 😉
I'm glad about this for a couple of reasons... you don't have to get involved anymore (I'm sure you're relieved, as well) 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)

October 30, 2009 at 9:52 pm

#1073462
RE: Money vs. Decimal Data type

You bet. Thanks for the feedback.
Just to be clear and as Matt a couple of others alluded to, it's all a matter of precision and scale. Money is...
--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)

October 30, 2009 at 9:45 pm

#1073461
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/29/2009)
Woot - get to read another article by Jeff.
Are there any pork chops in it?
Actually... there are. I think you'll enjoy some of the dry humor especially if...
--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)

October 30, 2009 at 9:09 pm

#1073458
RE: Are the posted questions getting worse?

Silverfox (10/29/2009)
Looking at the chapter descriptions, Dont see Jeff down there. or am I missing something?
Nope... I've just been so busy I don't have the time it takes to write...
--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)

October 29, 2009 at 8:34 pm

#1072930
RE: Are the posted questions getting worse?

Lynn Pettis (10/29/2009)
What is it with some people? I have seen sevarl threads where people are addressing others on their SSC Title instead of their forum name. like GSquared.
Same...
--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)

October 29, 2009 at 8:16 pm

#1072926

Viewing 15 posts - 41,296 through 41,310 (of 59,069 total)