Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,616 through 48,630 (of 59,099 total)

RE: CPU IS Running mostly above 95%

Carl Federl (8/25/2008)
"could you post a copy of the code that fixed your parameter sniffing problem?"
This application is running under SQL Server 2000 and the analysis consisted 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, 2008 at 9:49 pm

#862888
RE: MIS in the UK

skenzie (8/25/2008)
And thanks Jeff for spurring me on, even at my age....heh heh. I'm going to apply for the job but making it clear I have no actual qualifications but...
--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, 2008 at 9:47 pm

#862887
RE: Need help in a query - Accessing and modifying previous row data

Amit Khanna (8/25/2008)
Hi Sg,
WITH C_TEMP AS
(
SELECT T.num,T.OP_Bal,T.quantity,T.OP_Bal + T.quantity AS Closing_Bal
FROM #Temps T
WHERE T.num...
--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, 2008 at 9:23 pm

#862885
RE: No: of day between two dates

aneeshvarghes (8/24/2008)
I want the count each day seperately
Still doesn't tell me a thing... like I said, tell us exactly what you want by giving us an example of the inputs...
--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, 2008 at 9:21 pm

#862884
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

dphillips (8/25/2008)
Aye, but there is another way. The set of data you are providing to the pivot, can be forced to populate zeros or empty strings as 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)

August 25, 2008 at 9:19 pm

#862883
RE: Query restructure

pakaw_man (8/24/2008)
please help me solve this problem:
I'm off to bed just now... but I have a suggestion for you... start your own thread for this problem. It'll get more...
--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 24, 2008 at 11:41 pm

#862377
RE: Query restructure

KB (8/21/2008)
The execution plan for my original query and the derived table query is exactly the same with 50%-50% cost.
Ummmm.... never trust the "cost" of a batch in 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 24, 2008 at 11:39 pm

#862375
RE: Converting integer to time

DECLARE @Table TABLE(TimeNumber INT)
INSERT INTO @Table
SELECT '131000'
UNION
SELECT '220000'
UNION
SELECT '230000'
...
--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 24, 2008 at 11:25 pm

#862371
RE: No: of day between two dates

... and, if that's not the right answer, then tell us exactly what you want by giving us an example of the inputs provided and a printout of what you'd...
--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 24, 2008 at 11:09 pm

#862369
RE: No: of day between two dates

Mukti (8/22/2008)
If you are trying to do this in T-Sql then create a function that will return the desired string. Here is the code.
CREATE Function DaysBetweenDates
(
@FromDate smalldatetime,
@ToDate smalldatetime
)
RETURNS varchar(4000)
AS
BEGIN
DECLARE
@DaysInBetween varchar(4000)
SET...
--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 24, 2008 at 11:06 pm

#862368
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

You bet, Mishaluba! Thanks for the compliment! 🙂
--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 24, 2008 at 10:52 pm

#862366
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

LMAO! You must love them almost as much as me! 😉
--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 24, 2008 at 7:17 pm

#862350
RE: How to replace a text

Nuts (8/24/2008)
Hi
I had to import a txt file into sql server . I have attached the sample file for your reference.
It would be really good to know how 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)

August 24, 2008 at 6:57 pm

#862347
RE: CPU IS Running mostly above 95%

By the way... could you post a copy of the code that fixed your parameter sniffing problem? Thanks...
--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 24, 2008 at 6:46 pm

#862346
RE: CPU IS Running mostly above 95%

Oh Yeah! I forgot about that, Carl! Parameter sniffing can indeed cause these kinds of problems.
--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 24, 2008 at 5:12 pm

#862340

Viewing 15 posts - 48,616 through 48,630 (of 59,099 total)