Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,881 through 38,895 (of 59,102 total)

RE: FizzBuzz

Stefan_G (4/18/2010)
Jeff Moden (4/18/2010)
The only thing I did was a SELECT/INTO using a triple cross join to create a Billion row table with just one column in it... "N".
And did...
--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)

April 18, 2010 at 3:22 pm

#1153512
RE: FizzBuzz

Stefan_G (4/18/2010)
Nonsense! The SQL Server does not materialize the entire triple cross join in memory. It generates the data dynamically as it is needed.
Try the query yourself if you dont...
--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)

April 18, 2010 at 2:04 pm

#1153503
RE: Nested Set vs Adjacency for Hierarchy

I know this is a really old post but did you ever get an answer for this?
--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)

April 17, 2010 at 9:32 pm

#1153436
RE: TSQL Lookup using BETWEEN (Ip Addresses)

As a side bar, if you use Master.sys.All_Columns instead of the "local" copy of sys.columns, then you can get 16 million rows out of a single Cross-Join with a bit...
--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)

April 17, 2010 at 4:44 pm

#1153405
RE: Continuing Education

Lynn Pettis (4/16/2010)
Jeff Moden (4/16/2010)
dma-669038 (4/16/2010)
Or perhaps better put would be - where do you find data to work on?? The majority problems i have enjoyed solving and learnt best...
--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)

April 17, 2010 at 4:36 pm

#1153403
RE: Continuing Education

Speaking of PASS, Grant... any idea when they're going to start a "Call for Speakers"?
--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)

April 17, 2010 at 4:31 pm

#1153402
RE: Convert Function

mister.magoo (4/17/2010)
(I was just about to post my reply when yours popped up Jeff - and it covers everything I was going to say...)
Heh... I finally beat someone to 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)

April 17, 2010 at 4:29 pm

#1153401
RE: Is Primary key clustered index different from Unique key clustered index??

Perry Whittle (4/17/2010)
Jeff Moden (4/17/2010)
Man, I was going to jump on this at the first post. Good thing I'm trying to read the whole thread before responding. Good...
--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)

April 17, 2010 at 4:13 pm

#1153398
RE: Is Primary key clustered index different from Unique key clustered index??

Steve Jones - Editor (4/17/2010)
That was a good catch. Looks like I need to write a good one pager on this and include all information
Heh... nah... it's one of my...
--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)

April 17, 2010 at 12:10 pm

#1153377
RE: High CPU

sandhyarao49 (4/16/2010)
Hello All,
I have faced the same issue again, stuck at the same SP, CPU is hitting 90-95 %.
Captured the execution plan for the statements executing , seems 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)

April 17, 2010 at 11:34 am

#1153373
RE: Optimization: Turning a series of entries into columns

huston.dunlap (4/16/2010)
lmu92 (4/16/2010)
In order to understand what you mean please provide sample data and expected results that actually show what you're struggling with.
Currently, it doesn't make that much sense (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)

April 17, 2010 at 11:18 am

#1153370
RE: Is Primary key clustered index different from Unique key clustered index??

Perry Whittle (4/17/2010)
when referring to key constraints
Primary key does not allow NULLs
Unique key allows a single NULL value
so the 2 are different in that respect
Man, I was going to jump...
--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)

April 17, 2010 at 10:43 am

#1153363
RE: Convert Function

vaibhav.tiwari (4/17/2010)
Except if sdate includes a time, in which case dates such as '16/04/2010 12:23:21' will not be returned
I am not getting please explain...
Sure... it boils down to that you...
--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)

April 17, 2010 at 10:22 am

#1153354
RE: Are the posted questions getting worse?

All right... I believe I've found all the places where I posted that code and have deleted it with an explanation. Needless to say, I'm a bit embarrassed. ...
--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)

April 16, 2010 at 6:39 pm

#1153243
RE: Insert Rows from a Parsed Field into Another Table

I ran into a bit of a buzz saw with the new split function that I previously posted (and have removed from this thread). It turns out that it'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)

April 16, 2010 at 6:35 pm

#1153242

Viewing 15 posts - 38,881 through 38,895 (of 59,102 total)