Viewing 15 posts - 61 through 75 (of 2,000 total)
Just to put a new topic of conversation in here - have you ever had server envy?
My brother always used to have the best kit...… I've just finished testing on...
March 16, 2020 at 10:43 am
The issue with the log file on tempdb will be either a very big transaction using a temp table, or an uncommitted transaction that is using tempdb, which is causing...
March 16, 2020 at 10:22 am
do NOT poke the mighty Grant on the subject of Extended Events. I learned the hard way.
He beat me like a naughty stepchild (methaphorically)
but on that version you have no...
March 16, 2020 at 9:25 am
Was there an update to SSC recently?
The "last page" bug is back. When posts are under a certain number, the email link sends me to the page before and...
March 16, 2020 at 9:14 am
firstly go to sql agent and put an alert on any replication job that fails
secondly - go into replication monitor, expand the publisher and right click on the publisher name...
March 16, 2020 at 9:08 am
I've had to work from home for the last few days due to NHS guidelines, I found myself doing things like having a shave while in a conference call and...
March 16, 2020 at 8:58 am
if you add a computed column with a checksum or md5 hash then add a 2nd column that is previous checksum with a trigger dealing with the copy into old...
March 13, 2020 at 11:59 am
the only way I can see you doing that is setting up a profiler trace that saves to a table.
Ha! Gotta post this. I saw you recommend Profiler...
March 13, 2020 at 10:45 am
the only way I can see you doing that is setting up a profiler trace that saves to a table.
March 13, 2020 at 9:11 am
don't forget to put your alerts back on the replication jobs 🙂
March 13, 2020 at 8:39 am
many years (sql 2000) ago I did something similar - it is horrible and should not be repeated
sp_msforeachdb 'select ''?'', name from ?.dbo.sysobjects where object_definition(id) like ''%.%.%'' '
do not try...
March 12, 2020 at 5:34 pm
as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the...
March 12, 2020 at 5:21 pm
as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the...
March 12, 2020 at 4:57 pm
as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the...
March 12, 2020 at 4:52 pm
Viewing 15 posts - 61 through 75 (of 2,000 total)