Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,516 through 46,530 (of 59,095 total)

RE: Order by numbers in proper sequence

dejanette.gordon (12/18/2008)
It sure is...it can be downright grueling and discouraging for a newbie if one takes it personally. But hey, my post was kind of simple and "cheesy" based on...
--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)

December 18, 2008 at 6:40 pm

#914945
RE: Query to fill in missing dates in a series of rows

bnordberg (12/18/2008)
The data in this format will allow for contract tracing of MRSA infections. Our statisticians can pipe this through some algorithims in SAS to see if we can't find...
--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)

December 18, 2008 at 11:38 am

#914796
RE: Query to fill in missing dates in a series of rows

Chris Morris (12/18/2008)
Jeff, I was hoping you'd take the bait...proof of concept is one thing, turning prototype code into 'nasty fast' production code is entirely another. My query will not...
--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)

December 18, 2008 at 11:37 am

#914792
RE: Query to fill in missing dates in a series of rows

bnordberg (12/18/2008)
The data in this format will allow for contract tracing of MRSA infections. Our statisticians can pipe this through some algorithims in SAS to see if we can't find...
--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)

December 18, 2008 at 9:06 am

#914652
RE: Query to fill in missing dates in a series of rows

bnordberg (12/17/2008)
Thanks Chris!
that appears functional. Now to tune and see how it works with a few hundred million rows!
Are you sure it works? When I run it, I only...
--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)

December 18, 2008 at 9:04 am

#914646
RE: How do you archive data?

Gabe (12/18/2008)
3) The clustered index must also be the partition key.
I would say that's only true for things that are temporal in nature. If the partitions are based on...
--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)

December 18, 2008 at 8:44 am

#914624
RE: Are the posted questions getting worse?

r.hensbergen (12/18/2008)
You know both internet and SQL Server are international? On forums like these people visit from all over world.
Nah... really? I thought the internet was just the U.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)

December 18, 2008 at 8:18 am

#914584
RE: Are the posted questions getting worse?

ALZDBA (12/18/2008)
Jeff Moden (12/18/2008)
... we now have two national languages just due to immigration.
Due to WWII we have 3 official languages 😉
Heh... due to WWII, we only had one, until...
--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)

December 18, 2008 at 8:10 am

#914574
RE: Updating Values Without Cursor

Now there's a milestone... thanks for the feedback on this, Parul...
--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)

December 18, 2008 at 7:47 am

#914550
RE: Are the posted questions getting worse?

Ninja's_RGR'us (12/18/2008)
There's a question, it's just not obvious.
The guy abviously has troubles with the english written language. Nothing to be made fun of guys!!!!!!1
Actually, there is... it's people like...
--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)

December 18, 2008 at 7:16 am

#914514
RE: The Full Potential of SQL 2000

sausage.dog (12/17/2008)
People scoff at the idea of buying bigger hardware but as you point out it's cheap. Oftentimes it's far cheaper than paying a team to optimise (read: rewrite) large...
--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)

December 17, 2008 at 11:54 pm

#914313
RE: Guest Editorial: On writing SQL

gcopeland (12/17/2008)
Jeff Moden (12/17/2008)
Ooooohhhh, I so disagree with that... the customer almost never includes performance and scalability requirements in any quantifiable manner... but they do get awfully ticked when it...
--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)

December 17, 2008 at 11:48 pm

#914309
RE: Add a character, or expand to non-printable?

RBarryYoung (12/17/2008)
Jeff Moden (12/17/2008)
Also, have you given any thought to using a hybrid of the Nested Set Model instead of the Adjacency Model you're currently using?
Actually, Jeff, I believe 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)

December 17, 2008 at 11:42 pm

#914307
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

psmg01 (12/17/2008)
Hi Jeff,
Thank you for your reply.
I will post this in T_SQL forum too.
I am having a table like below
[CREATE TABLE [dbo].[Output_Info](
[Common_Id] [int] NOT NULL,
[Signal] [real] NOT NULL,
[Detect] [nchar](10)...
--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)

December 17, 2008 at 11:38 pm

#914304
RE: Discovering Gaps in Identity Column

Way cool... finally, a good use for such a thing. Might I suggest you "baseline" the table by saving the output of the query I gave you in 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)

December 17, 2008 at 11:30 pm

#914302

Viewing 15 posts - 46,516 through 46,530 (of 59,095 total)