Jeff Moden

Forum Replies Created

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

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
RE: I need help to optmize the query performance

Sagar (8/23/2008)
Can someone help to how to remove the cursor. when i look at the stored proc most of the stored proc are using cursor. I also figuered...
--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:16 am

#862294
RE: MIS in the UK

It sounds like they don't really know databases at all because they don't really understand that SQL is not SQL and that taking care of the servers for different RDBMS's...
--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 8:51 am

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

Very cool feedback, Rog. Thanks.
You better believe that even a simple subquery is beyond many users. I hope you understand where I'm coming from. How to make this stuff...
--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 8:45 am

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

dphillips (8/20/2008)
When one wants no NULLs in the output, is it not faster to put that in the base FROM "derived table", view, or query... the same as mentioned when...
--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 23, 2008 at 6:20 pm

#862268

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