Jeff Moden

Forum Replies Created

Viewing 15 posts - 57,091 through 57,105 (of 59,101 total)

RE: Dynamic SQL - Drop Table

Yep... whichever one ran first on my box, lost by about a second. Then, I removed the drop from both, whichever one ran first, also lost by about a second. ...
--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)

January 9, 2007 at 5:47 am

#681992
RE: Extract data from table to a remote path using BCP

The SQL Server "Service" must be logged in as a user that can "see" those remote paths. As Lynn said, that also means that user must have permissions to see...
--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)

January 8, 2007 at 8:28 pm

#681933
RE: Dynamic SQL - Drop Table

Now, reverse the test... do it with the NO DROP first...
--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)

January 8, 2007 at 8:18 pm

#681932
RE: bcp isql osql

First, don't use ISQL... it's quite a bit deprecated when compared to OSQL which you should use instead.
Second, yes, both your BCP and OSQL should be very close... probably 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)

January 8, 2007 at 6:26 am

#681740
RE: what are causes for slow insert operations in table ?

Of course, we could stop guessing if you'd post the code, Ashok.
--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)

January 8, 2007 at 6:18 am

#681739
RE: help me in writing a Query

Looks a lot like homework or a quiz... what have you tried?
--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)

January 7, 2007 at 11:07 pm

#681703
RE: any alternatives of left outer join

Outer joins are not always the culprit in slow SQL... joining a bunch of tables and returning to0 many columns usually is. Also, the reason why adding indexes isn't helping...
--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)

January 7, 2007 at 10:19 pm

#681693
RE: what are causes for slow insert operations in table ?

Usually, the culprit is a CLUSTERED PRIMARY KEY... change it to non-clustered.
--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)

January 7, 2007 at 10:14 pm

#681692
RE: Time Striiping

If you want it to be unique across days (11PM today is NOT the same as 11PM yesterday)...
SELECT ...
GROUP BY DATEDIFF(hh,0,PinIssueDate)
--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)

January 5, 2007 at 10:30 pm

#681620
RE: SQLServerCentral Rules of Conduct

Ohhhh hold the phone right there... As much as I like Joe, his comments can really get out of hand... I don't care how good you are, no one has...
--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)

January 2, 2007 at 10:34 pm

#680894
RE: Problem with the ORDER BY and "-" char

Or...
declare @tabla table(field char(20))
insert @tabla values ('AABBZ')
insert @tabla values ('AADDZ')
insert @tabla values ('AA-EZ')
insert @tabla values ('AA--Z')
insert @tabla values ('AA++Z')
insert @tabla values ('AA+EZ')
insert @tabla values ('AACCZ')
SELECT *...
--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)

January 2, 2007 at 9:42 pm

#680893
RE: Help needed

John Rowan is correct about the existing rows... that's why some have suggested that the new column be a "calculated column" (see CREATE TABLE and ALTER TABLE in Books Online...
--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)

January 2, 2007 at 7:57 pm

#680887
RE: SQLServerCentral Rules of Conduct

Lee,
I absolutely agree with Brian on this one... I'm still looking forward to part 2, as well. Don't let the flamers deter you... think of it like an iceberg... you...
--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)

January 2, 2007 at 7:24 pm

#680885
RE: ''''Sargable'''' where clause

Nope, with the second index in the code, I'm getting an INDEX SEEK on the OR method...
But I agree with the rest... why go through an index at all 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)

January 2, 2007 at 7:24 am

#680741
RE: Help Needed !!!!!!!!!!!!!!

You say you've been working on it for "weeks"... let's see what you've tried.
--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)

January 2, 2007 at 12:33 am

#680699

Viewing 15 posts - 57,091 through 57,105 (of 59,101 total)