Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,236 through 38,250 (of 59,098 total)

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
RE: Search for duplicate entries

luckysql.kinda (5/24/2010)
select distinct * from dupnames dup1
inner join dupnames dup2
on dup1.name = dup2.name
where dup1.id <> dup2. id
That's nice but it doesn't meet the OPs request. You need to check...
--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:14 am

#1171493
RE: A Smarter Planet

I like the idea of smarter software around that can help me. I just am not sure that we are building it in a way that respects us as individuals.
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)

May 23, 2010 at 10:28 pm

#1171369
RE: SET CONCAT_NULL_YIELDS_NULL

hugh.hemington (5/23/2010)
Actually, setting the null concat off was an obsolete fix for me anyway because I have since sanitized my data to eliminate nulls. There is no way on...
--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 23, 2010 at 10:16 pm

#1171367
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Thank you for the incredible feedback, Pac123. It looks like you've certainly hit all the high points. 🙂
--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 23, 2010 at 9:42 pm

#1171365

Viewing 15 posts - 38,236 through 38,250 (of 59,098 total)