Jeff Moden

Forum Replies Created

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

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
RE: data archiving

Sai,
Once you get the intial archive done, how many rows would need to be archived on a daily basis? Also, please post the CREATE TABLE statement for the table...
--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 4:41 pm

#862337
RE: numeric sort of a varchar field

nag.netjob (8/22/2008)
Hi,
I have a column with datatype nvarchar and it contain some sample data
like:
001
12
112
123
M6921C0014
M6932A0034
M69800034
VALP054
VALP075
VALP086
Now my question is how i achieve sorting on above column?
Based on the title of this 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 24, 2008 at 4:39 pm

#862336
RE: CPU IS Running mostly above 95%

I agree... indexes won't fix the problems associated with accidental cross joins, triangular joins, or the RBAR associated with Cursors and/or While loops especially those in a UDF. Some...
--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 4:32 pm

#862335
RE: DEFRAG All Tables in a DB

By the way... DBCC IndexDefrag will allow the indexes to still be used while the index is in the process of defragging where DBCC DBReIndex will not. The big...
--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 4:15 pm

#862334

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