Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,161 through 50,175 (of 59,091 total)

RE: problem in loading

Are you using a loop of any kind in the data load process?
--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)

June 5, 2008 at 6:07 pm

#825202
RE: data mining structure processing issue

We're still waiting for you to post something that can actually be troubleshot...
--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)

June 5, 2008 at 6:05 pm

#825201
RE: Changing row format

Another way is to import the spreadsheet into a table as is... then, do something like this to normalize it...
SELECT Vendor,Name1 AS Attendee
FROM sometable
UNION...
--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)

June 5, 2008 at 5:07 pm

#825189
RE: Changing row format

Yes... same solution... just export the data as tab delimited and do the split on the tab.
--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)

June 5, 2008 at 5:03 pm

#825188
RE: newbie SQL Server delete rows question

bullcrap420 (6/5/2008)
Please let me know if you concur or know of an easier or better way to accomplish this.
Thank you!
Heh... I don't concur with any of what you're trying 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)

June 5, 2008 at 4:54 pm

#825184
RE: Append another Item to the Parameter List

I agree... it'll likely require a change to the sproc or a bit of very clever SQL Injection and then only if the sproc is vulnerable.
--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)

June 5, 2008 at 4:46 pm

#825182
RE: What are the performance issues while using linked server by using join quries?

I think you guys might be missing something... Yep, I'm sure that you're preaching to the choir when it comes to running jobs at night, etc...
The real problem the OP...
--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)

June 5, 2008 at 4:35 pm

#825177
RE: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

You got that from a "SELECT GETDATE()" on both boxes??? If not, what are you using to get this date and what happens if you try "SELECT GETDATE()" on...
--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)

June 5, 2008 at 3:51 pm

#825160
RE: Performance Adding Hints

Sure, it could be... the real key is to write code that doesn't need it to prevent blocking, though. Generally speaking, code that uses WITH (NOLOCK) everywhere is 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)

June 5, 2008 at 11:28 am

#825003
RE: Another COLUMNS TO ROWS (or vice-versa) question

kappa (6/5/2008)
Hi, thanks for getting involved and sorry about the attitude, not enough sleep, I guess 🙂
OK, here we go. I have done the search, and then some... Among 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)

June 5, 2008 at 11:17 am

#824988
RE: "Vertical" COALESCE ?!?

kappa (6/4/2008)
Question: HOW?
Answer: CROSSTAB or PIVOT!
... but, like Jeffrey stated, you're gonna need another column of information from somewhere that maintains the sequencing of the rows. Of course, that...
--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)

June 4, 2008 at 6:22 pm

#824603
RE: Huge size blowout on Database

That kind of narrows it down to something on the server... are they loading in a different recovery mode than you are? Do you have different server or db...
--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)

June 4, 2008 at 6:11 pm

#824601
RE: Aggregate query question

It's not homework, I swear (does it make any difference).
Yes, it does make a difference... I'm more prone to help someone (anyone, not just students) that shows that they've...
--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)

June 4, 2008 at 6:02 pm

#824599
RE: Performance Adding Hints

Kevin (6/4/2008)
The question I have is WHat if you have some tables that have a With(NOLOCK) hint on them that are joined to tables that do not have the NOLOCK...
--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)

June 4, 2008 at 5:33 pm

#824595
RE: Aggregate query question

Sounds a lot like homework... don't mind helping, but let's see what you've tried... also, take a look at the URL in my signature... you'll get a better answer quicker...
--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)

June 4, 2008 at 5:03 pm

#824590

Viewing 15 posts - 50,161 through 50,175 (of 59,091 total)