Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,516 through 31,530 (of 59,101 total)

RE: Doing inserts within a select statement?

erikpoker (1/4/2012)
Hello,
Im selecting values from a table a:
SELECT a.col1, a.col2, a.col3, a.foreignkey-value
FROM mytable a
WHERE something=something
If the foreign-key-value is null i would like to insert it into the parent table on...
--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)

January 4, 2012 at 5:40 am

#1428224
RE: Problem during inserting row in a table ( sql server 2005)

kumar.sachu08 (1/4/2012)
Hi all,
I have 1 TB data in my database & I have only one table in my database
where more than 10 lacs data are available.
When i am going 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)

January 4, 2012 at 5:24 am

#1428210
RE: Do a project needs a seperate team for SQL?

Dev (1/3/2012)
Jeff Moden (1/3/2012)
MysteryJimbo (1/3/2012)
Jeff Moden (1/3/2012)
There's also a matter of timing here. I've found that if you start the database development before you start any 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)

January 4, 2012 at 5:17 am

#1428205
RE: Do a project needs a seperate team for SQL?

EdVassie (1/4/2012)
Most SQL code can be written by anyone in the sprint team.
Gosh... I've worked in shops that have taken that stance. Unless they generally keep things...
--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)

January 4, 2012 at 5:14 am

#1428202
RE: Calling Stored Procedure in Select Statement

faijurrahuman17 (1/4/2012)
Dear All;
I am doubt for calling the SP with in the select Query
This is my sample procedure
EXEC [NmStudent] '07UF','10','100','0707'
Here will return the list of result List 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)

January 4, 2012 at 5:03 am

#1428191
RE: Query Question

William Krupinsky JR (1/3/2012)
Hello all, I hope I explain this correctly. I need to figure out how to query my DB to get a certain result set back. ...
--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)

January 4, 2012 at 4:56 am

#1428186
RE: if i need a column to hold a guid value which type should it be?

My recommendation is that, while UniqueIdentifier and GUIDs certainly have their good uses, they should probably never be used as a Clustered Index. Further, yes, they can be used...
--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)

January 4, 2012 at 4:48 am

#1428180
RE: How to find and remove duplicate field values from a table?

shatrughna (1/3/2012)
Can you post some sample data?
And it actually has more than 10 rows of test data. Nicely done, Jason.
--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)

January 3, 2012 at 11:01 pm

#1428095
RE: Truth and Demos

It IS a very small world, indeed. Good article, Steve. Thanks.
--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)

January 3, 2012 at 10:51 pm

#1428090
RE: Do a project needs a seperate team for SQL?

MysteryJimbo (1/3/2012)
Jeff Moden (1/3/2012)
There's also a matter of timing here. I've found that if you start the database development before you start any of the front end development, 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)

January 3, 2012 at 6:15 am

#1427680
RE: Insert slower than update

Dev (1/3/2012)
chandan_jha18 (1/3/2012)
Dev (1/3/2012)
chandan_jha18 (1/3/2012)
Jeff Moden (1/3/2012)
Actually, it's "expected" behaviour. An INSERT will "touch" on all indexes. An UPDATE might not even "touch" any...
--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)

January 3, 2012 at 6:10 am

#1427677
RE: Insert slower than update

Actually, it's "expected" behaviour. An INSERT will "touch" on all indexes. An UPDATE might not even "touch" any of the indexes.
--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)

January 3, 2012 at 5:29 am

#1427649
RE: Do a project needs a seperate team for SQL?

There's also a matter of timing here. I've found that if you start the database development before you start any of the front end development, you end up with...
--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)

January 3, 2012 at 4:56 am

#1427638
RE: Pros and cons of six SQL table tools

I think you meant "PK", not clustered index which can, of course, be different.
Absolutely understood on the concerns over SELECT/INTO. I've build some huge tables with it over many...
--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)

January 3, 2012 at 4:52 am

#1427634
RE: Query Tuning

440692 I am just a number (1/3/2012)
Jeff Moden (12/28/2011)
To be sure, I made a terrible mistake. [font="Arial Black"]ISNULL isn't SARGable.[/font]
That is just a perspective thing.
Your 'terrible mistake' challenged something 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)

January 3, 2012 at 4:46 am

#1427632

Viewing 15 posts - 31,516 through 31,530 (of 59,101 total)