Jeff Moden

Forum Replies Created

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

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
RE: Select a string when data in the string varies

Hey folks (especially Wayne). I ran into a bit of a buzz saw with the new split function that I previously posted (and have removed from this thread). ...
--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:31 pm

#1153240
RE: Are the posted questions getting worse?

Heh.... famous last words would be... [font="Arial Black"]AHHHHH CRAP![/font]
Just so you guys know... remember I said that I changed my cteTally code to use Gianluca's wonderful idea of using UNPIVOT...
--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:22 pm

#1153236
RE: Semi colons

krypto69 (4/16/2010)
How can I remove the last semi colon from the list of names that gets created?
I want the semi colons between the names, just not at the end 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)

April 16, 2010 at 3:32 pm

#1153182
RE: Query 5000 Tables for data

sgj31 (4/16/2010)
I have a client that has 5000 customers and in the database each customer has a table.
dbo.Customer1
dbo.Customer2
...
dbo.Customer5000
I need an efficient way of reporting on these tables without looping through...
--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 3:29 pm

#1153180

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