Viewing 15 posts - 361 through 375 (of 378 total)
Play with my test code and it might help explain some things. But best ofcourse is to have a test database online somewhere that is accurate in modeling and in...
November 28, 2008 at 8:39 am
I did some test myself and using the test tables Jeff Moden created. I made a function that is not RBAR and beats both compared solutions on my server bigtime....
November 28, 2008 at 8:10 am
Jeff Moden (11/27/2008)
November 28, 2008 at 4:36 am
This changed the run time of the query from about a minute to a few seconds. So this shows that a RBAR table valued function can be much more efficient...
November 27, 2008 at 10:03 am
Adam Machanic (11/26/2008)
I also seen solutions (and I am still using one, but looking for a way out) that use 'master.sys.All_Columns' as a seed table and generate numbers using the...
November 26, 2008 at 8:20 am
Also, a DBA should know what tables will have a non-interrupted PK and use those instead of others that may have had deleted records.
Besides the point that you cannot be...
November 26, 2008 at 4:18 am
Richard Hill (11/26/2008)
I have a database with a table that already contains a PK with enough...
November 26, 2008 at 3:41 am
Could you not just us the PK of a large table that already exists int the database instead, seems to work for me in 99% of cases.
That "sort of" works...
November 26, 2008 at 3:17 am
jacroberts (11/25/2008)
Adam Machanic (11/25/2008)
Anyone can take any example and change it so it performance is important.
You're absolutely right! Why do you suppose that it happens to be so easy?
Is...
November 25, 2008 at 11:25 am
Performance might not always be critical, but it is and should always be an issue for anything but a known to be 'short' ad-doc operation. It is good practice to...
November 24, 2008 at 7:17 am
jacroberts (11/24/2008)
e.g.:
CREATE FUNCTION [dbo].[Nums]
(
@StartNum int,
@EndNum int
)
RETURNS...
November 24, 2008 at 6:12 am
Heh,
As I said, that one comment that got me going beserk was not in line with the rest, and yes, I am indeed looking forward to the follow ups!
November 24, 2008 at 3:19 am
If I sound harsh in this post, thats is because I am. One of your first comments is about something that I feel is deeply wrong with the role of...
November 19, 2008 at 5:02 am
I think price/Performance is the most important from a business point of view.
As with some other posters I have not been involved in the kind of consistent huge loads that...
October 3, 2008 at 8:19 am
As I should, I will do some thorough testing with a recognizable real world problem. It will take me a few days before I can do so and am already...
September 30, 2008 at 6:15 am
Viewing 15 posts - 361 through 375 (of 378 total)