Viewing 15 posts - 1 through 15 (of 340 total)
Here are they,
January 14, 2009 at 11:54 pm
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...
December 30, 2008 at 3:40 am
This issue occurs because SQL Server Management Studio cannot correctly report the error when the maximum number of concurrent connections has
To work around this issue, you can use...
December 30, 2008 at 3:37 am
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...
September 20, 2008 at 11:23 pm
Please refer these links where we have discussed about the same question,
September 20, 2008 at 11:19 pm
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...
September 5, 2008 at 7:17 pm
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...
August 15, 2008 at 10:23 am
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...
August 8, 2008 at 6:51 am
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...
August 8, 2008 at 6:38 am
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...
August 8, 2008 at 6:31 am
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,
August 8, 2008 at 6:29 am
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...
July 30, 2008 at 9:33 pm
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...
July 23, 2008 at 8:11 am
Did you restore the database using with norecovery option? Try this,
Restore database dbname with recovery
July 23, 2008 at 5:19 am
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
July 23, 2008 at 4:55 am