Viewing 15 posts - 16,801 through 16,815 (of 49,552 total)
When I wrote the SQL 2008 TS and ITP exams, I wrote the 2 exams for the ITP exams first, then wrote the TS ones a couple months later.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 9:15 am
Never, never, never, never detach a corrupt or suspect database. It will not help and it is very likely to make matters far worse.
Take a look at this article....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 9:06 am
For the MCTS/MCITP/MCSA/MCSE level exams, you can write the exams in any order you you like, you get the certification once you've written all the required exams.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 8:42 am
Without changing the code you won't be able to fix the blocking. Can you speak to the vendor about it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 7:50 am
No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1353492-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 7:48 am
You can't prevent intent exclusives, they're taken at higher levels in the lock hierarchy to protect the lower level resources and to make it easier for SQL to identify whether...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 7:42 am
If you restore the log backup WITH STANDBY, you can restore further log backups. If you restore the log backup WITH RECOVERY, you cannot restore further log backups.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 7:39 am
To answer that needs more info about what the interviewer meant by 'change the LSN' (he could be referring to the tran log's current LSN or MinLSN, or any one...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 7:19 am
sqlmate (9/3/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 7:09 am
arunkumarco (9/3/2012)
re-create indexes for those tables.
GilaMonster (8/31/2012)
Nalini D (8/31/2012)
Did you try re-creating the indexes on the table?
Won't work. The repair fixed the damage to the nonclustered index and some damage...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 7:07 am
Once again...
Take a read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
It discusses all the possible reasons for the log not being reused and details about how you might approach resolving them
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 7:06 am
Assuming there is an inactive portion, assuming the inactive portion is at the end of the log file and assuming that the shrink does not cause problems when used on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 5:28 am
In effect, no. In side effects, yes.
Rebuild all indexes on a table and it's a single transaction so you need enough free log space for all of the indexes on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 4:40 am
If you want it to be standard edition for licensing purposes, it has to be standard edition. Enterprise has a whole lot of features that you can't chose not to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 3:25 am
Restoring is the only state allowed for a secondary when configuring mirroring.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 3, 2012 at 3:23 am
Viewing 15 posts - 16,801 through 16,815 (of 49,552 total)