We have a server that has had a performance issue, for us it is a busy server and normal service has been resumed since a rollback of something that was...

Tried that, lots of data but have yet to manage to convert to something meaningful 🙁

It's good to see that U.S. citizens have April Fool's as well but does further beg the question why MS would attempt to release 2014 today as they aren't known...

I've had errors like this and have always found that the original code I've worked from overlooked something causing the error. I would check the database is online, you are...

silly me, found it in sys.configurations!

Thanks

This might not be the right answer for you but how about :

Location : 1 table including a field "HeadQuarters" which contains the ID of the location that is the...

thanks

I'm not sure how it is done but in my environment the security team have set rules so that our mail servers will not accept mail from dev boxes, clearly...

Interesting thought - if you are using SAN level replication then I can't see how the system would be able to differentiate stats data. But on backup / restore -...

If the db on server b is selected from only then there is no reason why the stats would be updated so the auto settings are not going to make...

No adding further naming to filenames makes automated actions much harder - it was pure and simple a mistake that shouldn't have happened, sorted now.

...an undoubtedly I caused it which is a bit embarrassing.

What an idiot - I was getting the date's on files mixed up - looks like backup each night is writing to the wrong file name (so Saturday wrote to...

In our experience backups run seamlessly alongside other activity, clearly they are a volume read activity & will be causing write activity against the logs but if running a backup...