Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,151 through 42,165 (of 59,067 total)

RE: Storing IPv4 Addresses for Performance

Elliott W (8/26/2009)
I want the developers reading this to know that all tools should be on the workbench. And to keep an eye out for the right tool 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 29, 2009 at 1:51 pm

#1046537
RE: A True SQL OS

Steve Jones - Editor (8/29/2009)
I'd argue, Jeff, we can do both.
Tune us an OS server on a core installation, and also improve the language. I bet some of your items...
--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 29, 2009 at 1:43 pm

#1046535
RE: A True SQL OS

That might be nice but I'd rather see them spend the time on improvements to SQL Server itself. For example... some better IO functions for T-SQL. Why is...
--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 29, 2009 at 1:20 pm

#1046524
RE: Weekend DBA's

You are not alone... it's in our blood and nature to do all the things you mentioned.
--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 29, 2009 at 1:03 pm

#1046522
RE: Removing Carriage Returns

MANU (8/28/2009)
Try:
UPDATE tablename
SET columnname= REPLACE(SUBSTRING(columnname, 1, DATALENGTH(columnname)), char(13), '')
WHERE charindex(char(13) , columnname) > 0
HTH!
MJ
Manu,
Just curious... Why are you using SUBSTRING in this? REPLACE...
--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 28, 2009 at 7:58 pm

#1046445
RE: Are the posted questions getting worse?

Roy Ernest (8/28/2009)
Thanks Grant, I am hoping it will continue like this.
Alvin, This is a dream start for us. The island I reside in has only 100,000 people in...
--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 28, 2009 at 7:38 pm

#1046442
RE: find the position of the charcter in delimited string

Garadin (8/28/2009)
I'll second the props to Jeff for learnin' me all about Tally tables.
Heh... thanks, Seth. Folks like you, Bob, and a couple of others have made it 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)

August 28, 2009 at 6:26 pm

#1046439
RE: convert julian date to standard date format

Lynn Pettis (8/28/2009)
If I am right, this should work:
DECLARE @jdate int
SET @jdate = 109252
select dateadd(dd, (@jdate - ((@jdate/1000) * 1000)) - 1, dateadd(yy, @jdate/1000, 0))
That's more like it... and 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)

August 28, 2009 at 9:45 am

#1046321
RE: convert julian date to standard date format

Ummmm... won't that offset number work only for 2009?
--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 28, 2009 at 9:07 am

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

Heh... spot on Gus. I pretty much agree with all of that. I'd still like to know why folks would want to use TempDB instead of a "utility"...
--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 28, 2009 at 8:52 am

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

Viewing 15 posts - 42,151 through 42,165 (of 59,067 total)