Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,196 through 42,210 (of 59,102 total)

RE: convert julian date to standard date format

schauhan13 (8/27/2009)
in my table there is clumn
Jdate int
In this column julian date is stored
now i need to convert it into standard date. Can anyone help me please
At least...
--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)

August 27, 2009 at 9:17 pm

#1046026
RE: relpace portion of string in table

jim.rasmussen (8/27/2009)
I have found a solution. Thanks for the help.
Jim
2 way street here, Jim. Please post the solution you found. 😉
--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)

August 27, 2009 at 9:14 pm

#1046024
RE: Creating tables on tempdb. is it a good idea

Gianluca Sartori (8/27/2009)
This is really a good point, Jeff.
And this is the main reason why I like temp tables: it's all mine and I can do whatever I want with...
--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)

August 27, 2009 at 8:17 pm

#1046015
RE: Creating tables on tempdb. is it a good idea

Dean Jones (8/27/2009)
If 2 instances are trying to read data off the table, I dont see anything that will go wrong here. please explain
See the post just above this one,...
--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)

August 27, 2009 at 8:12 pm

#1046014
RE: Creating tables on tempdb. is it a good idea

GSquared (8/27/2009)
Jeff Moden (8/27/2009)
I think it's a bad idea because what will happen if two instances of your code are executed at the same time?
That's why I mentioned checking for...
--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)

August 27, 2009 at 8:08 pm

#1046013
RE: WORD UP!

CirquedeSQLeil (8/27/2009)
Ever thought of upgrading to a previous version. Sorry guys - not a fan of Office 2007, ribbons and frilly things - yuck.:-D
Man, do I agree with THAT!...
--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)

August 27, 2009 at 12:46 pm

#1045799
RE: WORD UP!

crookj (8/27/2009)
Another thing I came across is...
Make sure that you have a licensed software version and that it has been activated.
Still looking.....
Joe
Thanks. Just to assure everyone, I'm so honest...
--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)

August 27, 2009 at 12:11 pm

#1045767
RE: Creating tables on tempdb. is it a good idea

I think it's a bad idea because what will happen if two instances of your code are executed at the same time?
--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)

August 27, 2009 at 11:52 am

#1045753
RE: How to decide to aggregate data in SQL Server or in Report Server

There's really only one way to know for sure... try both with Profiler running. Select the one that uses the fewest resources for CPU and Reads. Both should...
--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)

August 27, 2009 at 11:28 am

#1045726
RE: When will the next 13th fall on a Friday?

Rimvydas Gurskis (8/27/2009)
How about set-based approach:
SET DATEFIRST 1
;WITH days(Date) AS
(
--Get 13th of this month
SELECT CAST(CAST(YEAR(GETDATE()) AS VARCHAR(4)) + '-' + CAST(MONTH(GETDATE()) AS VARCHAR(2)) + '-13' AS DATETIME)
UNION ALL
--Get 13th...
--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)

August 27, 2009 at 8:29 am

#1045572
RE: Are the posted questions getting worse?

Elliott W (8/26/2009)
Do none of these people know how to google a problem before they post? I've had a couple that their resolution was already posted in another thread...
--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)

August 26, 2009 at 10:11 pm

#1045323
RE: First run of a query takes much longer

glu (8/26/2009)
Lynn is right. After I run
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
the query took 32 seconds, the next run 6 seconds. execution plan takes 1 seconds, recompile takes...
--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)

August 26, 2009 at 10:08 pm

#1045322
RE: Storing IPv4 Addresses for Performance

Elliott W (8/25/2009)
Good point... No flames... just thoughts.... If all you intend to do is split the octets, then the six line T-SQL solution that uses PARSENAME is almost as...
--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)

August 26, 2009 at 12:31 am

#1044703
RE: Overselling Yourself

Steve, great editorial, as usual. My recent bout with folks that have been copying my articles as my own has led me to take one extra step on any...
--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)

August 25, 2009 at 11:00 pm

#1044673
RE: Overselling Yourself

sjsubscribe (8/25/2009)
This has been a perpetual problem for govt employment. For some jobs we could not even acknowledge product familiarity much less evaluate or offer critical advice. So most of...
--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)

August 25, 2009 at 10:25 pm

#1044660

Viewing 15 posts - 42,196 through 42,210 (of 59,102 total)