Viewing 15 posts - 19,426 through 19,440 (of 49,552 total)
First step. Take out the join hints and table hints. The chance that you know better than the optimiser is slim.
If you can't post the code, then I can only...
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
April 2, 2012 at 4:46 am
Open up the default trace and look for Drop Object events. That will give you time, login name, host name and a lot of other info. (or if you don't...
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
April 2, 2012 at 4:38 am
Henrico Bekker (4/1/2012)
jesicasmith335 (4/1/2012)
hi i need latest questions of <removed> for the preparation of 3M0-211 exam.can someone share these questions with me
You are aware that by using braindumps etc you...
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
April 2, 2012 at 3:40 am
Someone took an ad-hoc full backup between the scheduled 7am backup and the diff you are trying to restore.
Differential backups are based on the last full backup taken, so if...
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
April 2, 2012 at 3:39 am
Waste of time and resources. Shrink fragments indexes and reduce the file size. Rebuild removes the fragmentation, growing the data file again.
See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
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
April 2, 2012 at 3:18 am
p.s. Don't mix up the minimum LSN for database recovery and the minimum LSN for log truncation, because they are not the same thing.
p.p.s The undocumented commands and features tend...
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
April 1, 2012 at 9:11 am
If the transaction commits before the data-reading portion of the full backup finishes, the transaction will be included in the backup and present in the restored DB. Otherwise not.
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
April 1, 2012 at 9:04 am
Shcherbunov Neil (4/1/2012)
That's all!! So - who is wrong? I am, or Minimum LSN column, or BOL?
The minimum LSN column (which only appears for a end checkpoint) is the minimum...
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
April 1, 2012 at 9:01 am
DBA-640728 (4/1/2012)
then i use that spid and run dbcc inputbuffer (spid#)
and i...
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
April 1, 2012 at 8:27 am
DBA-640728 (3/31/2012)
yes the same spid that is doing the rebuild is the one with -2
How did did you see that? Spid -2 won't appear in sys.dm_exec_requests, and DBCC InputBuffer can't...
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
April 1, 2012 at 5:22 am
george sibbald (3/31/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
March 31, 2012 at 6:02 pm
DBA-640728 (3/30/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
March 31, 2012 at 4:59 pm
You can restore without dropping the existing database, and it saves the cost of recreating the files. A restore always leaves the restored database exactly how it was at the...
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
March 31, 2012 at 4:51 pm
Shrinking is liable to make the problem worse, not better, as it severely fragments indexes.
There's no quick fix, no magic switch or setting. Performance tuning is the process of finding...
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
March 31, 2012 at 2:52 pm
govindarajan69 (3/31/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
March 31, 2012 at 2:49 pm
Viewing 15 posts - 19,426 through 19,440 (of 49,552 total)