Question : I have a database where constant read writes happening all the time. Searches are being done with wild […]
Tag: maintenance
SQL Server 2005 Huge DB issue
Question : My DB files are growing very fast ( designer is not me and just a weekly report makes […]
SQL 2005: Can we determine how much the rebuild index maintenance job can grow database log files?
Question : On SQL server 2005, if all the databases are in Full mode (with hourly transaction log backups), is […]
Process attempted to unlock a resource it does not own
Question : SQL Server 2005 SP4 32-Bit I have a DBCC CHECKDB job running nightly. Last night, soon after the […]
Appropriate use of mysql Optimize Table
Question : I want to come up with some best practice for maintaining our MySQL database, versions 5.5/6 and using […]
SQL unused logins
Question : is there a way to find out logins that have not been logged into the SQL Server or […]
Force drop db while others may be connected
Question : I need to remove a database from a PostgreSQL DB cluster. How can I do it even if […]
Is it possible to retrieve the specific databases selected in a maintenance plan step?
Question : I would like to use a tsql query to retrieve the databases involved in one of the steps […]
Defragmentation – Rebuilding Indexes SQL Server 2005
Question : I’m researching defragmenting databases and it seems the following SQL statement is what I’m looking for: ALTER INDEX […]
Reset all sequences so that they continue after max(id) + 1?
Question : It looks like I messed up a database migration and while all sequences are there, they would start […]