Viewing 15 posts - 3,631 through 3,645 (of 7,499 total)
- The "inserted" and "deleted" (table) objects are only available in the trigger itself.
- The A in the code is the table alias for table F_articlewhere, meaning in that query...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 24, 2009 at 12:39 am
Indeed, perform full db maintenance
start with:
DBCC CHECKDB (0) WITH ALL_ERRORMSGS, DATA_PURITY;
go
print '' ;
print '*********************************'
print '**'
print '** If DBCC CheckDB returned DATA_PURITY errors, you must view http://support.microsoft.com/kb/923247 !!! and repair...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 23, 2009 at 1:25 pm
did you update your statistics ?
- sp_updatestats
- dbcc updateusage (0) with count_rows
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 23, 2009 at 1:21 pm
Just a little alternative to the above replies.
Maybe you can just create the backups on a local drive, in the last step of your local backup job, robocopy the .bak...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 23, 2009 at 1:18 pm
can you post the results of:
(sqlserver version info)
Select @@version
In the SSC article Mani Singh posted in the first the scripts are very visible to me.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 23, 2009 at 1:13 pm
There are two things with this/
1) the trigger supposes it will be fired after completen an update for single @cbmarq. If you update a table out of that "regular" oltp...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 21, 2009 at 12:59 pm
doing that with any clr proc will be at least 95% overhead !!
e.g.
create trigger trIU_mytable
as
begin
insert into myaudit_table
select 'I' as operation, *
from inserted
union all
select 'U' as operation
, *
from deleted
end
Doing...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 20, 2009 at 8:31 am
Great article Gail.
I'll add it to my forum signature :w00t:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 20, 2009 at 5:09 am
mick miller (6/19/2009)
: What happens if you execute that statement separately ?
: (is the error persistent ?)
When I run the query directly on the server, then I don't...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 20, 2009 at 12:52 am
First of all thank you for posting these mishaps and the work around.
We didn't encounter these problems when upgrading from sp2 cu2 to SP3 on our 2-node sql-cluster (multiple instances)....
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 19, 2009 at 5:06 am
I haven't encountered that kind of errormessage yet.
BOL nor KB contain an exact ref.
What happens if you execute that statement separately ?
(is the error persistent ?)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 19, 2009 at 1:07 am
Sorry for the alte response, I lost track of this thread :blush:
- In what way does your SRVDW(dom\sadb) differ from your other servers ?
- Are these databases in a lower...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 18, 2009 at 11:55 pm
Dean Jones (6/18/2009)
Sounds like a good idea, problem is that this means I will have to change 200 or so Procedures and I dont think this will get the seal...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 18, 2009 at 8:00 am
that depends on your needs !
Do you need an aircraft or a T-bone steak ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 18, 2009 at 7:24 am
- I haven't seen a grant exec to a certificate. :unsure:
- if you drop a proc, all related grants also vanish !
What you might do is :
1) create a db...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
June 18, 2009 at 7:23 am
Viewing 15 posts - 3,631 through 3,645 (of 7,499 total)