Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,411 through 31,425 (of 59,101 total)

RE: Are the posted questions getting worse?

GilaMonster (1/14/2012)
I've seen Transcender sample tests before, they're miles from the real exams.
Then, totally switching gears, are such sample tests actually helping to learn those things necessary to pass the...
--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)

January 15, 2012 at 6:56 pm

#1433871
RE: Are the posted questions getting worse?

GilaMonster (1/14/2012)
Jeff Moden (1/13/2012)
It would appear that MS finding out about someone using such a site and revoking their cert because of it has been and certainly is nothing but...
--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)

January 15, 2012 at 6:52 pm

#1433870
RE: Are the posted questions getting worse?

Sean Lange (1/13/2012)
Jeff Moden (1/13/2012)
Sean Lange (1/13/2012)
I have to say this whole situation has left me feeling extremely reluctant to post on just about anything for fear that I come...
--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)

January 13, 2012 at 10:42 pm

#1433644
RE: Are the posted questions getting worse?

Sean Lange (1/13/2012)
I have to say this whole situation has left me feeling extremely reluctant to post on just about anything for fear that I come across as "one of...
--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)

January 13, 2012 at 10:15 pm

#1433639
RE: Are the posted questions getting worse?

Shifting gears a bit...
I've always felt that using Transcender and other "practice tests" just wasn't the right thing to do. It seems to me that using such services 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)

January 13, 2012 at 10:08 pm

#1433637
RE: Are the posted questions getting worse?

MysteryJimbo (1/13/2012)
Steve Jones - SSC Editor (1/13/2012)
SQL Kiwi (1/13/2012)
What's the general feeling about asking Steve to remove that "Question for the Experts" thread? +1 vote here.
Arguments are welcome, but...
--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)

January 13, 2012 at 9:58 pm

#1433633
RE: Returning a column per date in a range

SQL Kiwi (1/12/2012)
Jeff Moden (1/12/2012)
My apollogies... I assumed the same thing becuase of the statement "150ms is not 'significant' in the current context,"
Ok, now you've got me curious again. ...
--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)

January 13, 2012 at 9:37 pm

#1433632
RE: Returning a column per date in a range

SQL Kiwi (1/13/2012)
LutzM (1/13/2012)
The main reason some of us go beyond a "it works in the context" solution is because there are people out there who -unlike your great attitude-...
--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)

January 13, 2012 at 9:29 pm

#1433630
RE: How to insert multiple rows into a table with identity column

CELKO (1/5/2012)
This is only one reason why good SQL programmers never use this proprietary non-relational "feature" in their code.
Back to foundation. SQL is a set-oriented language. When you 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)

January 13, 2012 at 9:22 pm

#1433629
RE: Creating million row test tables?

aurato (1/12/2012)
I needed one column to be a space-separated string, so for that I used REPLACE(CAST(NewID() as Nvarchar(255)), '-', ' ') and it seems like this will work great...
--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)

January 13, 2012 at 9:06 pm

#1433626
RE: Are the posted questions getting worse?

ChrisM@home (1/12/2012)
GSquared (1/12/2012)
Brandie Tarvin (1/12/2012)
GilaMonster (1/12/2012)
Bex (1/12/2012)
From someone who is a lurker on this site, I take the attitude that if I ask for free help and I don't like...
--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)

January 12, 2012 at 9:55 am

#1432721
RE: Returning a column per date in a range

ChrisM@home (1/12/2012)
SQL Kiwi (1/12/2012)
Jeff and Chris,
You've missed the point I was making, and have chosen to assume that I am either (a) not aware of the performance issues involved; or...
--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)

January 12, 2012 at 9:28 am

#1432674
RE: Dynamically create and populate staging tables from CSV files

patrickmcginnis59 (1/10/2012)
Jeff Moden (1/10/2012)
Of course, you could also pre-process tables before they come anywhere near SQL Server but I've found that writing such code is a bit of a fright...
--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)

January 12, 2012 at 9:25 am

#1432663
RE: Dynamically create and populate staging tables from CSV files

surreydude. (1/11/2012)
Jeff Moden (1/10/2012)
Stan,
Nice step-by-step article with some timely graphics to show how to do things. Although it wasn't specifically named as such, I believe that folks will come...
--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)

January 12, 2012 at 9:21 am

#1432656
RE: Returning a column per date in a range

SQL Kiwi (1/11/2012)
It's pretty tough to imagine a list of dates long enough to make any practical difference regarding performance here. Before anyone says it, yes I know that...
--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)

January 12, 2012 at 6:25 am

#1432417

Viewing 15 posts - 31,411 through 31,425 (of 59,101 total)