Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,336 through 37,350 (of 59,072 total)

RE: Are the posted questions getting worse?

CirquedeSQLeil (8/9/2010)
Chris Morris-439714 (8/9/2010)
Brandie Tarvin (8/9/2010)
Is it wrong to cry when someone tells me they don't know what Bulk-Logged is?
http://www.sqlservercentral.com/Forums/Topic961511-146-2.aspx#bm966015
It's a forestry expression.
That is scary - check the timestamps 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 9, 2010 at 8:54 pm

#1204476
RE: Are the posted questions getting worse?

Dave Ballantyne (8/9/2010)
Woot woot , just got my speaker selection email for sqlbits. Time to get some material together now..
Congratulations and I understand the EXCITEMENT!!!!! :-P;-):-P;-) I...
--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:52 pm

#1204475
RE: SQL subquery WHERE IN clauses

CELKO (8/9/2010)
>> I have this problem: <<
No, you have a lot of conceptual problems. You do not know the correct terms for RDBMS and SQL, or how do a data...
--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:49 pm

#1204474
RE: SQL subquery WHERE IN clauses

blackbird (8/9/2010)
Why are you using a WHERE IN instead of an INNER JOIN? Generally the INNER JOIN has a better performance and looks cleaner. 🙂
I'd post my code that shows...
--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:34 pm

#1204472
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

Viewing 15 posts - 37,336 through 37,350 (of 59,072 total)