Viewing 15 posts - 3,091 through 3,105 (of 7,499 total)
Yes, Yes, Yes ....
- master is a must !
- resource db files .... maybe ... so YES too ! but only once after every install/hotfix/cu/sp
- model ? 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
March 9, 2010 at 12:04 pm
I join Lynn in the advise !
sp_send_dbmail is the way to go !
Have a look in books online to see how (easy) sp_send_dbmail can serve you.
It has nice features (profiles,...
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
March 9, 2010 at 11:44 am
If I'm correct, the default trace isn't running by default in SQLExpress :sick:
You should enable it using sp_configure 'default trace enabled', 1
Same goes for the DAC.
If you want a...
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
March 7, 2010 at 1:25 pm
just curious ... can you share which solution you implemented ?
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
March 7, 2010 at 4:55 am
What other info can you provide ??
use master
select distinct req_transactionUOW from syslockinfo
Is SQLServer errorlog showing any related info ?
Is SQLAgent SQLAGENT.OUT showing any related info ?
Did your sqlinstance...
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
March 5, 2010 at 12:58 am
hmmm ... must be some of my bad habits 😉
I haven't used ranking functions that much, so they don't come loosely out of my sleeves :Whistling:
I still need to...
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
March 5, 2010 at 12:23 am
here's another version ...
Select *
from (
SELECT
rank () over( partition by IntTranID, IntLine order by IntTranID, IntLine , BrlDate DESC) as RNK
...
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
March 3, 2010 at 2:19 pm
The value for the top clause can be a variable .
So
Declare @mytop int
select @mytop = max(brlcount) from ...
select top ( @mytop ) ...
no dynamic sql needed !
You can...
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
March 3, 2010 at 12:10 pm
for authorization, being the actual dbowner or just member of db_owners db group is equal.
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
March 3, 2010 at 11:59 am
Thank you for the feedback.
So there must have been an error in the previous application of sp3.
On a rare occasion, we have also encountered this issue .... must have been...
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
March 3, 2010 at 3:09 am
blue_inelush (3/2/2010)
I can't believe that in all this time I've lived with the feeling that after the log backups, the .ldf file size...
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
March 2, 2010 at 7:14 am
1) avoid the xml ! it needs to be converted in a sql usable format every time you use it
2) You requested an update statement ...
Why would you need...
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
March 2, 2010 at 6:42 am
blue_inelush (3/2/2010)
My Production database is very intensive, so the .ldf file will increase and increase. In...
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
March 2, 2010 at 6:25 am
No a log backup only marks the log content "ready to be overwritten".
It will not shrink your transaction log file !
What is the result of DBCC OPENTRAN (to be...
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
March 2, 2010 at 5:33 am
write an update statement in stead of the delete / insert.
Keep in mind, you need to check if it actually updated a row (@@rowcount)
Because if it didn't, you'll have to...
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
March 2, 2010 at 5:31 am
Viewing 15 posts - 3,091 through 3,105 (of 7,499 total)