Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,081 through 43,095 (of 59,098 total)

RE: OpenRowset Error

Heh... do you expect it to guess what to do with your stored proc? You need it to be a valid query.
Also, (local) doesn't seem to work as a...
--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 7, 2009 at 9:04 pm

#1021446
RE: Find the substring in string

rpyerneni (7/7/2009)
Wayne,
I worked on your code. As I told you I have so many links in the content. I splitted the content and inserted the splitted data into a temporary...
--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 7, 2009 at 8:54 pm

#1021442
RE: write to text file using sql

I've never experienced BCP being slow at anything. Usually, it's the associated query that's slow. Please post both the BCP command and the query being executed by BCP.
--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 7, 2009 at 8:49 pm

#1021439
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

Paul White (7/7/2009)
As far as the IF @@ERROR is concerned, I just prefer TRY...CATCH, especially in demo code. (Some idiot will come along one day and insert a SET...
--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 7, 2009 at 8:42 pm

#1021436
RE: Music for DBAs

Alvin Ramard (7/7/2009)
I don't think anyone mentioned:
50 Ways to Leave Your Cursor (Paul Simon)
Here's another one where a name change isn't actually required to still be appropriate...
The good, the bad,...
--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 7, 2009 at 8:31 pm

#1021431
RE: Naming Conventions Standards

I don't use any prefexies in my production databases. The reason is that a table could be changed to a view or vice versa and having a prefix would...
--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 7, 2009 at 9:28 am

#1021158
RE: How to customize "Order By" in my select query?

GSquared (7/7/2009)
Ian Scarlett (7/7/2009)
Rather than add a SortOrder column to the table, just include one in your query e.g.
select id, forename, case when forename = 'Kim' then 1 else 2...
--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 7, 2009 at 9:26 am

#1021154
RE: Merge Many rows to one row

Bur@ir (7/5/2009)
Now i dont want to have so many rows linked to 1 customer.
Why not? It's what databases do. The other methods will require the additional headaches 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)

July 7, 2009 at 9:17 am

#1021145
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

Paul,
Very cool. The additional sequence table prevents the need for a SELECT or comparison in the code at all and that's important for both concurrency and the prevention...
--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 7, 2009 at 6:06 am

#1020983
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

BWAA-HAA!!! Well, at least now you know why I'm so opposed to any form of "ID Reservation" or "Sequence" table. While it's possible to make such a thing...
--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 6, 2009 at 9:45 pm

#1020854
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

Idea understood... but that's a sequence table and that's even worse that what's trying to be done for updates unless you're very, very, very careful and you use a 3...
--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 6, 2009 at 9:11 pm

#1020838
RE: SQL Split query

Heh... dang it... I had the right thread after all. That code above is slow. Where all the other methods take something less than 16 ms to split...
--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 6, 2009 at 9:02 pm

#1020834
RE: SQL Split query

Sorry... wrong thread.
--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 6, 2009 at 8:50 pm

#1020830
RE: SQL brian teaser...

Digs (7/5/2009)
I havent built it yet. Because what comes first the chicken or the egg,...
By the way... the answer to that question is the "egg" because a chicken can only...
--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 6, 2009 at 8:30 pm

#1020823
RE: SQL brian teaser...

Where'd Digs go? He owes us a post with his solution...
--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 6, 2009 at 8:26 pm

#1020821

Viewing 15 posts - 43,081 through 43,095 (of 59,098 total)