Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,876 through 37,890 (of 59,072 total)

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

Agile (6/28/2010)
At last I did it!, but If anyone see improvements on this script, please do tell me.
DECLARE @fn varchar(8000)
SELECT @fn = CASE
WHEN LEN(DatePart(mm,DateAdd(d,-1,DateAdd(d, DateDiff(d, 0, GetDate()), 0))))=1 THEN 'E:\'+...
--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:43 pm

#1186109
RE: Check duplicates records while bulk inserting in to Table

Chris Morris-439714 (6/28/2010)
Everything in your database is valuable, everything outside is garbage. A staging table serves as a firewall between the two.
VERY well stated, Mr Morris! 🙂
--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:19 pm

#1186103
RE: Production DBA Begineer's Task list ?

diva.mayas (6/28/2010)
What kind of TASK or Job a Begginer's Production DBA should be ?
can anybody list some professional way the job or task assigned to
Production DBA begineers ?
Everything the Production...
--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:15 pm

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

Dave Ballantyne (6/28/2010)
I know *we* are on the same page here. Personally i dislike the word physical as that would imply that on the hardware, page 2 would follow...
--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:12 pm

#1186099
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

Viewing 15 posts - 37,876 through 37,890 (of 59,072 total)