Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,176 through 50,190 (of 59,102 total)

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
RE: Huge size blowout on Database

The software company that own the database program have restored the same backup onto their server and performed the upgrade with virtually no change to the database size.
I've not seen...
--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 3:39 pm

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

kappa (6/4/2008)
No?
Gee, and I thought this was an easy one... :unsure:
Ok... I'll try to be gentle even with an attitude like that... 😉
You haven't provided enough information... why do 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)

June 4, 2008 at 3:31 pm

#824569
RE: Identity column

noeld (6/3/2008)
The use of a "central" table to get_nextID is not that hard and is "portable". Of course it will never get closer to the simplicity of an identity column....
--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 3:08 pm

#824550
RE: I am trying to convert rows to columns... not having much luck

THAT's why I sometimes get a bit angry with the folks that insist that everything must be done on the client side... server spends more time piping stuff over 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)

June 4, 2008 at 12:56 pm

#824451

Viewing 15 posts - 50,176 through 50,190 (of 59,102 total)