Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,366 through 37,380 (of 59,098 total)

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

mtillman-921105 (8/9/2010)
I just wanted to say "thank you" for this fascinating, even if to some extent, academic discussion on NULLs.
From a practical point of view, I think that they're more...
--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 9, 2010 at 8:09 pm

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

PaulB-TheOneAndOnly (8/9/2010)
In my opinion Zeros and Nulls are not the same and do not represent the same thing.
PAUL FOR PRESIDENT! 😀
--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 9, 2010 at 8:05 pm

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

mtillman-921105 (8/9/2010)
Actually, this breaks a cardinal rule in database design - we are using one column for more than one kind of data. It answers two questions: Was there 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)

August 9, 2010 at 8:02 pm

#1204466
RE: how generate series?

nosoyspam (8/9/2010)
Hi people,
How can do a procedure (or something ) that return me a list of numbers
example:
select nums
from generate_serie(5001, 5999)
and this return
f
------
5001
5002
5003
....
5999
What is the smallest start value 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 9, 2010 at 2:38 pm

#1204404
RE: export from csv file problem

Here's what I'm talking about. Let's say you have a file called "ImportTest.txt" on the server in the "C:\Temp" that looks like this...
,.BAM30,BELTONE A.M,,EGP,08/08/2010,"4,090.5","4,101.96",1.5,"1.5",,,,
,.BAM20,BELTONE A.M,,EGP,08/08/2010,"4,090.5","1.5","4,108.68","4,090.5",,,,
,.BAM10,BELTONE A.M,,EGP,08/08/2010,"4,090.5","4,101.96","4,108.68",1.5,,,,
,.BAM40,BELTONE A.M,,EGP,08/08/2010,1.5,"4,101.96","4,108.68","4,090.5",,,,
Try running 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)

August 9, 2010 at 9:53 am

#1204251
RE: export from csv file problem

steveb. (8/9/2010)
Bulk Insert in SQL sever does not support quoted text, a better option would be to use the import/export wizard or SSIS to import the file as...
--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 9, 2010 at 9:35 am

#1204238
RE: User Table

John Mitchell-245523 (8/9/2010)
If you want a permanent record of who did what and where then one way is to use DDL triggers to log activity such as this to 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)

August 9, 2010 at 7:30 am

#1204156
RE: Everybody Reports to Somebody

James Raddock (5/16/2008)
...with a sproc to generate the nested set as hierarchical data is needed (it's a cheap operation).
I know this is an old thread, but can you post 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)

August 8, 2010 at 8:24 pm

#1203973
RE: generate insert statements with data

drew.allen (8/7/2010)
Here's an example using the Information_Schema.Tables view. WARNING: XML is case sensitive
Thanks, Drew. Rumor has it that it's also pretty touchy about special characters like ampersands 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 8, 2010 at 7:24 pm

#1203972
RE: Poll to see how many people set Max Server Memory

Peter Samson (8/6/2010)
Jeff, you should be able to link to it here
http://community.sageaccpac.com/forums/t/1193.aspx
I'll have to agree with the others. I've not ever had to change this setting for performance. ...
--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 8, 2010 at 4:50 pm

#1203969
RE: Row to Column Conversion

Heh... I wonder if he learned to fish... or drowned. 😛
--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 8, 2010 at 5:49 am

#1203926
RE: Rows to Column

antonio.collins (4/3/2008)
unfortunately, this alternative requires a temp table since it doesn't seem CTEs can be nested.
I know it's an old post but what do you mean that CTE's can't be...
--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 8, 2010 at 5:44 am

#1203925
RE: Plzz help me in replacing the cursor with Normal Sql Statements

inampudianil (8/7/2010)
plzz it's very urgent......
Now that you have an answer, the next urgent thing is for you to lookup the UPDATE command in Books Online and teach your self how...
--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 7, 2010 at 7:44 pm

#1203901
RE: Embed the SPROC/script name in the SQL statement

Aw, duuuuude... I've read a couple of the "SQL Janitor" blog entries on that site... there's a whole bunch of things in there based on myth, misconception, or are just...
--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 7, 2010 at 3:06 pm

#1203886
RE: Embed the SPROC/script name in the SQL statement

Peter Samson (8/5/2010)
Write maintainable code - Embed the SPROC/script name in the SQL Statement
Heh... that's nice, Peter, but if you're going to SPAM us with such a thing, 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)

August 7, 2010 at 2:41 pm

#1203882

Viewing 15 posts - 37,366 through 37,380 (of 59,098 total)