Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,341 through 38,355 (of 59,098 total)

RE: Help with Date part

sql.kishore1 (5/17/2010)
Thanks Guys. I got it now.
Cool... two way street here, though... would you mind posting your final code so other folks can learn from it? Thanks.
--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)

May 17, 2010 at 9:04 pm

#1168564
RE: Table size grows but with has zero rows

james.mcallester (5/17/2010)
Jeff (and any others who may have been having a think about this)
Thanks for your input.
After more exhaustive testing of the devlopers code, a loop was found for 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)

May 17, 2010 at 9:02 pm

#1168563
RE: Best SQL Server Edition for a offline application

Depending on what features of the Enterprise Edition you have used, there may not be much of a choice. My recommendation is for your network folks to setup 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)

May 17, 2010 at 8:58 pm

#1168562
RE: Slelect Problem: kind of like a pivot but different

@nsontag,
Nice job. It was only your second post and you came right around with some really nice test data. A lot of people squawk about doing such 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)

May 17, 2010 at 8:19 pm

#1168556
RE: Unable to insert into one particular table(this is a batch job)

mohammed moinudheen (5/17/2010)
On trying with this table, it fails and only about 1/10 th number of rows are inserted.
What is the error message that does show up? And no,...
--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)

May 17, 2010 at 8:11 pm

#1168555
RE: How to read data from file (not well formatted) with ssis

On second thought.... doesn't SSIS allow you to spec a "space" as a delimiter and to also include a quote as a text qualifier?
--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)

May 17, 2010 at 7:37 pm

#1168552
RE: How to read data from file (not well formatted) with ssis

asita (5/17/2010)
please share any ideas
please
thanks
asita
A BCP format file and a BULK INSERT in a stored proc would load this in a flash. Are you allowed to make 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)

May 17, 2010 at 7:35 pm

#1168551
RE: Can I make a query fail without killing the connection?

Henry Treftz (5/17/2010)
I want the query to fail and the connection to remain
Heh... we know that, Henry... why is it important for the connection to remain?
--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)

May 17, 2010 at 7:27 pm

#1168550
RE: Help with Date part

Heh... try the following, Rob...
SELECT ISDATE('2000')
You sure you want that as a valid date?
--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)

May 17, 2010 at 7:02 pm

#1168546
RE: Table size grows but with has zero rows

Did you, by any chance, do a SELECT COUNT(*) from the table to make sure that sp_SpaceUsed isn't "lying" to 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)

May 17, 2010 at 6:53 pm

#1168545
RE: Free Advice or Free Consulting

James... What kind of car do you own or lease?
--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)

May 17, 2010 at 6:46 pm

#1168544
RE: Updating 20M rows takes 5 hours

ss-457805 (5/17/2010)
Thank you guys for your responses.
I tried about 2.5 Mill rows in my test bed with the following method as suggested by stefan in the above post:
1. used select...
--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)

May 17, 2010 at 4:28 pm

#1168506
RE: Comparing two rows in one table for changes in column

Dobermann (5/17/2010)
My goodness I'm getting brain dead Jeff! Thanks for the kick! I've saved your post to my computer this time so I don't ask a third time!
Sadly,...
--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)

May 17, 2010 at 4:17 pm

#1168500
RE: Subroutines in TSQL

eric_russell 13013 (5/17/2010)
Paul White NZ (5/15/2010)
...
The wider question is an interesting one. I remember being asked once why we can create temporary stored procedures (local or global) but not...
--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)

May 17, 2010 at 12:28 pm

#1168411
RE: Multiple Row Into Columns

Can we see what you've tried so far? Also, since you're a newbie, give yourself the best chance at getting a coded answer for your question. Please read...
--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)

May 17, 2010 at 12:25 pm

#1168405

Viewing 15 posts - 38,341 through 38,355 (of 59,098 total)