Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,036 through 31,050 (of 59,101 total)

RE: Flat file

shah.simmy (2/20/2012)
hi
please help me with the solution for the following question:
These sound like "interview" questions and I don't normally answer such things. However, my answers for these types 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)

February 20, 2012 at 11:59 am

#1449355
RE: Putting JSON on an equal footing to XML

RobertYoung (2/19/2012)
I can no longer find a cite, but Fabian Pascal once made the obvious point: xml is not in any meaningful way "self describing", for if it were...
--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)

February 20, 2012 at 6:20 am

#1449215
RE: TSQL that lists all numbers from 1..100

ThomasGr (2/20/2012)
Try this one:
with t as (select 1 x
union all
...
--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)

February 20, 2012 at 6:12 am

#1449211
RE: SOPA and Censorship

Grant Fritchey (2/20/2012)
Jeez Jeff. Next time mark it URGENT or NEED HELP NOW. Then I'd be sure to ignore it.
By the way, as far as posting goes, I didn't set...
--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)

February 20, 2012 at 6:07 am

#1449207
RE: SOPA and Censorship

Cadavre (2/20/2012)
I'm surprised by the lack of responses, amongst those I socialise with away from work it has been a fairly major talking point.
Same here. Maybe folks on SSC...
--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)

February 20, 2012 at 5:58 am

#1449203
RE: TSQL that lists all numbers from 1..100

GPO (2/20/2012)
Who was the first person to come up with this (Jeff's) idea in the context of SQL Server? Was it Itzik Ben-Gan?
Yes, it was Ben-Gan. He used 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)

February 20, 2012 at 5:55 am

#1449201
RE: SOPA and Censorship

Thanks for the feeback and the participation, Tom. I've got a feeling that a whole lot of people just aren't interested.
--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)

February 19, 2012 at 11:19 pm

#1449077
RE: SOPA and Censorship

Gosh... I know it's Sunday (well, early Monday now by my watch) but with more than 24 views, I hope more than 4 people take the poll.
Thanks, folks.
--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)

February 19, 2012 at 10:31 pm

#1449066
RE: Dynamic update query

rajeev_vandakar-782919 (2/18/2012)
Hi,
There is a table with 30 to 40 columns and hardly few columns may get updated by the user. We can't say which column(s) may...
--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)

February 19, 2012 at 10:27 pm

#1449065
RE: Dynamic update query

Eugene Elutin (2/19/2012)
rajeev_vandakar-782919 (2/18/2012)
It's not totally possible, and anyway you would still better to write normal sql and update all 30-40 columns.
Not if you have triggers based on some 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)

February 19, 2012 at 10:16 pm

#1449064
RE: Without DateTime Column?

Charmer (1/24/2012)
herladygeekedness (1/24/2012)
Sounds like someone gave you lousy requirements!
In my opinion, if there is no column in which to check the criteria, you cannot use that criteria.
That said, not knowing...
--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)

February 19, 2012 at 10:10 pm

#1449063
RE: Varchar(max) performance problem in SQL server 2008 R2

e90fleet (2/19/2012)
Jeff, thanks so much for your reply. One thing i don't understand and if you can explain is your comment on
300,000 rows returned to clog the proverbial...
--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)

February 19, 2012 at 10:05 pm

#1449062
RE: Select the most recent record closest to primary record date,tricky

dwain.c (2/19/2012)
I believe this solution will also work
Unfortunately, it doesn't. (See the results below). That's why I always ask for test data which the OP very nicely provided...
--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)

February 19, 2012 at 9:47 pm

#1449060
RE: i need ideas

My recommendation would be to provide some test data for folks to work on so they might be better able to provide you with a coded answer. Please see...
--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)

February 19, 2012 at 12:13 pm

#1449004
RE: Are the posted questions getting worse?

bitbucket-25253 (2/18/2012)
When going to "Recent Posts", this shows up:
http://www.sqlservercentral.com/scripts/CROSS+JOIN/87362/
Note that it is a SCRIPT so why oh why is it appearing in "Recent Posts" - another foul up something 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)

February 19, 2012 at 12:07 pm

#1449003

Viewing 15 posts - 31,036 through 31,050 (of 59,101 total)