Viewing 15 posts - 1 through 15 (of 66 total)
Yeah thanks I tried that but it didnt seem to be sending the other user to the resource pool, this could be because the job in question runs under a...
May 26, 2022 at 5:03 pm
A piece of code , not a stored procedure but kicked off by an app at wrong time of day and no idea how to turn off from app.
Could...
September 23, 2021 at 9:23 pm
its a temporary solution to an unavoidable issue of blocking ....don't want to kill all sessions blocking just this one running this code. If anyone knows how to script it...
September 23, 2021 at 7:50 pm
Ok thanks but if I knew how to do that I wouldn't be on here....maybe someone else has an idea. ...or there is a similar script out there I have...
September 23, 2021 at 1:26 pm
Ok thanks a lot, anyone any idea how to code the second part? To actually do the kill
September 23, 2021 at 12:34 pm
And produce a kill script from that select.
March 31, 2021 at 3:56 pm
I need to select all SIDs of a particular user who is running a particular piece of code, there in lies the challenge 😉
March 31, 2021 at 3:55 pm
Thanks Jeffrey...no azure involved.
Either file system or msdb.
January 18, 2021 at 9:50 pm
It's the siss part I am after the database and logins is straight forward.
January 18, 2021 at 6:17 pm
Thanks for your responses. The internal report on top table size was sufficient for me
September 28, 2020 at 2:01 pm
And to add....
Datafile of 50 gigs 40% free space and log file of 30 gigs 99% free.....so 5 gigs might be ok for backup ?
September 24, 2020 at 7:33 pm
Ok is there anyway to predict the backup size so I know if my (80 db size in db properties) with a 5 gigs backup without using compression is ok?
September 24, 2020 at 6:56 pm
September 24, 2020 at 5:52 pm
Thanks can you explain the index = 1 or 0 please ?
September 24, 2020 at 1:20 am
Thanks but nothing there is what I am after.
I need to know what was the total size of transaction log backups between datetime A and datetimeB.
This will give me an...
September 8, 2020 at 11:11 pm
Viewing 15 posts - 1 through 15 (of 66 total)