Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,371 through 32,385 (of 59,099 total)

RE: Best approach to import text file?

codebyo (10/3/2011)
Jeff Moden (10/3/2011)
The BCP format file would use similar delimiters and row terminators as you have in your BULK INSERT example (which is very nicely done, BTW). Perhaps...
--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 7, 2011 at 6:30 am

#1391664
RE: Where are all the MVBs?

IIRC, SQLServerCentral.com tried a Wiki when they switched forum software many years back. Basically, it was an "unmanaged" Wiki where anyone could make additions/changes/deletions.
My opinion about public "unmanaged" Wiki'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 7, 2011 at 6:18 am

#1391657
RE: SQL-Server 2005: Change Ordinal Column Position

paul.t.silvey (10/6/2011)
Yes, COLUMN ORDER DOES MATTER in some data layer tier applications. They look to the first column being the primary key and if an ID column was added at...
--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 7, 2011 at 6:03 am

#1391650
RE: Rookie DBA

codebyo (10/7/2011)
Jeff Moden (10/6/2011)
Ah... yeah... found it...
http://www.brentozar.com/sql/becoming-a-dba/
That's brilliant! Thank you.
Bookmarked. 🙂
Best regards,
You bet. Brent did a wonderful job and did a lot of work putting all of that together....
--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 7, 2011 at 5:55 am

#1391647
RE: Rookie DBA

Ah... yeah... found it...
http://www.brentozar.com/sql/becoming-a-dba/
--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 6, 2011 at 9:57 pm

#1391558
RE: Rookie DBA

codebyo (10/6/2011)
Jeff Moden (10/6/2011)Done correctly, the study programs for certs are an incredible path to knowledge... but certs aren't the only path available.
Indeed. You're absolutely right.
There's something I'd like 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)

October 6, 2011 at 9:55 pm

#1391557
RE: Rookie DBA

JamesMorrison (10/6/2011)
The ones with experince and no certifications typically are the types who get silo'd and limited to just the basics.
This leads to a lack in broad understanding of areas...
--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 6, 2011 at 6:56 pm

#1391540
RE: Are the posted questions getting worse?

SQL Kiwi (10/5/2011)
Evil Kraig F (10/5/2011)
Second Interview? Isn't that the time when they go "Sign here for benefits and salary agreements?" Didn't know that was an interview....
No idea....
--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 5, 2011 at 6:55 pm

#1391032
RE: Are the posted questions getting worse?

Stefan Krzywicki (10/5/2011)
Oh Jeff, look what your "simple" question has done!
I know... pretty devious, huh? 😛 The good ones just can't stand such a simple question. They'll...
--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 5, 2011 at 6:52 pm

#1391031
RE: Are the posted questions getting worse?

Chad Crawford (10/5/2011)
Stefan Krzywicki (10/5/2011)
Jeff Moden (10/5/2011)
Ninja's_RGR'us (10/5/2011)
Jeff Moden (10/4/2011)
GilaMonster (10/4/2011)
Jeff Moden (10/4/2011)
I wonder how many of us there are that try to completely ignore certs and degrees 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 5, 2011 at 9:18 am

#1390754
RE: Are the posted questions getting worse?

Ninja's_RGR'us (10/5/2011)
Jeff Moden (10/4/2011)
GilaMonster (10/4/2011)
Jeff Moden (10/4/2011)
I wonder how many of us there are that try to completely ignore certs and degrees in the interview process?
I don't. If the person...
--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 5, 2011 at 5:28 am

#1390596
RE: HierarchyID performance problems... Really???

ALZDBA (10/5/2011)
BTW you don't need million row objects to get into performance problems, so strive for most optimal setup as much as you can !
Heh... true enough. 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)

October 5, 2011 at 5:18 am

#1390590
RE: Are the posted questions getting worse?

GilaMonster (10/4/2011)
Jeff Moden (10/4/2011)
I wonder how many of us there are that try to completely ignore certs and degrees in the interview process?
I don't. If the person has a relevant...
--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 4, 2011 at 8:14 pm

#1390479
RE: Are the posted questions getting worse?

Fal (10/4/2011)
I had an interesting moment of reflection whilst helping my daughter with her homework the other day.
She had a maths problem like “102 + 44 + 266 + 78...
--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 4, 2011 at 7:52 pm

#1390476
RE: Are the posted questions getting worse?

skonagalla (10/4/2011)
I am very sorry that I believed was performing a useful service by reposting some excellent ideas from other bloggers, and I apologize for not attributing credit to 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)

October 4, 2011 at 4:13 pm

#1390441

Viewing 15 posts - 32,371 through 32,385 (of 59,099 total)