Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,906 through 37,920 (of 59,098 total)

RE: Cross Database Queries...Performance Impact?

bkothe (6/28/2010)
Currently I have one database with a $H*T TON of tables (It embarasses me to say the actual number). Having this number of tables makes it hard 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 28, 2010 at 4:05 pm

#1186094
RE: Contribution Editor

It bugs the heck out of me, as well. That's why I create articles in WORD and then transfer them (very carefully).
What would really be cool is a template...
--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 28, 2010 at 3:57 pm

#1186089
RE: Getting RowCount of Large Table

Jeff Moden (6/28/2010)
@jason,
The SQLPlan you posted seems to be an "estimated" plan... can you include an "Actual" plan?
Now THAT's interesting... although an INDEX SEEK is listed, no predicates are listed...
--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 28, 2010 at 3:49 pm

#1186083
RE: Getting RowCount of Large Table

@jason,
The SQLPlan you posted seems to be an "estimated" plan... can you include an "Actual" plan?
--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 28, 2010 at 3:26 pm

#1186061
RE: Getting RowCount of Large Table

Jason Messersmith (6/28/2010)
EODDate is an int atm, I am working on some tests to see if changing it will help but the date is used as an int thoughout 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 28, 2010 at 3:20 pm

#1186058
RE: Need some help quickly please

Stephen crocker (6/28/2010)
I need help finding out how to get the description information from a view/stored procedure, function etc..
I need to produce a list of all Views/Stored Procedures/Functions/Tables that were...
--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 28, 2010 at 2:46 pm

#1186037
RE: Getting RowCount of Large Table

lmu92 (6/28/2010)
Any particular reason for not using COUNT(*)?
But more interestingly: is there any index available supporting the WHERE clause?
If not, can you change it to benefit from an existing index...
--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 28, 2010 at 2:20 pm

#1186018
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

davec-640463 (6/28/2010)
togaratw (6/26/2010)
Great article and it surely points the way for more efficient statements.
I'm eagerly anticipating the next series of this article for more complicated scenarios where cursors can...
--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 28, 2010 at 8:03 am

#1185752
RE: Need Expert advice on my sql query for speed improvement

Dave Ballantyne (6/28/2010)
Jeff Moden (6/27/2010)(which ~~physically~~ sorts the data in the table)
Logically , i think you mean Jeff 😉
Nope... I meant "physically".
--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 28, 2010 at 7:27 am

#1185725
RE: Fixed width text file and SSIS

huber_jessica (7/20/2009)
The original poster never took your offer, but I'd like to. I haven't configured a BCP file using SSIS Bulk Insert before, but if it's going to 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 28, 2010 at 7:17 am

#1185708
RE: Variable Table Names in SP ?

Thanks. Let me know how it works out for you.
Also, make sure that if there is more "@Walker" code, that it continues to follow the same pattern...
--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 28, 2010 at 7:11 am

#1185701
RE: Need Expert advice on my sql query for speed improvement

Agile (6/27/2010)
Thanks guys! I think it's too much if I ask again what are the meaning of the items that you inserted. I'll just study them by my self and...
--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 27, 2010 at 9:49 pm

#1185492
RE: Are the posted questions getting worse?

lmu92 (6/27/2010)
Matt Miller (#4) (6/27/2010)
...
It's hard to even support that claim (the "dodgy decision" one). I can't believe FIFA actually tolerates the shoddy refereeing that's being shown. It seems...
--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 27, 2010 at 9:44 pm

#1185491
RE: Are the posted questions getting worse?

Lynn Pettis (6/27/2010)
I will agree that there have been some bad calls, some made and some that should have. Over all, however, I think the officiating has been 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)

June 27, 2010 at 9:41 pm

#1185489
RE: T-SQL for creating a text file with with this filename format - Month(MM)Day(dd)Year(yyyy).Log

Agile (6/27/2010)
sorry for that... I have to get yesterday date.
Thanks
Morris
In that case, I'd use sqlcmd to write out the correct bcp command to another batch file and then execute...
--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 27, 2010 at 9:33 pm

#1185488

Viewing 15 posts - 37,906 through 37,920 (of 59,098 total)