Yes. Perf should improve.

Thanks

SQLBuddy

Hi

Try this. It worked for me everytime.

http://www.sqlservercentral.com/articles/Administration/smtpsqlserverperformancealerts/2005/

...

Hi

The jobs will wait for the next scheduled time.

Check books online or...

Hi

I think that you can do that. But I am not sure of the implications.

Best Regards,

SQL Buddy

Hi REM,

Lock pages in Memory will lock the SQL Server pages in the memory and as a result...

You can't configure 2 SQL Servers runing on same box to use the same port 1433. One of them should use a static port.

And from the client end, you have...

Hi

CXPacket waits are an outcome of SQL Server deciding to use parallel queries.

IF MAXDOP =0 and if the...

Hi

DB snapshot is just point-in-time shell of the DB. They just reflect the state of the DB at the time of snapshot.

...

Hi

Check these for installing and using SQL Server Performance Dashboard reports

http://www.mssqltips.com/tip.asp?tip=1553

...

Hi

You can also use Performance Dashboards reports and check I/O statistics of the databases to check the number of reads...

PK by default creates a unique clustered index if one doesn't already exists.

If a clusterd index already exists, you can specify NON CLUSTERED clause to create a noon clustered...

Hi

Powershell integration with SQL Server is introduced in SQL Server 2008.

I don't think you...

Hi

Could you provide us more information? No conclusion...

Hi Rohit,

1. Find the DTS pkgs that are using sa user account for the connection managers

2. Open the Pkg and change the sa password....

Hi

Counters for the SQL Server Instances will be present under the Performance Object drop-down window.

Click on the drop-down box and then scroll until you find the SQL Server Instance object.

Then...