Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,511 through 45,525 (of 59,095 total)

RE: SQL 2005 Ad-hoc reporting

Excel... with pass through queries to views in the database.
--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)

January 27, 2009 at 8:04 pm

#933592
RE: Solving the “Running Totals” Problem in SQL Server 2005 with Partitioned Tables

I guess I should first say thank you for the wonderful acknowledgements. Thanks, Lynn.
It's also a real pleasure to read an article with a logical progression and a whole...
--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)

January 27, 2009 at 7:54 pm

#933590
RE: Are the posted answers getting worse?

GilaMonster (1/26/2009)
Jeff Moden (1/26/2009)
The backup to such a "break" for the quirky update method is that the ORDER BY method also works although it works at about half the speed....
--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)

January 27, 2009 at 7:13 pm

#933586
RE: Temp Tables vs. Physical Tables

ALZDBA (1/25/2009)
general performance guidelines can be found overhere http://support.microsoft.com/kb/110352/
Wow... they don't write 'em like that anymore.
--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)

January 27, 2009 at 7:05 pm

#933585
RE: SMO vs SQL-DMO

Heh... WOW! C-O-F-F-E-E N-E-E-D-E-D H-E-R-E! 😛
--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)

January 27, 2009 at 6:47 pm

#933583
RE: Calling VBScript or command file from within T-SQL without xp_cmdshell??

You still haven't answered my question... what does the VB Script do? Also, which direction is the BCP in?
--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)

January 27, 2009 at 6:46 pm

#933582
RE: percentile in SQL Server 2005

Go back and look at my previous post... problem is NOT in the rowcount... it's how you're doing the math. Integer math will only yield integers and you need...
--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)

January 27, 2009 at 6:43 pm

#933580
RE: SQL or Oracle

Heh... there are some places in Oracle that require RBAR... try writing a set based trigger in Oracle sometime... 😛
--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)

January 27, 2009 at 6:29 pm

#933578
RE: Finding out UnUsed/sleeping indexes by srihari nandamuri

GilaMonster (1/27/2009)
Jeff Moden (1/26/2009)
Also, will that snippet of code tell you if the index was used as a SEEK or SCAN?
The query, as written won't. The DMV includes that info...
--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)

January 27, 2009 at 6:23 pm

#933576
RE: Risk and Assumptions

I actually believe it was just the opposite... I think it was severe over confidence... why else would the prices on houses have gone so high? Gas prices 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)

January 27, 2009 at 6:15 pm

#933574
RE: Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

I don't know which would be preferred, which is why I didn't dupe check them into oblivion.
--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)

January 27, 2009 at 6:08 pm

#933572
RE: How can you supress the dash line in the output

Steve Berry (1/27/2009)
The output is created by a series of select statements, as sample is shown bellow:
--Output Report Master Header
set @output = 'Weekly Stock Report - Year '+ @yearcode +...
--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)

January 27, 2009 at 5:58 pm

#933568
RE: Inner and Outer Loop to add count to existing table data

Thanks for the info... just trying to understand so we can do this in as high a performance method as possible...
In your original post on this thread, you have (obviously)...
--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)

January 27, 2009 at 6:33 am

#933134
RE: Hidden RBAR: Triangular Joins

Thanks David... the article was first published over a year ago. Seems like some different folks jumped in this time and dang near doubled the length of the comments....
--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)

January 27, 2009 at 6:24 am

#933129
RE: Passing number of rows to be returned as a SP parameter

Can't tell... not enough information. You need to prove to yourself that you're passing something besides a null or a negative number for pages, pages, and rows per page....
--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)

January 27, 2009 at 6:20 am

#933128

Viewing 15 posts - 45,511 through 45,525 (of 59,095 total)