Try this. I think this will work, but I do not have a 2000 instance to test with.

select

a.rows , c.*

from sysindexes a

inner join INFORMATION_SCHEMA.TABLES C

on...

You can't directly restore a 2008 database to 2005, but you can use the generate scripts wizard to restore a 2008 database on 2005. Here is an article that...

Here is a script that I use. You need to enable xp_cmdshell. I think I had a better script, but I cant seem to find it now.

Set nocount...

This link should give you a good idea on the differences between the compatibility modes.

http://msdn.microsoft.com/en-us/library/ms178653(SQL.90).aspx

How about something like this. I am taking the condition out of the Where clause and using a Case statement to determine the count and avg.

SELECT Year(tblCSSData.SurveyDate) as [Year],...

Brent Ozar has a good blog post on how to collect and interpret perfmon counters.

http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

Try this. The All parameter will include statistics that are also associated with an index.

sp_helpstats 'categories','ALL'

If you look at the @results parameter in books online, it should make a...

Do you know if unchecking the option fixed the problem?

By default in SQL Server 2008, if you add a column in the designer that requires SQL Server to drop and recreate a table, the statement will fail. Not...

I use bcp with xp_cmdshell. See if this article helps...

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

How about this...

select Cast(Replace('AUG 28, 2008@11:30:03', '@', ' ') as datetime)

Sometimes Parameter Sniffing can cause poor execution plans in stored procedures. Most of the time it is a good thing, but sometimes it can cause performance issues if the...

Here is an article that show how to perform an in place upgrade. You basically install SQL Server and it will upgrade your 2000 instance to 2005. Make...

Steve Jones - Editor (4/27/2009)

---

I don't think you can even install with the same named instance if one is down and the other running. I think you need a unique...

They would have to have distinct names. Otherwise SQL Server or your applications would not know what instance to connect to.