Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,631 through 48,645 (of 59,099 total)

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
RE: DEFRAG All Tables in a DB

Sergiy is correct... the "table" can't be defragged without a clustered index.
Now, with that in mind, you will, unfortunately, need a loop of some sort to get throgh all 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 24, 2008 at 4:11 pm

#862332
RE: How to replace a text

I guess a better question would be, how did the double quotes get there in the first place? Did you import some text-qualified CSV or something? If 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)

August 24, 2008 at 4:03 pm

#862331
RE: Denormalized table

Heh... thanks for the plug, BitBucket!
A way kind of backwards from Cross Tabs is shown in the following article...
http://www.sqlservercentral.com/articles/Test+Data/61572/
The method would allow you to concatenate all the stakeholders into 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 24, 2008 at 3:59 pm

#862330
RE: I need help to optmize the query performance

rbarryyoung (8/24/2008)
This is the same conclusion that I have come to over the past few months, Jeff. I would much rather rewrite a query straight from the Specs, than...
--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 3:36 pm

#862328
RE: I need help to optmize the query performance

Sagar (8/24/2008)
Thanks Everybody...
Sagar
You're welcome... but if you post the CREATE TABLE and data that I suggested, you might even get a tested example to play 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 24, 2008 at 3:27 pm

#862327
RE: Just For Fun: An Impossible Delete

John R. Hanson (8/21/2008)
These are Important Ideas even more so today, as Enterprise Data is growing. My concern with the solution is that you are inserting rows to 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 3:21 pm

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

Heh... the thing I absolutely "love" about the idea of ANSI standards is... if we all do it their way, there will be no need for competition amongst the makers...
--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 3:11 pm

#862324
RE: MIS in the UK

Heh... stop and look at it this way... you didn't get that old being stupid and employers who want some real talent in their ranks are beginning to realize 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)

August 24, 2008 at 11:33 am

#862305
RE: I need help to optmize the query performance

Sagar (8/24/2008)
code looks like below... also have another question as well... there are lots of temp table inside stored proc.. i was thinking of removing temp table and using...
--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:23 am

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

arjun.tewari (8/22/2008)
and its never about working or not working, everyone posting a solution will work but its always about finding a solution which IS MOST PERFORMANT.
Hey guys... Arjun is trying...
--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:00 am

#862297
RE: Query Help

Heh... I'm a little biased... please see the following articles on the subject of Tally tables and splits...
http://www.sqlservercentral.com/articles/TSQL/62867/
http://www.sqlservercentral.com/articles/T-SQL/63003/
For the problem at hand, the following works just fine...
First, create the Tally...
--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 9:43 am

#862296

Viewing 15 posts - 48,631 through 48,645 (of 59,099 total)