Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,566 through 38,580 (of 59,072 total)

RE: Rounding problem

Hi Greg... long time no see.
To round down as you seem to think you need, lookup ROUND in Books Online and study the 3rd operand of the function that 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 6, 2010 at 11:27 pm

#1163792
RE: Calculate values for TallyDuration

Clive... how'd that work for 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 6, 2010 at 9:17 pm

#1163763
RE: Daily,Weekly,Monthly Report using TSQL

Agile (5/6/2010)
Thanks for reply, As I said I already did the query(T-SQL) to get the Daily, Weekly, Report, But I need them in "1" view so maybe I need 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)

May 6, 2010 at 9:10 pm

#1163760
RE: Date format

Raunak Jhawar (5/6/2010)
Hi Malvika,
As a better practice it is always suggested that one should always handle date-time manipulation at database level and not on SSRS interface.
Heh... not "always suggested" because...
--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 6, 2010 at 9:06 pm

#1163758
RE: convert month name to month number

madhu.gut (5/6/2010)
Hi All
How should i convert the month name to month number like
'April' it should converted to 4
'January' it should converted to 1
in this how should i do this
can 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)

May 6, 2010 at 8:55 pm

#1163757
RE: What is the most efficient way to delete records?

brutsoft (5/6/2010)
Jeff Moden (5/6/2010)
How many indexes do you have on this bad boy? Also, do you have any Foreign Keys or triggers associated with this table?
Out of 180GB occupied...
--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 6, 2010 at 8:45 pm

#1163756
RE: MAXDOP

Bhuvnesh (5/6/2010)
Chinna-703814 (5/6/2010)
how do we set it for sql server 2005
and more important why we need to set it up ?
As well as what Leo said, sometimes the costs...
--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 6, 2010 at 8:38 pm

#1163755
RE: SQL Server Aggregation Query - Help needed

riyaz.mohammed (5/6/2010)
Hi that worked great for the example i provided. If i add another requirement into the mix what would the SQL look like?
SEQUENCE,PRODUCT,TIME,PRICE
1,Spoon1,2010-05-05 08:30:00.000,83.50
2,Spoon1,2010-05-05 08:31:01.000,80.00
3,Spoon1,2010-05-05 08:32:02.000,81.00
4,Spoon1,2010-05-05 08:33:03.000,82.00
5,Fork1,2010-05-05 08:31:01.00,90.50
6,Fork1,2010-05-05...
--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 6, 2010 at 8:24 pm

#1163751
RE: Using the result of a function in the retrned values & where-clause

Although it's a bad practice to use "*", it's not really going to matter here. Sargeability has already been destroyed by the function and it's not a view 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)

May 6, 2010 at 8:05 pm

#1163744
RE: What is the most efficient way to delete records?

brutsoft (5/6/2010)
And here the first million with the new script:
13122010-05-07 12:32:35.697
13012010-05-07 12:01:39.113
If I have 1 mil deleted every half an hour I'll need >70 more hours to finish the delete...
--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 6, 2010 at 7:53 pm

#1163740
RE: What is the most efficient way to delete records?

Leo.Miller (5/6/2010)
You asked: Why are you saying that to find the TOP (1000000) sql must check all the records?
The only way to find the TOP record is to look at...
--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 6, 2010 at 7:44 pm

#1163738
RE: Help with Query

Between the sample data, the sample output, and the description, it was a pleasant change for me. I'll tolerate nuances of the language barrier for postings like 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)

May 6, 2010 at 7:17 pm

#1163733
RE: Advantage of Using Constraint when adding FK or PK

PaulB-TheOneAndOnly (4/26/2010)
Jeff Moden (4/23/2010)
If the table is a Temp Table, there's actually a DISADVANTAGE to using CONSTRAINT to name the PK... a constraint is one of those objects whose 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)

May 6, 2010 at 6:14 pm

#1163725
RE: Allowing access to tempdb

Gosh... I'm not sure how to help. Generally, everyone has access to TempDB and should be able to read TempDB.sys.Objects. I'm also surprised that if the GUI 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)

May 6, 2010 at 6:01 pm

#1163720
RE: Training for Managers

Lynn Pettis (5/6/2010)
CirquedeSQLeil (5/6/2010)
Lynn Pettis (5/6/2010)
Jeff Moden (5/5/2010)
Something that people either aren't aware of or have forgotten... the option of in-house training by the resident experts is a powerful...
--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 6, 2010 at 5:40 pm

#1163718

Viewing 15 posts - 38,566 through 38,580 (of 59,072 total)