Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,206 through 38,220 (of 59,072 total)

RE: Passing many parameters to a stored procedure

If you pass XML, then you'll need to shred it just like if you pass delimited data that needs to be parsed. A lot of folks use XML for...
--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)

May 25, 2010 at 8:13 am

#1172094
RE: Calculation in group by query.

Pravin Patel-491467 (5/25/2010)
Friends,
Thanks a lot for all your help and giving your precious time behind this stuff.
I am posting one more stuff related this stuff in same forums TSQL(SS2K5). 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)

May 25, 2010 at 7:44 am

#1172070
RE: Parsing millions of records without index

By the way, I have to ask... the code you posted in your original post has so many errors in it that it would never have come close to working....
--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)

May 25, 2010 at 7:39 am

#1172063
RE: Parsing millions of records without index

So let's ask the question, then... does the underlying table in the view have the cc, yy, mm, dd columns or does it have a viable DATE or DATETIME column,...
--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)

May 25, 2010 at 7:25 am

#1172049
RE: Parsing millions of records without index

rajiv.varma (5/24/2010)
I have 4 columns CC, YY, MM, DD and they have records like
'20', '10', '5', '23'
This is why we need the CREATE TABLE statement (along with the related indexes,...
--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)

May 24, 2010 at 10:32 pm

#1171837
RE: How do I count the occurrences of a sequence of records

Thanks for the feedback and the code. 🙂
--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)

May 24, 2010 at 5:25 pm

#1171815
RE: Dataimport from csv-file

varkstad (5/24/2010)
For now I solved this unicode problem when I changed
42" Plasma TV to 42tum Plasma TV
but I still don´t get the swedish characters å,ä,ö, correct in the databasetable.
Gunilla
What 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)

May 24, 2010 at 7:33 am

#1171550
RE: Dataimport from csv-file

varkstad (5/24/2010)
Thank you for the answer.
lmu92 (5/24/2010)
You should add the following two options to import unicode data:
CODEPAGE = 'RAW'
DATAFILETYPE = 'widechar'
That should help you to import your...
--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)

May 24, 2010 at 7:21 am

#1171539
RE: Updating 20M rows takes 5 hours

ss-457805 (5/24/2010)
Please forgive my ignorance.I am not sure what u mean by "Real" Execution plan.
Nope... please forgive my ignorance. I thought you had done something else because of 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)

May 24, 2010 at 7:11 am

#1171533
RE: Updating 20M rows takes 5 hours

Stefan_G (5/24/2010)
Jeff Moden (5/23/2010)
I thought I'd "bump" this one for the OP since he provided everything requested but hasn't gotten a reply yet. 🙂
Give me a break. 😉
Dont you have...
--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)

May 24, 2010 at 7:05 am

#1171530
RE: Calculation in group by query.

@Privan,
Thanks for the nice data setup. I'd jump right in on the code except I'm at work and won't be able to work on this until later tonight. ...
--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)

May 24, 2010 at 6:56 am

#1171521
RE: DBA, phantom job title?

Heh... in fact, here's one now...
http://www.sqlservercentral.com/Forums/Topic926398-360-1.aspx
... and such a thing is far from atypical.
--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)

May 24, 2010 at 6:51 am

#1171518
RE: Writing Portable SQL

I'm with Grant on this one but I'll go even further. My feeling is that truly portable code is a myth... so why bother? Further, in order to...
--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)

May 24, 2010 at 6:45 am

#1171512
RE: DBA, phantom job title?

Heh... didn't you know? SQL Server is just a place to store data and T-SQL is so easy that you don't actually need a "pro" at it. :-P;-):-D:w00t::-):hehe:
I agree...
--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)

May 24, 2010 at 6:37 am

#1171509
RE: How to create a flat herarchy from a table containing parent and child relationship

@ritesh-2
I'll try to get to this tonight after work. You post has gone 17 hours with no coded answer. Please read the article at the first link 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)

May 24, 2010 at 6:19 am

#1171498

Viewing 15 posts - 38,206 through 38,220 (of 59,072 total)