Viewing 15 posts - 1 through 15 (of 59 total)
to get a detailed report of SQL Servers memory you below dbcc command
DBCC MEMORYSTATUS
March 6, 2012 at 9:56 am
T-SQL Fundamentals is nice book as recommended by Gail Shaw.
March 1, 2012 at 11:32 pm
I am also seeing this but this reportserver blocks got auto cleared in sometimes.
March 1, 2012 at 11:52 am
Check this post.
http://sqlblog.com/blogs/peter_debetta/archive/2008/02/29/sql-server-2008-leap-year-issue.aspx
March 1, 2012 at 11:46 am
Are you facing any issue while installing sql server on your lab servers?
March 1, 2012 at 11:41 am
here is the command.
EXEC sp_rename 'oldname', 'newname';
March 1, 2012 at 11:23 am
use sql server profiler to get the query execution time and all other details.
March 1, 2012 at 11:07 am
Satya_0000 (2/29/2012)
Hi , I am unable to bring Database to online its saying database is in used using below command
Alter database dbname set offlineplease advice.
You also do this...
February 29, 2012 at 12:01 pm
You most welcome..!!
February 29, 2012 at 11:54 am
Read this article.
http://www.techrepublic.com/blog/10things/10-tips-for-upgrading-to-sql-server-2008-r2/2376
February 29, 2012 at 11:46 am
have you checked data and log files are exist in new location? if not copy it manually and try to put database online.
February 28, 2012 at 11:11 pm
When the backup is in hung state what you see in lastwaitype column for that spid.. also check the disk where taking the backup.
February 28, 2012 at 12:12 pm
Viewing 15 posts - 1 through 15 (of 59 total)