Viewing 15 posts - 1 through 15 (of 74 total)
DBCC checkdb is executing dbcc cehcktable as this is a part of consistency checking opertaion. you can also run only dbcc checktable for checking on table level.
March 1, 2012 at 9:27 am
You can not bring the database when there is a session on database. find out the spid who is using the database then kill that spid.
Select * from sys.sysprocesses where...
February 29, 2012 at 9:55 am
TeraByteMe (2/29/2012)
February 29, 2012 at 9:50 am
Check any maintenance job might be running the dbcc check db . IF execution the time is fixed then run a trace findout which session is executing this.
February 29, 2012 at 9:42 am
You can create temp table and insert the all the database names. and Execute below statement to get the script of create database , copy the result in query analyzer...
February 29, 2012 at 5:43 am
I think you should check the execution plan for both queries and try figure out why it so.
February 29, 2012 at 3:53 am
Use the below Stored Procedure to find outh the details
EXEC master..sp_help_log_shipping_monitor
February 28, 2012 at 7:08 am
Check this link.
http://www.mssqltips.com/sqlservertip/1708/index-fragmentation-report-in-sql-server-2005-and-2008/
February 28, 2012 at 6:47 am
Increase the max server memory setting. Free caches by using one of the following commands: DBCC FREESYSTEMCACHE, DBCC FREESESSIONCACHE, or DBCC FREEPROCCACHE. If the problem reappears, reduce workload.
February 28, 2012 at 6:43 am
Try with using dynamic sql statements to do this.
February 28, 2012 at 6:29 am
Check this article.
February 28, 2012 at 5:04 am
Backup strategy.
February 27, 2012 at 5:48 am
Viewing 15 posts - 1 through 15 (of 74 total)