Viewing 15 posts - 7,291 through 7,305 (of 22,213 total)
Best thing to do is put the database into restricted user, not single user. Although, that presumes you're not letting your apps connect as 'sa'.
If you are, then have the...
October 28, 2014 at 11:21 am
You should treat any SQL Server instance on a cloud VM the same way you'd treat it on a local VM or even on local hardware. You look to performance...
October 28, 2014 at 11:16 am
Luis Cazares (10/28/2014)
Grant Fritchey (10/28/2014)
jeffgonzalez007 (10/28/2014)
October 28, 2014 at 11:11 am
jeffgonzalez007 (10/28/2014)
October 28, 2014 at 10:49 am
Koen Verbeeck (10/28/2014)
Grant Fritchey (10/28/2014)
October 28, 2014 at 8:57 am
It's the last ID generated for any session in any scope. So another session may have experienced a rollback or something else that caused it to generate an identity value...
October 28, 2014 at 8:41 am
The fundamentals are the same from 2005 through 2014, so on lots of levels, it doesn't matter which you study. However, your knowledge will have a longer shelf-life if you...
October 28, 2014 at 8:38 am
While it certainly could be AG, and that's really the only evidence we have, I'd suggest capturing a bunch of metrics in order to understand where the problem lies rather...
October 28, 2014 at 7:41 am
I'd suggest looking at the system to see what it's waiting on. You can query the dynamic management views to pull information out. This book (free download) shows a number...
October 28, 2014 at 7:38 am
You need to identify the blocking chain, which process is causing it to stop. Or, you need to identify the resource that it's waiting on in order to understand which...
October 28, 2014 at 7:37 am
On most databases, most of the time, if you have automatic statistics maintenance enabled and you have auto-create statistics enabled, you're getting the statistics you need and probably don't have...
October 28, 2014 at 7:31 am
That's really best done on the client, but the LEFT string function will work.
October 27, 2014 at 11:30 am
Agree with Gail.
Look to the default ANSI settings on both servers, max degree of parallelism and the cost threshold for parallelism. Deviations in these settings can lead to differences in...
October 27, 2014 at 7:07 am
vincyf1 (10/23/2014)
jamessdba (10/22/2014)
Hi please clarify .Please explain
what is the difference between database refresh (when we go for refresh)& Restore
Please clarify
Database Restore - When a DB Backup is...
October 23, 2014 at 7:00 am
yeah, it doesn't do regular expressions. Wild cards, AND/OR and NOT are supported though.
October 23, 2014 at 5:41 am
Viewing 15 posts - 7,291 through 7,305 (of 22,213 total)