Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,051 through 22,065 (of 59,072 total)

RE: Date format conversion

cheryljanicedsouza (1/3/2015)
My whole column needs to be converted into that format, not the specific field
Careful, now. It's pretty easy to return formatted data but you should never store dates...
--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)

January 3, 2015 at 9:15 am

#1767559
RE: stored procedure taking long time

mpradeep23 (1/2/2015)
hi team
my stored procedure was running fine
now it is taking long time what are the steps i need to follow to check what is the problem
thanks,
pradeep
Step 1. ...
--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)

January 2, 2015 at 9:38 pm

#1767518
RE: Insert Data set into two tables and grabbing identity from one, for the other

I could be wrong but that looks like it presupposes what the identities will be.
--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)

January 2, 2015 at 8:04 pm

#1767516
RE: Best approach to download variably named CSV file from FTP and insert into existing table?

Oddly enough, I've never used SSIS for such a thing. Here are the steps I've taken in the past.
1. Today's date is turned into the expected file name......
--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)

January 2, 2015 at 7:40 pm

#1767514
RE: What's Coming True?

It's a great start to 2015. My good friend and fellow SQL warrior Gianluca Sartori (aka, the "Spaghetti DBA") has finally awarded the SQL Server MVP award! 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)

January 2, 2015 at 4:49 pm

#1767509
RE: Are the posted questions getting worse?

spaghettidba (1/2/2015)
Now I see that my post could be seen as bragging, when all I wanted to do was nothing but say "thank you". I'm hopelessly bad at soft skills....
--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)

January 2, 2015 at 3:45 pm

#1767498
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/2/2015)
If you're feeling the itch and things are slow.....
Looking for good ... articles on practical topics.
Heh... I've got a bunch that I've been researching...
--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)

January 2, 2015 at 1:15 pm

#1767472
RE: Are the posted questions getting worse?

Eirikur Eiriksson (1/2/2015)
Stefan Krzywicki (1/2/2015)
Happy New Year everyone!
Who, like me, is at work today?
I must be the saddest (read nerdiest/most pathetic) in this bunch, got the day off but still...
--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)

January 2, 2015 at 1:12 pm

#1767471
RE: Comparing Bits and Ints

Phil Parkin (1/2/2015)
Viewing the XML for the execution plan, there are references to the CONVERT_IMPLICIT() function.
I only looked at the "properties" in the execution plan. I'll go back 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)

January 2, 2015 at 1:09 pm

#1767470
RE: Comparing Bits and Ints

I agree with Eirikur on this. I don't see an implicit conversion on the typical million row test and, not that you'd ever put an index on 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)

January 2, 2015 at 8:30 am

#1767399
RE: Are the posted questions getting worse?

Stefan Krzywicki (1/2/2015)
Happy New Year everyone!
Who, like me, is at work today?
Me. Covering for the younger folks that have families.
--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)

January 2, 2015 at 8:10 am

#1767394
RE: Wow!!! I didn't know that could be done - Datetime Calculations

ScottPletcher (1/2/2015)
GilaMonster (12/31/2014)
Luis Cazares (12/30/2014)
Yes, it's possible, but I wouldn't advice on using decimals on calculations as it's easy to get it wrong.
It's also far less clear than a DATEADD...
--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)

January 2, 2015 at 8:09 am

#1767393
RE: Are the posted questions getting worse?

spaghettidba (1/1/2015)
Happy New Year everybody!
And there's a very special thank you message for every single one of you on my blog here! 🙂
Thank you for involving me in the most...
--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)

January 1, 2015 at 7:24 pm

#1767334
RE: SQL Server 2014 Checklist for Performance

Ah... dang it! I forgot to do one of the most important things there is for the new year... change the bands on the pork chop launcher! 😛
--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)

January 1, 2015 at 1:50 pm

#1767327
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/1/2015)
Happy New Year!
Happy New Year to you and yours, Steve!
Same to everyone else! Have a very happy New Year! Lot's of good stuff...
--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)

January 1, 2015 at 1:44 pm

#1767326

Viewing 15 posts - 22,051 through 22,065 (of 59,072 total)