Viewing 15 posts - 121 through 135 (of 197 total)
As the error message states, it appears that you have a database consistency issue with the database. Are you running DBCC CHECKDB on a regular basis? If the index is...
October 26, 2012 at 4:18 pm
The rollback can take as long as the transaction that led to it. Give it time to rollback. It will still hold the same locks until the transaction completes. If...
October 25, 2012 at 7:43 pm
I just stumbled on this and it is exactly what I was looking for. Thanks for taking the time to put it together!
October 25, 2012 at 4:52 pm
Something has to be blocking the truncate table statement. This is kind of an old school script as it uses code from sp_lock, but it should tell you exactly which...
October 25, 2012 at 4:39 pm
Never seen anything like that before. I have seen columns named prefixed with the data type, but that too can present issues should you ever need to rename a column...
October 25, 2012 at 12:53 pm
I concur with cppwiz that you should invest in some type of test preparation software. While there is no substitute for hands on experience, the practice tests come pretty close...
October 25, 2012 at 12:43 pm
As already mentioned, there is zero impact on the log chain if you shrink the transaction log. But the question remains, why do you want to shrink the transaction log?...
October 25, 2012 at 9:41 am
We include this as a post SQL Server installation configuration by creating a scheduled job that executes the following:
EXEC sp_cycle_errorlog
GO
EXEC sp_cycle_agent_errorlog
GO
It runs weekly on every server in our enterprise and...
October 22, 2012 at 4:07 pm
Data compression was added in SQL Server 2008 and therefore is not applicable to SQL Server 2005. If you review the following MSDN link on SQL Server data compression, you...
October 22, 2012 at 9:31 am
I primarily use SSMS and only RDP into the server when I want to run something on the server that may take a significant amount of time to complete. That...
October 19, 2012 at 10:26 am
It's vendor code to they'll need to be the ones to fix it, I'm just trying to figure out why it won't cache the query plan.
March 7, 2012 at 4:47 pm
If you simply want to receive an email when a deadlock occurs, you can configure an alert for the 1205 error that is generated and have it send out an...
April 2, 2010 at 3:03 pm
The database lock prevents a DBA from detaching or dropping the database while it's being used. If you've ever attempted to detach a database and couldn't because it's "In use"...
April 2, 2010 at 2:47 pm
There will be no data loss but you should immediately take a full back up after you make the switch and then configure your transaction log backups.
January 21, 2010 at 5:38 pm
Viewing 15 posts - 121 through 135 (of 197 total)