Jeff Moden

Forum Replies Created

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

RE: Spliting a string

Talib Khan (7/5/2008)
Hey.. Thanks everyone for your valuable suggestions as i have already solved my problem. But...
--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 5, 2008 at 9:09 am

#838505
RE: ANSI_NULLS and Performance

In the meantime, why don't you just go ahead and tell us what the solution 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)

July 4, 2008 at 10:13 pm

#838466
RE: Raima Database Data Import

I don't believe there's anything in SQL Server that will import such a thing... does it have any export capabilities, say, to a CSV or fixed field text file?
--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:08 pm

#838465
RE: Trigger Not Firing

The trigger fires just fine... the UPDATE is the problem... or rather the data, data order, and criteria for the update is the problem... This never qualifies with 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)

July 4, 2008 at 9:46 pm

#838464
RE: Avoid Stored proc Fire triggers

Actually.... I want to see both the trigger and the proc... it would also be nice if you'd post the Create statements for the table being deleted from and any...
--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:14 pm

#838462
RE: Randomly Pick Specified Number of Rows?

ywb (7/4/2008)
It does. Thanks!
Two way street... I'm always curious about these type of things...
Why do you need to do this, 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 9:09 pm

#838460
RE: www.sqlservercentral.com

The OP "left the building" 2 months ago...
--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:08 pm

#838459
RE: Raima Database Data Import

What is a "Raima" database? Never heard that one before...
--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:07 pm

#838458
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

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