Viewing 15 posts - 28,201 through 28,215 (of 49,552 total)
jts_2003 (1/25/2011)
What would be great is an easy way of backing up (and restoring) just a table... maybe in Denali?
No, and I doubt it will ever be a native feature....
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
January 25, 2011 at 4:43 am
Rob Fisk (1/25/2011)
Rowcount can be greater than the number of rows listed in the statistics if the statistics have not yet been updated for recently added rows.
sys.dm_db_partition_stats is not based...
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
January 25, 2011 at 4:40 am
Let me guess, full recovery model, no log backups?
If so, the problem isn't that you need to shrink, it's that you need to properly manage your transaction logs. Please read...
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
January 25, 2011 at 4:26 am
Why are you shrinking?
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
January 25, 2011 at 3:06 am
Hi Moosamca
If you are interested in learning about corruption and appropriate repairs, have a look at this article. Not comprehensive, but a good place to start: http://www.sqlservercentral.com/articles/Corruption/65804/
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
January 25, 2011 at 1:39 am
The log shipping destination will be RESTORING (or STANDBY), not RECOVERING.
The primary can be SQL 2005 and the secondary SQL 2008, but not the other way around. They should be...
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
January 25, 2011 at 1:26 am
luciano furlan (1/25/2011)
I fear every day, that I will forget the where clause eventually and destroy an entire table.And guess what: Sql doesn't have an Undo button!
If you're doing anything...
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
January 25, 2011 at 1:22 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1052854-357-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
January 25, 2011 at 12:45 am
shubham.saxena67 (1/24/2011)
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
January 25, 2011 at 12:36 am
Hi Rahul
Not sure if it's just a editing omission, but your trigger will only do what you're intending if there are no indexes at all or just a clustered index...
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
January 24, 2011 at 10:42 pm
Don't change anything unless you know you have a problem.
http://sqlinthewild.co.za/index.php/2010/03/11/the-root-of-all-evil/
First thing you need to do is test the DB and the website under the expected load and see how 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
January 24, 2011 at 10:19 pm
Works fine. No intellisense (if you're still using the build in garbage), other than that, no issues that I've had.
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
January 24, 2011 at 4:25 pm
moosamca (1/24/2011)
Please try with DBCC CHECKDB with repair_allow_data_loss. Hope this will help to resolve.
It won't, the damage is irreparable. The give-away indication that it's not repairable is the lack...
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
January 24, 2011 at 4:09 pm
moosamca (1/24/2011)
Did you tried DBCC CHECKTable with Repair_rebuild?
Waste of time. It's a catalog error. Repair_rebuild repairs damage to nonclustered indexes. Nothing, not even repair_allow_data_loss fixes schema corruption.
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
January 24, 2011 at 4:07 pm
moosamca (1/24/2011)
Could you please run DBCC CHECKDB and see is there any error on the report?
The checkDB error is listed in the first post:
Msg 8992, Level 16, State 1,...
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
January 24, 2011 at 4:02 pm
Viewing 15 posts - 28,201 through 28,215 (of 49,552 total)