Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,961 through 39,975 (of 59,102 total)

RE: Today's Random Word!

Handrails
--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)

February 4, 2010 at 9:38 am

#1113827
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Some interesting posts there, folks. I have to delay participation until after I get home from work tonight.
--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)

February 4, 2010 at 8:49 am

#1113798
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Hugo Kornelis (2/4/2010)
Hi Jeff,
As indicated in my previous message, I somehow lost sight of this discussion. Sorry for my sudden disappearance from this topic.
First, thank you for optimizing my alternative...
--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)

February 4, 2010 at 6:18 am

#1113687
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

tony rogerson (2/4/2010)
Cursor is imho the best approach for this because you can put an ORDER BY - you have repeatable results with syntax that is well defined in terms...
--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)

February 4, 2010 at 5:55 am

#1113665
RE: Coding By The Sea

There are a lot of people at work that I get along with really, really well and we've all had some great times together both at work and outside 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)

February 4, 2010 at 5:22 am

#1113641
RE: Keeping It All In Memory

Instrumented data collection apps, especially in the medical and device control fields, would greatly benefit from IMDB instances as well.
--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)

February 4, 2010 at 5:10 am

#1113635
RE: T-SQL Stored Proc calling T-SQL Function

Lynn Pettis (2/3/2010)
mark.veitch (2/1/2010)
Thank you very much Lowell. Just had a quick scan and although this is new to me I'm thinking it might be a possibility. About...
--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)

February 3, 2010 at 9:40 pm

#1113439
RE: Column With Multiple Values

If the data is actually as you say it is, then using Wayne's good test data, you can cheat like hell 😉
-- notice how a table is defined (DDL) and...
--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)

February 3, 2010 at 9:15 pm

#1113427
RE: convert flat file (.cvs) to SQL Server 2005 using SSIS

Ummmm.... isn't there a text qualifier setting that can be enabled?
--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)

February 3, 2010 at 9:08 pm

#1113423
RE: Hardware requirements

David Lester (2/3/2010)
Thank you all for the tips and suggestions. It is good to see that there are others who, like me, think the hardware is cheap enough at 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)

February 3, 2010 at 9:05 pm

#1113419
RE: sql saturday and PASS mariage news

Steve Jones - Editor (2/3/2010)
We gave the SQLSaturday event and infrastructure to PASS. I'm sure they'll announce it at some point today or tomorrow.
http://www.sqlservercentral.com/blogs/steve_jones/archive/2010/02/02/sqlsaturday-bequeathed-to-pass.aspx
We are hoping PASS will continue 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)

February 3, 2010 at 9:00 pm

#1113416
RE: Extreme SSIS Newbie needs help with a super simple conditional insert

Dan Guzman - Not the MVP (2/3/2010)
PS Jeff, someday I'll post my real world 'I bet you can't get rid of this cursor/while loop' stumper
I'd imagine that a lot...
--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)

February 3, 2010 at 8:58 pm

#1113415
RE: INT to Bit

As a side bar, I don't use the BIT datatype for the most part. A single bit still takes a byte to store it and you can't so SUM...
--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)

February 3, 2010 at 8:53 pm

#1113413
RE: SQL Script

gsanthosh84-663713 (2/3/2010)
Hi,
Below is the data in my table
MarketQtrWeek % Over %Change
HD Q1'09 1 3.91% 3.91%
HD ...
--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)

February 3, 2010 at 8:50 pm

#1113412
RE: Table truncation

As a side bar, you don't need to actually drop the constraints... you can disable them with ALTER TABLE and NO CHECK.
--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)

February 3, 2010 at 8:43 pm

#1113411

Viewing 15 posts - 39,961 through 39,975 (of 59,102 total)