Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,896 through 35,910 (of 59,099 total)

RE: SUMs when joining one to many tables

Dugi (11/26/2010)
Yes I see, but you are doing the brilliant and perfect comparison and explanation using the current solutions!
Have a nice weekend buddy!
Greetings!
Ah... thanks, Dugi! I had to know...
--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)

November 26, 2010 at 1:05 pm

#1255887
RE: Inline Table Valued Function and Scalar Function Performance difference

sam_mastermind (11/26/2010)
Hi,
Recently i faced a question in an interview, which one is better regarding performance -
Inline Table valued function or scalar function (both are returning same output).
Can anyone help in...
--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)

November 26, 2010 at 1:00 pm

#1255886
RE: Automate "Generate Scripts" in SQL Job

bjhogan (11/26/2010)
Have you tried doing this through Powershell? You can easily access the the SQL Server SMO to script out the objects to a file. I hadn't 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)

November 26, 2010 at 12:54 pm

#1255882
RE: Cross Apply

rs80 (11/26/2010)
Gail, why would you get duplicate rows?
Non-techincal answer: When dirty reads are allowed, it is possible to read a row and then have someone update that row which...
--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)

November 26, 2010 at 12:49 pm

#1255879
RE: SUMs when joining one to many tables

Dugi (11/26/2010)
Jeff you are amazing, buddy... T-SQL simple works for you, really!
:w00t::hehe::cool:;-)
Nah... this one was all Andrew. I'm the one that posted the bad code this time. :blush: ...
--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)

November 26, 2010 at 12:47 pm

#1255878
RE: Need Help on performance Improvement

yatish.patil (11/26/2010)
Hello,
I need help on performance Improvement, I have large database where in i need to find the average days spend by one entity record. I have tried different ways,...
--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)

November 26, 2010 at 12:34 pm

#1255875
RE: SUMs when joining one to many tables

Here's the test code including more test data.
DROP TABLE #tableA;
DROP TABLE #tableB;
DROP TABLE #tableC;
--===== Create the test table with
CREATE TABLE #tableA
...
--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)

November 26, 2010 at 12:28 pm

#1255872
RE: SUMs when joining one to many tables

I believe the following will be faster and use fewer resources but we won't know for sure until we test with a whole lot more data.
SELECT a.conID, a.conName,
...
--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)

November 26, 2010 at 11:36 am

#1255862
RE: What is wrong with this query?

jonetiger (11/24/2010)
I can not find it, because I am new about it. I give you ans come back later.
cremated remains jewelry[/url]
Freakin' low life spammer. Spam reported.
--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)

November 26, 2010 at 11:13 am

#1255861
RE: Need to replace 0 with last non null value in view

vandana_j79 (11/26/2010)
Just wondering how can i see this in a view.
I know a View would certainly be convenient but, no matter how you slice it, the code to do it...
--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)

November 26, 2010 at 11:06 am

#1255859
RE: Need help writing the correct SQL

Jeff Moden (11/26/2010)
John Mitchell-245523 (11/26/2010)
Something like this. The INSERT statement will only work in 2008.
Gosh, John... this is an SQL Server 2000 forum. My rhetorical question is "Why...
--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)

November 26, 2010 at 9:43 am

#1255849
RE: Need help writing the correct SQL

John Mitchell-245523 (11/26/2010)
Something like this. The INSERT statement will only work in 2008.
Gosh, John... this is an SQL Server 2000 forum. My rhetorical question is "Why would 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)

November 26, 2010 at 9:42 am

#1255846
RE: How to Insert Million of records in less time ?

wu.wuqiang (11/26/2010)
Remove indexes before insertion, then recreate indexes.
That frequently does nothing for the amount of time it takes because reindexing can take a lot of time. In fact, if...
--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)

November 26, 2010 at 9:33 am

#1255843
RE: JOIN Question

Grinja (11/26/2010)
Hi Jef, that is correct.
The account belongs to Bob for period 200801 - 200802 and to Fred from 200803 onwards.
G
In that case, it looks like TommyH has the code...
--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)

November 26, 2010 at 9:26 am

#1255842
RE: Database Standards Parsing

I guess now is as good a time to mention it as any...
Code reviews (and unit testing... but that's a different subject) are super important to success. When 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)

November 26, 2010 at 8:57 am

#1255835

Viewing 15 posts - 35,896 through 35,910 (of 59,099 total)