Thanks for your response.

The default database is "master". So, I don't think there's any changes on the database.

Would it be possible for us to track which databases the login...

Would you mind to advise how to convert it?

Thanks Bru for your help. I really appreciated that. 😀

reserved : 28,400,944 KB

data : 16,343,440 KB

index_size : 12,056,360 KB

Thanks Bru for your prompt response on this.

As per my understanding the table locks are applied for the duration of the rebuild index operation. Just want to...

Hi,

If you plan to remove your local drives from the machine, I do not see any negative impact if you wish to use the same drive letter. But I...

Hi,

I mean "Covering Indexes". I found one article at SQL Server Performance website (http://www.sql-server-performance.com/tips/covering_indexes_p1.aspx). Can anyone can provide me a brief idea on what is it?

Thanks.

Thanks for your help on this. The script is really helpful. 😀

Hi Gail,

You mean someone should have restarted either the server or the SQL Server services? Am I correct?

Hi Gail,

Thanks for your response. No one restart the principal, but the server did encounter network broke down incident. It causes the mirroring broke and resume back.

Does it...

Thanks for your comment.

I was requested by user to shrink the database transaction log files in order to free up more space in the drives. There are quite a...

Hi all,

I really appreciated with all your comments, advice and help. It helps me a lot. I do not realize that it can be done. It really...

Is that possible if we could execute any t-sql to show a list of quries/transaction that caused high cpu usage?

Just an idea pop up from my mind may be we...

Hi,

You guys are really helpful. I really appreciate your reply on this, it save me a lot of time. Thanks. 😀

I encountered the same error as well. Does anyone has any solution for this? Kindly advice.