Viewing 15 posts - 28,756 through 28,770 (of 49,552 total)
Backups write log entries as does recovering the database, so that counts as a change. There's no way to force (you'd be messing with DB integrity if you could), and...
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
December 25, 2010 at 1:37 pm
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1039194-360-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
December 25, 2010 at 1:31 pm
ananda.murugesan (12/24/2010)
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
December 25, 2010 at 1:30 pm
Jonathan Kehayias (12/24/2010)
Read the comment by Rich on this other corrective blog post I wrote after wrong information was repeated sent out by SSWUG in their newsletter.
For some...
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
December 25, 2010 at 1:28 pm
There's only 22MB of unused space in that database. Shrink is going to do nothing, as I said it's not compression, it's just releasing unused space to the OS.
To reduce...
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
December 25, 2010 at 1:22 pm
How big is the database in total (file size) and how big is the data (sp_spaceused)
Shrink is not a solution to low disk space, shrink doesn't compress data and 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
December 24, 2010 at 11:06 am
muzak (12/24/2010)
Actually the documentation states that 'limited' scans parent levels for an index:
I never claimed otherwise.
Limited mode scans the level above the leaf because that's all it needs to do...
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
December 24, 2010 at 7:41 am
Limited shows only the fragmentation at the leaf level, not the root. The root (by definition) has only one page. It's not showing incorrect values, it's just not showing 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
December 24, 2010 at 4:52 am
abhishek.8604 (12/24/2010)
sometmes the .bak file will be corrupted...try attaching another .bak file
There's no backup here. He's attaching, not restoring.
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
December 24, 2010 at 4:45 am
What files are supposed to be part of this database?
When you use the dialog to attach a DB, SQL goes and finds the secondary and log files for 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
December 24, 2010 at 2:09 am
Henrico Bekker (12/23/2010)
http://msdn.microsoft.com/en-us/library/ms188902.aspxinvestigate the files in you backup....use the link above..
There's no backup here. He's attaching, not restoring.
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
December 24, 2010 at 2:06 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1038990-1550-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
December 24, 2010 at 2:06 am
Unlikely, the lsns probably won't match. Try on your test server to be sure, restore backup with norecovery and see if it'll take a log backup. Very doubtful that it'll...
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
December 23, 2010 at 3:34 pm
subha.mcts2005 (12/23/2010)
Thank you very much for your valuable information, i will take the precautions for all databases now onwards.
So you don't want any possible alternate resolutions?
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
December 23, 2010 at 9:52 am
The syntax is the same, the column names don't have to be the same at all. In your example, you specify both column names, you do it exactly the same...
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
December 23, 2010 at 8:01 am
Viewing 15 posts - 28,756 through 28,770 (of 49,552 total)