Viewing 15 posts - 24,916 through 24,930 (of 49,552 total)
See previous reply then. Complete loss.
Are you sure there are no backups anywhere? No backups taken for dev purposes or anything similar?
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
July 13, 2011 at 3:51 pm
seth delconte (7/13/2011)
mortalic (7/13/2011)
TRUNCATEONLY
Releases all free space at the end of the file to the operating system but does not perform any page movement inside...
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
July 13, 2011 at 2:51 pm
See if you can access any of the DB while it's in emergency mode. Maybe....
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
July 13, 2011 at 2:46 pm
Yup. That's an absolute. Emergency mode repair is the very last resort. It failed.
Restore from backup or declare the database a complete loss and start from scratch.
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
July 13, 2011 at 2:29 pm
That feature is solely a SSMS feature. The exec plans from both 2005 and 2008 have missing index info in them, whether it's displayed or not depends on the version...
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
July 13, 2011 at 2:19 pm
Phil Parkin (7/13/2011)
Clearly I should stick to SSIS questions and leave this stuff to people who know what they're talking about 🙂
Nah. This just happens to be one of 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
July 13, 2011 at 2:07 pm
jpSQLDude (7/13/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
July 13, 2011 at 2:04 pm
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
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
July 13, 2011 at 2:01 pm
Jim Murphy (7/13/2011)
Gail, aren't you a moderator still? Maybe you can just whack that whole thread in Steve's absence.
I've never been a moderator here.
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
July 13, 2011 at 2:00 pm
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
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
July 13, 2011 at 1:58 pm
Never worked with full text indexes.
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
July 13, 2011 at 1:56 pm
If it's only one per call I would recommend 4 procedures. You can write them to query a view, no difference, the view is inlined into the query during execution.
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
July 13, 2011 at 9:19 am
Sounds like this... http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
July 13, 2011 at 9:18 am
Yes, it's absolutely essential to have that and to check that it runs clean when it runs.
Without that you have no way of finding corruption until some query trips...
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
July 13, 2011 at 9:06 am
You might get more useful replies if you tell us where you're 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
July 13, 2011 at 9:04 am
Viewing 15 posts - 24,916 through 24,930 (of 49,552 total)