Forum Replies Created
Viewing 15 posts - 166 through 180 (of 7,498 total)
Reply To: Wrong frames in blocked process report
waitresource="PAGE: 14:1:5803256 "
Blocking spid="298"
Blocked spid="93"
use SP_WHO2 to figure out these connections
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
Reply To: What is a Tail-Log Backup failure?
Actually, if you restore the backup to an instance as a new database, there is no need for a tail-log backup at all !
( this is a flaw in the...
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
Reply To: Wrong frames in blocked process report
You've messed up the xml to much !
It doesn't produce a garph anymore !
Use dummy names ( T123 / t124 / ... ) instead of "<table name>" as < and...
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
Reply To: Wrong frames in blocked process report
can you share the xml?
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
Reply To: What is a Tail-Log Backup failure?
A tail-log backups only purpose is that you can restore the original database as is was on the target server right before you performed the intended restore.
What's the difference with...
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
Reply To: FIFO and manufacturing ... how do I get the current cost?
I requested it to write the TSQL DDL to created the needed tables based on your input.
It came up with this. ( not perfect, but it gets you started ) Johan Dont drive faster than your guardian angel can fly ... - How to post Performance Problems - 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
Learn to play, play to learn !
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post data and code to get the best help
Reply To: FIFO and manufacturing ... how do I get the current cost?
fwiw - post this question as input for copilot . microsoft . com and add "Write the tsql stored procedure to process my expenses report per batch"
See what it comes...
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
Reply To: Linked server and trouble between manager and agent
Keep in mind, everybody that can use the linked server, will have the authority of the given "rmtuser" !
That's the reason I only allow read-only accounts to be used 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
Reply To: Linked server and trouble between manager and agent
How did you define the security to be followed when using this linked server ?
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
Reply To: Azure SQL DB CLR
even on SQLMI there are restrictions for CLR stuff: 
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
Reply To: What is causing this error?
is your user profile stored with remote as primary ?
( = wrong implementation of a great concept )
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
Reply To: SQL2019 Extended Events missing EVENT debug_channel and EVENT sqlsni.trace ?
indeed. Thank you for pointing the subtle difference.
Tried it.
Didn't provide the data I aimed for.
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
Reply To: SQL2019 Extended Events missing EVENT debug_channel and EVENT sqlsni.trace ?
It did generate the same error as the debug channel at create time.
However, now I see it accepts the create of the event session.
Time to investigate ( for a short...
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
Viewing 15 posts - 166 through 180 (of 7,498 total)