Viewing 15 posts - 21,136 through 21,150 (of 49,552 total)
Best is 10 everywhere. If that's too expensive, then 1 or 10 for log and 5 for data (and 10 for TempDB)
RAID 5 is terrible for logs because it has...
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 11, 2012 at 9:13 am
Databases that have a filestream filegroup can't be mirrored, so if you haven't enabled filestream then you're fine to mirror that DB.
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 11, 2012 at 9:09 am
jarupan (1/11/2012)
Will this way work in all cases?
No. It will only work if the database was cleanly shut down before the log was deleted/removed/not included. Shutting down SQL does...
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 11, 2012 at 8:05 am
Post table definition (the CREATE TABLE statement) and the query that you're using with the column name
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 11, 2012 at 7:55 am
Perhaps a better option would be to query the plan cache (same method as Grant suggests) for plans that have CONVERT_IMPLICIT in 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
January 11, 2012 at 7:53 am
Bulk-logged recovery (if you can accept the minor risks to your your ability to restore the DB to point-in-time). Rebuild only what needs rebuilding, not everything.
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 11, 2012 at 7:51 am
Perry Whittle (1/11/2012)
To re attach a database with a missing log file just use either
sp_attach_single_file_db
CREATE DATABASE .... FOR ATTACH_REBUILD_LOG
Which only works if the database was shut down cleanly before...
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 11, 2012 at 6:57 am
What you did there was the absolute, very, final last resort for this kind of problem. You could have transactional inconsistencies, you could have structural inconsistencies.
Stuff that needs doing:
Run CheckDB...
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 11, 2012 at 6:40 am
Restore from backup is probably the best option here.
The transaction log is not an optional piece of the database and you can't expect to just delete it with no...
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 11, 2012 at 6:08 am
p.s. The overall LSN won't ever decrease. If it does, SQL hard crashes on the spot, by design.
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 11, 2012 at 5:20 am
The LSN is in 3 portions. The VLF,the log block and the log record. Which one dropped down?
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 11, 2012 at 5:12 am
Then the drop table log records are no longer in the transaction log (its a transaction log for database recovery, not an audit log) and, unless you had some other...
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 11, 2012 at 3:57 am
1) http://www.sqlservercentral.com/articles/Indexing/68636/
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
2) That will prevent key lookups, but you've just duplicated your entire table, perhaps multiple times. Don't use SELECT *, and keep the includes on indexes to as few...
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 11, 2012 at 3:20 am
Patience. We all have our own jobs and our own problems and post here in our spare time. If you need immediate assistance, contact Microsoft CSS or hire someone.
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 11, 2012 at 3:16 am
For SQL 2000 you can get SQLLogRescue from Redgate (it's free), but depending how long ago the table was dropped, it may not be in the tran log any longer
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 11, 2012 at 3:14 am
Viewing 15 posts - 21,136 through 21,150 (of 49,552 total)