Viewing 15 posts - 1,741 through 1,755 (of 49,571 total)
Can you post the plan please (as a .sqlplan file)
A key lookup is Always to the clustered index. It cannot be to any other index. A key lookup...
February 22, 2017 at 12:38 pm
The first statement is the same as the behaviour in read committed. Session one starts a transaction, updates a row. Session 2, in read committed or repeatable read cannot read...
February 22, 2017 at 9:58 am
Nothing like listening to the developers sitting 2 rows behind me spend half an hour trying to figure out what max server memory should be, and not come and ask...
February 22, 2017 at 8:27 am
It works as written, and is correct (except for the missing commit tran/rollback tran). In this case the SSMS intellisense is incorrectly flagging a lack of a ;
February 22, 2017 at 6:33 am
February 22, 2017 at 6:30 am
February 22, 2017 at 6:06 am
If the backup is damaged enough that SQL's throwing a media family error, the backup is likely to be garbage and unusable, and there's no magic 'fix backup' command that...
February 22, 2017 at 5:06 am
The "terms of use" (link at bottom of web page)
8.1 We may, in our absolute discretion:
(a) block you from using the Site where we...
February 22, 2017 at 4:33 am
You probably can't. If the backup's damaged to the point you're getting that error then it's likely to be unusable.
The other possibility is that you're trying to restore it...
February 22, 2017 at 2:57 am
If you're getting that error, the backup is probably damaged and not restorable.
No backups of your server?
February 22, 2017 at 12:30 am
February 21, 2017 at 2:59 pm
February 21, 2017 at 9:17 am
February 21, 2017 at 6:08 am
You need to investigate why the client machine (the IP address you blanked out) is trying to connect to the wrong server. This isn't something that can be fixed on...
February 21, 2017 at 6:03 am
February 21, 2017 at 1:37 am
Viewing 15 posts - 1,741 through 1,755 (of 49,571 total)