Here are they,

http://support.microsoft.com/kb/246133

http://support.microsoft.com/kb/918992

- Deepak

Adding to what others mentioned, I would advise you to buy MS press books especially the one written by Kalen Delaney (Inside SQL Server 2005) or Administrators companion. That should...

This issue occurs because SQL Server Management Studio cannot correctly report the error when the maximum number of concurrent connections has

been reached.

To work around this issue, you can use...

As mentioned by Chuck you need to have the same build and same edition of Sql Server to attach or restore the system databases. Please refer this link for more...

Hi Raghav,

Please refer these links where we have discussed about the same question,

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3475187&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2372710&SiteID=1

I think it also depends on the number of records present in the table. IF fewer records are there i think the optimzer would prefer a scan rather than a...

Yes Eddy, you will not be able to use database mirroring for reporting purpose if you dont have an enterprise edition of Sql server 2005, since database snapshot is a...

Agreed, if you create a covering index to cover the columns used in where clause and use included columns for columns used in select statement the query will should be...

Have a backup of all the databases in a safe location before upgrading (just for safety) your Windows server 2003. I hope your database files reside in a different location...

You have 70-431 certification for DBA. The above links should help you get through it. But I would recommend 70-431 Microsoft press book which covers the entire syllabus. Apart from...

There are lots of materials available for Sql Server. I will list down some useful websites where there are lot of articles which will help you,

Websites

*******

http://www.sqlservercentral.com

http://sqljunkies.com

You can try as follows,

1. Keep the job owner as sa (sysadmin) and in the job step use xp_cmdshell

2. Ensure that the Sql Service account has necessary permissions to the...

Yes. I have captured the deadlocks into a table which displays the data as a XML file..but i was wondering how to minimize the query..if you need any other info...

Did you restore the database using with norecovery option? Try this,

Restore database dbname with recovery

Brad has written a nice article about it. Please refer, http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx

If you wish to know more, you can get this book on performance tuning Sql 2005