Viewing 15 posts - 526 through 540 (of 769 total)
A database can be dropped regardless of its state: offline, read-only, suspect, and so on. To display the current state of a database, use the sys.databases catalog view.
https://msdn.microsoft.com/en-us/library/ms178613.aspx
I don't think...
February 25, 2015 at 6:15 pm
Download Express edition from Microsoft site. Buy DBA books and do read the book throughly and try the steps out in your local sql server engine
February 19, 2015 at 7:38 pm
I think in such questions where it's asked to choose multiple correct answers, it will be good to have more points rather just 1. Thoughts?
February 19, 2015 at 6:06 pm
May be when you try to shrink tempdb, the between tempdb pages are not aloowing to free up space
January 11, 2015 at 8:15 pm
Thnkx...
January 7, 2015 at 9:31 am
Getting this error:
Msg 208, Level 16, State 1, Procedure GetIt, Line 7
Invalid object name 'T'.
Msg 15165, Level 16, State 1, Procedure sp_recompile, Line 19
Could not find object 'T' or you...
December 26, 2014 at 2:35 am
alter database [DB] set single_user with rollback immediate;
December 25, 2014 at 3:16 am
The option does not seem like correct. The compression ratio will depend upon the kind of data is contained in the tables. So if the tables hve LOB then the...
December 5, 2014 at 4:17 am
Viewing 15 posts - 526 through 540 (of 769 total)