Hi Gila,

Thanks for your reply.

It's a 185 GB database and defragmentation is not done since long time it seems. Heavily fragmented it is. I executing "sp_msforeachtable" proc. it...

I appreciate myself. Could guess it right.

I lost it. Nice question. Leared/reminded something today.

You mean '42000' euros .?

You are not connecting to SSMS, you are connecting to SQL Server.

Think client tool is not installed...

Many of the prior replies noted Transparent Data Encryption as an option. It was also noted that TDE encrypts the physical data files and not the data itself. The intent...

That's OK. It runs only at night, when users are not using...

Still nobody has responded..!

Steve, Gila.. No comment on this topic.?

Thanks.

Dear All,

I am still waiting for more responses ..!!!!

Thanks.

Thanks

You mean to say CPU capacity..?

Idealy what should be the configuration in cases like this?

Thank you. Kindly give some ideas on my first post as well.....

So

SSMS = sqlwb.exe

SQL server = sqlserver.exe

Am I right.?

Thanks for the quick response.

But for SQL Server 2005 the executable is "SQLWB.EXE" no ?

To really understand performance issues, you need to gather more metrics....

Sorry...I am not able to make anything out of it. Can...

haaaa..very good question.. fortunately I got it right.

Wel, I would like to know...

1. When a query will timeout.?

2. When execution of something will run out of memory.?

thanks.