Viewing 15 posts - 46 through 60 (of 2,000 total)
The UK last night announced that if any symptoms are shown then 14 days isolation... people at risk are to take 3 Months of isolation.
I had a serious condition in...
March 17, 2020 at 8:44 am
we run R from within management studio (R studio and sql do not play nicely) - but it works
March 16, 2020 at 5:32 pm
have you thought about using filestream ?
March 16, 2020 at 5:29 pm
I work from home 100% of the time, and have done so for the past 15 years. I've been quite successful in that mode. Prior to that, I'd worked...
March 16, 2020 at 5:17 pm
The last company I worked for downsized their offices which meant they were looking for volunteers to work from home. Since I had a long commute I figured I'd...
March 16, 2020 at 2:46 pm
Can't disagree, Mike. Not the first time, of course, but a bit of a pity nonetheless.
Thanks for your help, btw. Irrespective of getting a satisfactory conclusion one of the...
March 16, 2020 at 2:42 pm
With respect, Mike, that's steering away from what I originally asked.
In my original post, I recognised that there are workarounds potentially available. However, I asked for help in how...
March 16, 2020 at 1:54 pm
fixed it perfectly
thank you.
even though the database had come from a full backup it did not want to shrink until it had a t log backup of an empty log...
March 16, 2020 at 1:46 pm
Whats the status of log_wait_reuse_desc in sys.databases?
May be a case that you need to run a few log backups to get it to be able to checkpoint and shrink.
the...
March 16, 2020 at 1:39 pm
I've never been able to get my hands on a physical server. Remote into one, sure. But actually touch and play with one?
@Sob. Never!
I was allowed to (under controlled...
March 16, 2020 at 12:17 pm
Unfortunately , if you are going through a web server it is nigh on impossible to get the level of data you want without coding in some sort of logging...
March 16, 2020 at 12:12 pm
have you used the "select all columns" option in profiler? - you should have the application name (if it was supplied in the connection string or left as blank)
also if...
March 16, 2020 at 12:01 pm
there is another option and I hate even suggesting it... you could put a trigger on the tables that you want to monitor
I know that you can use SUSER_NAME() in...
March 16, 2020 at 11:49 am
I'm trialling a synchronous pair with a 3rd node that is async… i'm asking similar questions. I'm hitting so many issues with HA groups that I just want to go...
March 16, 2020 at 11:37 am
Just to put a new topic of conversation in here - have you ever had server envy?
I've been watching Linus' Tech Tips on YouTube recently, some of their...
March 16, 2020 at 10:58 am
Viewing 15 posts - 46 through 60 (of 2,000 total)