Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,116 through 47,130 (of 59,101 total)

RE: Optimizing Database Growth

Gaby A. (11/19/2008)
Thanks everybody, given me food for thought. Unfortunately this DB was set up before I joined my company but but at least in the future, if 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)

November 19, 2008 at 9:02 pm

#900856
RE: Set Date Format on Flat File Source

Ted Zatopek (11/19/2008)
After lots of searching, I fanally ran across the term "fast parse" in an article and found the following MSDN article.
http://msdn.microsoft.com/en-us/library/ms139833(SQL.90).aspx
This seems to be just the trick 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)

November 19, 2008 at 8:59 pm

#900855
RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

Show me your code so I can modify it for 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)

November 19, 2008 at 8:46 pm

#900850
RE: Help with Money and Decimal datatype

Any feedback regarding my question, Karthick. Heh... "Inputs are welcome!" 😉
--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)

November 19, 2008 at 8:44 pm

#900849
RE: Using a SQL Stored Procedure to import an Excel spreadsheet

Sounds like a one time task... recommend you use SSIS to import the data into a "staging table" and then do an insert into the final table(s) from there.
--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)

November 19, 2008 at 8:42 pm

#900848
RE: field with multiple values

Alasdair Thomson (11/19/2008)
I hope this might be of use, we use the following function to breakdown the delimited list and then pass in our sp using cusors;
Please see the following......
--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)

November 19, 2008 at 8:33 pm

#900843
RE: Bulk Insert Grief

Jim Russell (11/19/2008)
Jeff Moden (11/18/2008)
You don't need a format file for this nor even BCP. Just do a BULK INSET and specify the FIELDTERMINATOR = ''.
Bringing in the entire...
--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)

November 19, 2008 at 8:09 pm

#900836
RE: getting rid of 0's in the start of a varchar(6) column

Rajesh (11/19/2008)
I am sorry, little confused with the reply. Could you be specific, what's the input and what needs to be the op with few examples. If the the volume...
--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)

November 19, 2008 at 7:58 pm

#900831
RE: Tips for New DBAs

SQLBOT (11/19/2008)
Peter,
I think you'll like the next article which is about knowing what is the DBA's responsibility and saying "NO!" to what's contradicts CIA and the systems you have...
--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)

November 19, 2008 at 7:56 pm

#900829
RE: Select based on Date- How to?

mpdillon (11/19/2008)
A friend suggested the following. It seems to be cleaner than mine.
Where cast(varchar(8),EndDt,112) <= Format('01/02/2009',"yyyyMMdd") Sorry for mixing T-SQL and VB.
However, both Jeff and Lynn bring up the issue...
--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)

November 19, 2008 at 7:54 pm

#900827
RE: Select based on Date- How to?

Lynn Pettis (11/19/2008)
shailesh (11/19/2008)
Where dbo.ufn_GetDateOnly(EndDt) <= '01/01/2009'
And doing this can result in your query not taking advantage of indexing on a table. If your tables are small, 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)

November 19, 2008 at 7:49 pm

#900825
RE: Displaying NULL as the last row + ORDER BY

Zactly... 🙂
--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)

November 19, 2008 at 7:46 pm

#900824
RE: Are the posted questions getting worse?

Hey, Naked Ape and BitBucket... thanks. It's folks like the two of you that make this all worthwhile. 🙂
--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)

November 19, 2008 at 7:43 pm

#900823
RE: Are the posted questions getting worse?

GilaMonster (11/19/2008)
Jeff Moden (11/18/2008)
consider the answer that one wiz kid gave...
"You should be using derived column transformation, and use substring or available string functions. This would help." ... 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)

November 19, 2008 at 7:41 pm

#900822
RE: MS SQL Aggregate Function

kmohan39 (11/19/2008)
Hello there,
This is the Task:
Select the title_id, type, and price from the titles table along with an average price for all tables
Not what I asked for... 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)

November 19, 2008 at 6:49 pm

#900816

Viewing 15 posts - 47,116 through 47,130 (of 59,101 total)