Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,011 through 50,025 (of 59,091 total)

RE: Eliminating Cursors

Oh no... Correlated sub-queries and their equivelant of Cross Apply are nothing more than a form of hidden RBAR which is usually as slow as a cursor and sometimes slower...
--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)

June 16, 2008 at 6:15 am

#829149
RE: Do You Want to Be Right?

"If we let our employer know of the trade-off between delivery schedule and future-proofing/performance tweaking, they can make an informed decision."
I've found that that usually takes more time than just...
--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)

June 16, 2008 at 6:11 am

#829146
RE: Can I concat a varchar column on a group by clause

Please see the following to get the best performance out of a concatenation function...
http://www.sqlservercentral.com/articles/Test+Data/61572/
--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)

June 16, 2008 at 5:56 am

#829137
RE: How to find last accessed Date of a database ??? on sql server 2000

michaela (6/15/2008)
You would have to monitor your dbs access for a certain period; there is not a straight way to "select last transaction date" from a db.
What I would do:...
--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)

June 15, 2008 at 8:08 pm

#829044
RE: Parse delimited data in column to multiple columns

Sorry folks... I've repaired the link that BitBucket was talking about and I've also included it here...
http://www.sqlservercentral.com/articles/TSQL/62867/
--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)

June 15, 2008 at 7:28 pm

#829040
RE: How to find last accessed Date of a database ??? on sql server 2000

Ummm.... SysProcesses has a DBID column...
--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)

June 15, 2008 at 7:21 pm

#829038
RE: Read print output from within a stored procedure by calling another

kinnon_2000 (6/15/2008)
I dont know of a sql server query that could concatinate multiple fields from a tabe, as a join, into a single field. Can that be done?
Absolutely... see...
--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)

June 15, 2008 at 5:33 pm

#829033
RE: SAN Storage

"Clustered DB Files"??? :blink:
--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)

June 15, 2008 at 5:16 pm

#829030
RE: SQLServer 2005 on VMWARE

Virtual Machine is software that looks like hardware. Do you think software will ever be as performant as hardware? 😉
--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)

June 15, 2008 at 5:15 pm

#829029
RE: Read print output from within a stored procedure by calling another

Sure... let's shed some light on this... this sounds like you're processing one row at a time... That's RBAR and that's a mistake. 😉
--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)

June 15, 2008 at 5:10 pm

#829028
RE: Inline Function

In fact... it doesn't even have to refer to a table to be RBAR... and split function based on a While loop is a form of RBAR and performance can...
--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)

June 15, 2008 at 5:07 pm

#829027
RE: Inline Function

Bottom line is, if the function, inline or not, refers to a table, it's a form of RBAR that may have a significant impact on performance whether the execution plan...
--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)

June 15, 2008 at 5:04 pm

#829026
RE: Using VBA to pull SQL data into Excel?

rbarryyoung (6/15/2008)
On the other hand, if your sheets need to be resized based on the number of rows returned, then automated "Get External Data" refreshes can be pretty hard 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)

June 15, 2008 at 5:02 pm

#829025
RE: Concatenate Results Into A Single Field

Then the XML solution will work.
Just curious... why did you post on a 2k forum instead of a 2k5 forum? Folks wouldn't have wasted their time 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)

June 15, 2008 at 4:55 pm

#829024
RE: Parse delimited data in column to multiple columns

BitBucket... I've got 100 PM's that I really want to keep. Steve hasn't come up with a way to download them, yet. Send me an email...
--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)

June 15, 2008 at 4:47 pm

#829023

Viewing 15 posts - 50,011 through 50,025 (of 59,091 total)