Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,441 through 49,455 (of 59,091 total)

RE: To Certify or Not To Certify

Heh... Ok... I'll summarize my position on Certifications and Degrees...
Everyone my bosses hired had great Certifications and Degrees on their resumes and they were hired for that reason... most...
--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)

July 4, 2008 at 9:05 pm

#838457
RE: Using 'Where' with 'LIKE' 'AND' 'OR' with NULL values mixed in.

tybee (7/3/2008)
I'm still a novice at SQL and I'm stuck trying to set up a search on a table that could have four 'AND' and two 'OR' searches, 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)

July 4, 2008 at 6:53 pm

#838454
RE: Spliting a string

Depending on the need, the following is about twice as fast... but it'll take a million rows to notice so let's just say it's very readable... 😀
DECLARE @InputString VARCHAR(8000)
...
--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)

July 4, 2008 at 6:42 pm

#838453
RE: Handling hirarchy in tables

Heh... must be catchy... "Now, how did THAT happen?"... heh... I'm not even wearing a helmet! 😉
Thanks for the catch, Barry. 🙂
--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)

July 4, 2008 at 5:34 pm

#838450
RE: Bulk Insert and Index Considerations

BCP uses the log only if you've not met the requirements for "minimal logging". Otherwise, it will minimally log... just like BULK INSERT which is actually faster than BCP.
Please...
--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)

July 4, 2008 at 10:30 am

#838399
RE: Handling hirarchy in tables

Ok... now, I'm impressed! I've not reviewed all of the code in the good article recommended by Rashmi, yet... but the author (James Simpson) has done a strange and...
--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)

July 4, 2008 at 10:13 am

#838396
RE: Handling hirarchy in tables

rashmi.todkar (7/4/2008)
by the way this is also a very good link for nested sets
http://www.codeproject.com/KB/database/nestedsets.aspx
That is a good article... graphics for the explanations are spot on and done well.
Heh......
--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)

July 4, 2008 at 10:03 am

#838393
RE: Handling hirarchy in tables

rashmi.todkar (7/4/2008)
Thanks all.
I gone through nested sets options its really best one for high performance reads on such data. but update and insert is bit costly however I can afford...
--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)

July 4, 2008 at 9:54 am

#838391
RE: CLR Assemblies

Greatings Mr. Burrows! Say... are you going to make the trek to Pass this fall? If you are, look for the guy wearing my avatar on the back...
--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)

July 4, 2008 at 9:50 am

#838390
RE: Output to csv

Shodman (7/2/2008)
Hi Folks
I am trying to do a simple query and output to a csv file.
SELECT *
FROM mytable
OUTPUT TO c:\mycsvfile.csv
Could somebody please advise why this isn't working.
I've read through loads...
--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)

July 4, 2008 at 12:27 am

#838225
RE: eliminating duplicates

Just so you know... I've had it take as long a 6 weeks from the submital date to have an article published and as little as 1 week. It...
--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)

July 4, 2008 at 12:14 am

#838221
RE: Table of Numbers (Tally Table)

Apparently, my Windows Live account signup hasn't made it this far, yet. Needless to say, I have some pretty strong feelings in the area of Tally tables... 😉
... I'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)

July 3, 2008 at 11:35 pm

#838210
RE: Dynamic USE clause

Sidebar: Yeah, I agree... this is one of the few and only places where I suppose it's ok to use a cursor... you just won't see me doing it!...
--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)

July 3, 2008 at 11:01 pm

#838208
RE: Dynamic USE clause

David Kranes (7/3/2008)
Yes you are correct. But this works fine.
DECLARE
@DBName VARCHAR(100),
@sql NVARCHAR(4000),
SELECT @sql = N'use...
--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)

July 3, 2008 at 10:57 pm

#838207
RE: Parse Text Variable in UDF

Heh... It's the helmet, Barry... ya gotta remember to plug in the O₂ 😛 Can't do it all on just coffee, ya know? :w00t:
--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)

July 3, 2008 at 10:34 pm

#838205

Viewing 15 posts - 49,441 through 49,455 (of 59,091 total)