Viewing 15 posts - 436 through 450 (of 465 total)
Matthew Darwin (5/11/2012)
May 11, 2012 at 6:39 am
So far, in my experience, the solution which has performed quickest for this kind of operation is the self join with a proper covering index, it just always seems to...
May 11, 2012 at 6:24 am
You can look up ROW_NUMBER, RANK, DENSE_RANK functions in Books Online or Google
I am sure you will get lots of articles and examples on the same which can't be provided...
May 11, 2012 at 6:20 am
I tried it and I do get only three rows, but what determines which one is returned by the RowNumber function? Or rather, what does the RowNumber function mean? It's...
May 10, 2012 at 3:21 pm
Thanks, Coffee, I did run across some examples on the web using 'OVER', but didn't really understand them. Your example looks quite clear - I will study it and try...
May 9, 2012 at 1:14 pm
Good point about the duplicate maximums - I hadn't thought of that. It can't happen in this dataset, but in the general case it's certainly a possibility. I suppose you're...
May 9, 2012 at 11:10 am
Thank you, Gazareth, I do know something about indexing and such. If I get stuck on that, I'll start a new post. My question was about the -CONCEPT- of whether...
May 9, 2012 at 10:23 am
Stephanie Giovannini (4/12/2012)
Try adding SET NOCOUNT ON in the top of the trigger body.http://stackoverflow.com/questions/4982403/sql-server-update-trigger-not-unique-insert-issue
That did it (bowing and scraping in admiration) - of course, now I feel like an idiot,...
April 12, 2012 at 1:55 pm
Lowell (4/12/2012)
the trigger has no WHERE statement, and never references inserted or joins to the remote table...does that remote table only have one row?
Yes, sorry, I should have noted that....
April 12, 2012 at 12:36 pm
Lynn Pettis (4/12/2012)
Any triggers on the other table? If so, could you post it also?
No, the only trigger is the one I posted. It updates the DateLastChanged (DatumPosledniZmeny) field...
April 12, 2012 at 11:39 am
Lynn Pettis (4/12/2012)
Any error messages? If so, the complete error message(s) would be helpful.
Yes, that was in my initial post:
"The row value(s) updated or deleted either do not make...
April 12, 2012 at 11:34 am
Lynn Pettis (4/12/2012)
Yes, post the definitions. We can't answer your question(s) when we can't see what you see.
Okay, here they are.
The trigger in A:USE [PaleoDataProPokusy]
GO
/****** Object: Trigger [dbo].[tr_DatumZmenyPaleontologie]...
April 12, 2012 at 10:51 am
SQLRNNR (2/28/2012)
InOverYourHeadBase
Boy, do I have the corner on those.
February 29, 2012 at 1:32 pm
Interesting idea. What all parameters of these constructs should be part of the descriptive vocabulary? Size, speed, complexity, efficiency, stability, level of automation, time in service, scalability, maintainability, hardware environment,...
February 25, 2012 at 1:06 pm
homebrew01 (2/10/2012)You can quickly & easily set up maintenance plans to do frequent full and transaction log backups. That will get you out of the "manual" business and give...
February 11, 2012 at 5:21 am
Viewing 15 posts - 436 through 450 (of 465 total)