Viewing 15 posts - 7,126 through 7,140 (of 22,213 total)
lmacdonald (12/5/2014)
Do you monitor lock timeouts and does it often go above the default threshold of 1? I am asking because we...
December 6, 2014 at 3:47 am
Luis Cazares (12/5/2014)
December 6, 2014 at 3:44 am
I'd suggest putting in a request for it. It might not be that hard to implement. I'll put in a request from my side too.
December 6, 2014 at 3:40 am
Oh heck, I thought I was on the Data Compare page. Sorry about that.
Yep, no report on the Data Compare command line. Again, sorry.
So script or script file won't work?...
December 5, 2014 at 8:27 am
something is seriously baked on that server.
It's pretty abnormal. I've been working with VMs in Azure for years. And, because I'm doing lots and lots of testing and development, not...
December 5, 2014 at 8:22 am
Perry Whittle (12/5/2014)
ian_massey (12/5/2014)
But I don't have any access to the log file...
December 5, 2014 at 8:19 am
I've usually found single_user to problematic. That's why I prefer restricted_user. But then, you have to have had your apps set up correctly. If everyone is 'sa' or 'dbo' (or...
December 5, 2014 at 7:58 am
You should be able to set a switch that outputs as a report. Here's the documentation showing how that works. You would want /Report.
I didn't know we had a command...
December 5, 2014 at 7:55 am
I'm with Ed. It looks like they are doing log backups. So, they are right. If you were to introduce a different set of log backups, it could cause issues...
December 5, 2014 at 5:40 am
That sounds like they're saying that they are already backing up the log, but if the log is that large, that might not be true (likely isn't).
It's pretty much...
December 5, 2014 at 4:00 am
I'd put indexes on the table. The best choice, if you can only have a single index, would be a clustered index on the three columns in the WHERE clause.
The...
December 4, 2014 at 2:45 pm
If you attempt to delete the file and it appears in any way to be locked, then it is in use even if you haven't identified by what yet. Don't...
December 4, 2014 at 1:02 pm
Glad to hear you got the answer.
December 4, 2014 at 12:03 pm
Everything I've done and heard suggests that 2014 is basically a more stable 2012 with many of the improvements of 2012 polished, including more stability in Availability Groups, better behavior...
December 4, 2014 at 12:02 pm
curious_sqldba (12/4/2014)
My apologies, should have specified this. We already have a in-house alerting system, i just need the...
December 4, 2014 at 10:53 am
Viewing 15 posts - 7,126 through 7,140 (of 22,213 total)