A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 2833

All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.

4
votes
I think the main question is not how often other people back up their databases - but what level of loss your business will accept. If your server dies will they be happy going back to a backup file f …
answered Sep 14 '11 by georgeb
6
votes
As far as I'm aware it is not possible to disable Windows authentication on SQL Server 2008 + R2: http://msdn.microsoft.com/en-us/library/ms144284%28v=sql.105%29.aspx The only Windows accounts that …
answered Jul 11 '12 by georgeb
3
votes
The values in the index itself will update automatically. I can only speak for SQL Server but indexes can often need rebuilding or reorganising due to fragmentation occurring - particularly if it is o …
answered Sep 13 '11 by georgeb