Viewing 15 posts - 36,466 through 36,480 (of 49,562 total)
tvantonder-992012 (10/5/2009)
The two instance names areserver\MSSQLSERVER - Default
server\prsvr
Not the server name itselfs. Is this possible with Network??
Yes, absolutely.
I've seen a case where one instance could be connected to with either...
October 5, 2009 at 5:37 am
If you don't have any backup at all, then the chances of getting anything back are exceedingly slim. Regardless of recovery model, if there has never been a backup then...
October 5, 2009 at 5:24 am
It can be done (attach the DB while the other instance is stopped) but there's no way that the DB can be in use in both instances, SQL takes exclusive...
October 5, 2009 at 1:17 am
Probably not.
If you have no backups at all then, regardless of recovery model, the log would have been in auto-truncate mode, meaning log records got discarded after the checkpoint runs.
There's...
October 5, 2009 at 1:12 am
Matt Miller (#4) (10/4/2009)
repent_kog_is_near (10/4/2009)
Yes Sir.(btw - the correct salutation in this case would be "Ma'am". don't let Quaigon Jin fool you)
Not that "yes <anything>" is a useful answer to...
October 5, 2009 at 12:56 am
Elliott W (10/4/2009)
October 4, 2009 at 12:03 pm
Than what do you mean by 'truncation of log ... after backing up the log'?
October 4, 2009 at 6:02 am
Mark_Pratt (10/4/2009)
October 4, 2009 at 5:48 am
ItalianOlgi (10/3/2009)
Yes, I looking for a list of interview questions!
No amount of memorising questions is going to get you past a good interviewer. You need to understand the material, not...
October 4, 2009 at 5:44 am
repent_kog_is_near (10/3/2009)
October 4, 2009 at 5:35 am
repent_kog_is_near (10/3/2009)
I'll wait for George is he is able to share the code to get the TempDB into 8 junior TempDBs!!
No need to wait for George. Use Books Online and...
October 4, 2009 at 5:33 am
Yes
You know, you could probably have tested it out and had an answer far faster than waiting for someone to notice your question.
October 4, 2009 at 5:32 am
The NOEXPAND hint is only valid for indexed views. Normal views have to be expanded because they don't actually stored any data, they're just saved select statements.
Remove all of the...
October 3, 2009 at 1:27 pm
With the exception of the heap (which can't be rebuilt because it's not an index), not one of those is over 20 pages in size. Rebuilding very small indexes is...
October 2, 2009 at 2:20 pm
Well, that output is for multiple tables (5 to be specific), not just the one that you're talking about.
Can you get the output just for the table that you're interested...
October 2, 2009 at 1:51 pm
Viewing 15 posts - 36,466 through 36,480 (of 49,562 total)