Hi,

Procedure cache Hit ratio..actually using 95%, I want to reduce the execution % for the stored procedure.

The best way for reuse the stored procedure an existing execution plan. Could...

Monitoring sampling frequency...

Thanks for your reply..

Does Network service account can be support for this lock page memory option? I am using windows 2008 R2 enterprise 64 bit edition.

thanks

ananda

Thanks for your reply...

As per server array configuration one, there is no two different array controller.

Arrary Name - Smart array P400 in Slot1

Total 4 HD connected to the same array...

Thanks Gail for your reply.. I will do it Max memory setting after installation and absolute usages of these third party application like LTO, symantec and application software..

For the...

Resolved this error-

This can be done by following the menu route: Edit -> IntelliSense -> Refresh Local Cache

rgds

ananda

Hi Gail, what could be alternative solution to aviod data loss? when...

hi, Thanks for your reply and steps for sorted out. there is only one record was loss.

I am using DBCC CHECKTABLE ('Table_name', REPAIR_ALLOW_DATA_LOSS)

thanks

ananda

Database setting is recovery model 'SIMPLE', then executed this procedure that failed due to Tlog full.. after that I changed recovery model to 'FULL' then taken two times for TLog...

Hi Henrico Bekker, thanks for your reply...

Now I could understand for tempdb adding data files...

I am going to install and kept it only one tempdb data file (mdf) and log...

Hi,

I gone through that URL..

why adding tempdb data file? main purpose of this reduce the tempdb contention for sql server transaction and improve the performance.

The general rule I know...

yes, I disabled the triggers

Disabling all triggers that were defined with the same scope

The following example disables all DDL triggers that were created at the server scope.

SQL

Copy

USE AdventureWorks2008R2;

GO

DISABLE Trigger ALL...

Thanks Lowell, this is working fine ..

Thanks for your reply...

I tried DENY option as following script but it is not hope..please give me script.

connect throu sysadmin login and created user and login.

USE [master]

GO

CREATE LOGIN [testuser] WITH...

Hi Dev,

It is right for upgrade sql server 2000 to SQL server 2008.

I am not getting more downtime for...