Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,976 through 39,990 (of 59,072 total)

RE: Indexing a Large Table

roelofsleroux (2/2/2010)
Thank for the head-up. But will this explain the reason why my SQL server over-consumed hardware resources and ended up not responding?
If you have a lot of code or...
--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)

February 2, 2010 at 6:01 pm

#1112602
RE: Running total , missing date , NULL in amount, exception handling

In that case, I guess I'd need to see the code, the tables, and the indexes for all 3 sections. I have a 7 year old single 1.8 GHz...
--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)

February 2, 2010 at 5:56 pm

#1112599
RE: TempDB into Memory

Why is there a limit to begin with? Is it just due to the physical nature of the device?
--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)

February 2, 2010 at 5:49 pm

#1112597
RE: All-in-one

Tom.Thomson (2/2/2010)
Actually you can script a system proc without using sp_helptext: right click and select modify to script it (as ALTER) to a new query window (not a very good...
--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)

February 2, 2010 at 5:47 pm

#1112595
RE: Extreme SSIS Newbie needs help with a super simple conditional insert

Thanks for the response, Dan.
Yep, I know that you can't have a two (or more) table source (well... Merge Join almost does that). I have an OLE DB source...
--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)

February 2, 2010 at 3:52 pm

#1112562
RE: Alphanumberic string search

BrainDonor (2/2/2010)
sql_ques (2/2/2010)
Please tell me how to do it.
No.
I will however take as long as is required to help you to work out how to write it. That 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)

February 2, 2010 at 3:37 pm

#1112557
RE: Extreme SSIS Newbie needs help with a super simple conditional insert

Oh yeah... almost forgot. While this seems to be a "natural" for replication, one of the requirements is to not use replication. I also can't simply use 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)

February 2, 2010 at 3:29 pm

#1112553
RE: UPSERT USING SSIS 2005

Hey there Ritz... I sure do hope you're still around because I need some help that your very good Word document just isn't helping me with. Would you take...
--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)

February 2, 2010 at 3:25 pm

#1112551
RE: Indexing a Large Table

roelofsleroux (2/2/2010)
Its basically to avoid JOIN statements.
It may be convenient to use but all you've done is avoid having to write JOIN statements. It's still doing a join 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)

February 2, 2010 at 6:14 am

#1112221
RE: Why moving a database slowed it down a lot?

george sibbald (2/2/2010)
Hmmm. Having trouble wrapping my head around this one. I hope its not true or everything I hold dear about backups turns out to be a lie. I...
--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)

February 2, 2010 at 6:01 am

#1112211
RE: Date Range

Sorry Arun... language barrier thing is interfering a bit. I didn't ask a question so I'm not sure what you mean.
--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)

February 1, 2010 at 10:05 pm

#1112075
RE: Indexing a Large Table

I agree with that. That's why we want to see that slow query and the execution plan for it. We're just shooting in the dark until that happens.
--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)

February 1, 2010 at 10:01 pm

#1112074
RE: Deciding whether adding RAM will help performance

I'm not sure on how to demonstrate the benefit of additional RAM without actually buying it and show how it does or does not make an improvement.
So far...
--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)

February 1, 2010 at 9:55 pm

#1112072
RE: Date Range

There will be no such animal as 2010-02-29. 😉
Arun... you beat me to it.
--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)

February 1, 2010 at 9:23 pm

#1112066
RE: T-SQL Stored Proc calling T-SQL Function

mark.veitch (2/1/2010)
The following is our T-SQL function that is being called for all VarChar,Char,NChar and NVarChar fields in our SELECT statement in a stored proc. There is a lot...
--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)

February 1, 2010 at 9:12 pm

#1112064

Viewing 15 posts - 39,976 through 39,990 (of 59,072 total)