Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,291 through 37,305 (of 59,098 total)

RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Alain Rastoul (8/17/2010)
Hi Jeff,
Here you'll find 3 papers from E.F.Codd ,
A Relational Model of Data for Large Shared Data Banks
http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.98.5286&rep=rep1&type=pdf
Extending the Database Relational Model to Capture More Meaning
http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.84.9469&rep=rep1&type=pdf
RELATIONAL COMPLETENESS 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)

August 17, 2010 at 8:13 am

#1207894
RE: The Multi-valued Parameters problem in Reporting Services

gary.bland (8/16/2010)
Thanks Jeff for your help! Code working pretty well. Only issue I'm having is getting one parameter to be dependent on the other in a stored proc that populates...
--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)

August 16, 2010 at 8:20 pm

#1207636
RE: MCJ - The Missing Link

dma-669038 (8/16/2010)
Jeff, thank you for teh timely reminder, i will check the site tonight and post some responses. I am not sure how much time i have (much less than...
--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)

August 16, 2010 at 8:13 pm

#1207634
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/16/2010)
I think the SQL Rally is designed to "try" some things out that don't happen at the Summit, and get more speakers there. Personally I'd 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)

August 16, 2010 at 7:58 pm

#1207633
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

mtillman-921105 (8/16/2010)
I was a philosophy major (and a psychology major by the way), so I started reading my book on elemetary logic about empty sets over the weekend. Now here...
--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)

August 16, 2010 at 7:46 pm

#1207631
RE: Are the posted questions getting worse?

Does anyone know what's up with the upcoming SQL Saturday in Minnesota? I see no speakers and no sessions. I've sent emails asking what's up and have gotten...
--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)

August 16, 2010 at 7:02 am

#1207318
RE: Are the posted questions getting worse?

Jack Corbett (8/16/2010)
GilaMonster (8/16/2010)
Jeff Moden (8/14/2010)
I believe I'll submit the whole grass roots gambit next year... Triangular Joins, Tally Table, Cross Tabs, Quirky Update (and other ways to avoid cursors),...
--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)

August 16, 2010 at 6:59 am

#1207316
RE: Turn a Bad Job into a Good Experience

Perfect and well said. I had one job where I quite literally did just about everything for the company from learning how to run a letter folding machine 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)

August 15, 2010 at 10:08 pm

#1207145
RE: Compare Records in Table On coloumns

vrkn82 (8/15/2010)
I have a table with 5 columns. My requirement is if record in each column is equal to one 1 then it has to print true or it should...
--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)

August 15, 2010 at 9:43 pm

#1207142
RE: Compare Records in Table On coloumns

bitbucket-25253 (8/15/2010)
Is this what you require?
CREATE TABLE #T(C1 INT, C2 INT, C3 INT, C4 INT, C5 INT)
INSERT INTO #T
SELECT 1,1,1,1,0 UNION ALL
SELECT 1,1,1,0,1 UNION ALL
SELECT 1,1,0,1,1 UNION ALL
SELECT 1,0,1,1,1 UNION...
--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)

August 15, 2010 at 9:41 pm

#1207141
RE: Alter PK to Cluster

jeff.mason (8/9/2010)
Yep, this is why I NEVER use PRIMARY KEY CLUSTERED even IF I intend to cluster on that column. I am willing to burn the index space 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)

August 15, 2010 at 9:36 pm

#1207140
RE: View performance

Dave Hoogendoorn (8/15/2010)
Hi There,
Changing the query to explicit INNER JOINs with ON statements might prevent improper execution plan.
In your current query, their might be a possibility that SQL first joins...
--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)

August 15, 2010 at 9:25 pm

#1207137
RE: Sql Query to extract the data.. Need Help...

Rajiv Kumar (8/14/2010)
I have table name employee with following fields -
EmpID Name ManagerID
against each employee, manager id is avaiable and a manager is also an employee...
i need a sql...
--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)

August 15, 2010 at 9:22 pm

#1207136
RE: Sql Query to extract the data.. Need Help...

Rajiv Kumar (8/14/2010)
I have table name employee with following fields -
EmpID Name ManagerID
against each employee, manager id is avaiable and a manager is also an employee...
i need a sql...
--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)

August 15, 2010 at 9:20 pm

#1207135
RE: How to do Dynamic counts!

To answer your question, "Yes".
To solve your problem, please see the following. Post back if you have questions but try the code first... you can do some amazing stuff...
--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)

August 15, 2010 at 9:06 pm

#1207134

Viewing 15 posts - 37,291 through 37,305 (of 59,098 total)