Totally could be. It's tempdb, the midden heap of SQL Server. We all know it could be a million and one different things, or combinations of those million and...

It would definitely be interesting to do some performance tests with "read uncommitted" and see how badly I could break a test script. I am assuming that if you...

erm…. I picked up on one word - "weekend"

so is there any possibility that it's a rebuild index with "Sort in tempdb" option enabled... we all know which jobs we...

Good question and frederico's links showed me some things that I hadn't had chance to look at yet.

I'm guessing the application causing this is a Microsoft office (access/excel) app?

if you are asking what I think you are , then put a manual entry password on the report.. if it gets deployed to the wrong folder then the other...

Great article,

I've had to use READ UNCOMMITTED to fix so many locking and blocking issues (it's not a fix all and should be used only by experienced adults under supervision)

It's...

I'll give it a go... It's still new to me, but I love learning.

ive only just finished my last article and I'm at SQL in the summit being...

I'll give it a go... It's still new to me, but I love learning.

ive only just finished my last article and I'm at SQL in the summit being interviewed by...

from the message "cannot find the path/ this is not a valid directory"

i'd suggest scripting up the restore and running it one file at a time.

it might be that your...

this is where mirroring with a witness used to be a great tool....I don't really know AG that much, but i'm guessing there is some DNS trickery  that you could...

ha - corporate policy, i'm not allowed to plug in any usb device unless it's encrypted or approved and purchased by the network team... even my USB stick containing keys...

Thank you very much for your much appreciated answers!

I've read the article and feel I understand parameterizing better now. I'm going to  experiment with the examples and try a...

just out of interest.... does anyone miss having a dvd drive in their laptop?

I'm travelling now, and I have a Netflix subscription, but no signal - I used to take...

see this resource

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

looks like it might be that the web control is trying to protect against HTML injection and forcing you to double escape the backslash

it's fairly common

very similar to the concept...