Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,011 through 44,025 (of 59,097 total)

RE: Perform math on string

Jan Van der Eecken (4/29/2009)
Jeff Moden (4/28/2009)
Sergiy (4/28/2009)
Jeff Moden (4/27/2009)
I don't allow such garbage into my db's to begin with. 😛
I believe this is the method that doesn't suck so...
--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)

April 29, 2009 at 8:42 am

#985986
RE: SQL Function : Find ‘X’ Business Days in the Future

michaelberry67 (4/29/2009)
I think you all my benefit from my function that was published by SQL server magazine:
http://www.sqlmag.com/Articles/ArticleID/97590/97590.html?Ad=1
Do you have any performance stats... say, on 100,000 rows?
--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)

April 29, 2009 at 8:40 am

#985983
RE: Perform math on string

Sergiy (4/28/2009)
Jeff Moden (4/27/2009)
I don't allow such garbage into my db's to begin with. 😛
I believe this is the method that doesn't suck so much.
:hehe:
Heh... I just knew you were...
--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)

April 28, 2009 at 11:18 pm

#985648
RE: Comparison of Dates in SQL

craig.lovegren (4/28/2009)
Jeff Moden (4/28/2009)
Percent of what? Percent of BATCH??? That absolutely cannot be trusted. Only actual cpu usage, duration, reads, and writes should be used to measure...
--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)

April 28, 2009 at 9:06 pm

#985616
RE: Comparison of Dates in SQL

craig.lovegren (4/28/2009)
guess we could always just run both methods over a largish table and get stats out of the query analyser (like cpu usage, etc)
I did exactly that, using 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)

April 28, 2009 at 3:26 pm

#985531
RE: How to split one mdf file into two

Mohan Kumar (4/27/2009)
backup database [dbaScripts] to disk=N'C:\backup\dbaScripts_1.bak',
disk=N'd:\backup\dbaScripts_2.bak' with stats=10;
Rgds
Mohan Kumar VS
Heh... 10 is the default. Why bother typing it?
--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)

April 28, 2009 at 12:08 am

#984844
RE: Perform math on string

Sergiy (4/27/2009)
Jeff Moden (4/27/2009)
GSquared (4/27/2009)
To deal with times that don't have enough leading zeroes, you can either padd the string, or you can reverse it. Either one works.
As 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)

April 27, 2009 at 11:59 pm

#984841
RE: Select Values from multiple Rows Into a Single Row

John,
Do the numbers have to be in separate columns, or just on the same line?
Also, why do you need to do this type of denormalization? Where is the output...
--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)

April 27, 2009 at 11:01 pm

#984834
RE: Getting the Results witout using SubQuery

ningaraju.n (4/27/2009)
If u use the Sub query its killing the Performance.. So..;-)
Not always true if the subqueries only use "=". Anyway, looks like Chris get's the hat-trick on this...
--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)

April 27, 2009 at 10:50 pm

#984833
RE: Column,Date,Update

karthikeyan (4/27/2009)
i have to get the monthend date between @year_st and @year_end - current month (i.e previous month last date)
i.e
31/jan/2009
28/feb/2009
31/mar/2009
I am trying to implement 'Tally' table logic.
I'll do 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)

April 27, 2009 at 10:48 pm

#984832
RE: How to split one mdf file into two

Ratheesh.K.Nair (4/27/2009)
You can divide the backup into different files(striped backup) like if u have a 2GB DB,take backup to two file like
backup database DB_name to disk='path.file1',
...
--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)

April 27, 2009 at 10:10 pm

#984827
RE: Detect duplicate rows - with a twist

Scott Roberts (4/27/2009)
While I would completely agree that cursors are "significantly harmful", I'm not yet convinced that they are "no longer necessary".
Skepticism is certainly understood, especially on the types...
--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)

April 27, 2009 at 9:55 pm

#984823
RE: Special Characters

jim.rasmussen (4/27/2009)
I have a filed of varchar the holds names of companies. Like 'A & B Cleaners'. What I what to do is to select this.. 'ABClea'. How can 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)

April 27, 2009 at 7:46 pm

#984804
RE: Perform math on string

GSquared (4/27/2009)
To deal with times that don't have enough leading zeroes, you can either padd the string, or you can reverse it. Either one works.
As is usually the case,...
--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)

April 27, 2009 at 7:28 pm

#984803
RE: Solving the “Running Totals” Problem in SQL Server 2005 with Partitioned Tables

Actually, it only looked like the ORDER BY method worked in my article. It wasn't the ORDER BY that made it work. Of course, I'm just a day...
--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)

April 27, 2009 at 7:16 pm

#984801

Viewing 15 posts - 44,011 through 44,025 (of 59,097 total)