I am trying to find the correct learning path for SQL 2005.  Of course,
there are so many things you can do, so when searching the books and
microsoft elearning, etc, my eyes glaze over.
Could some gracious SQL expert please recommend a good learning path to

I am upgrading our production db to SQL Server 2005 (64-bit) so we can
use more memory. We have a non-production db which runs on SQL Server
2000, which loads data into the production db using DTC between the
two databases. My question is: will DTC work between 2000 and 2005?

I have a user that wants to be able to run Enterprise Manager from his PC.
The DB currently resides on the server and he has to RDC to the server to
manage the DB? Any thoughts?

MSSQL Server 2000
I have a table with 150M rows, and I have an non-clustered index of an
int type field named 'saved_date' .  When I issue the SQL Query:
   SELECT * FROM mytable where saved_date >= 20080101 AND saved_date

I have installed standard SQL 2005 on a development server and now have been
asked to change it to developer.  Is it possible to upgrade or do I have to
reinstall?

I could really do with some help, if anyone would be kind enough.
I need to connect to my SQL express server. I am using Visual Studio
2005 to make the connection.
I have read numerous posts on how to configure this.

We are just going thru an upgrade exercise taking our SQL2005 build 3175
upto build 3239. We have upgraded development servers and are about to
upgrade the acceptance testing level next week. I try not to get the
workstation clirnt tools build ahead of the server client tools ...

There is a configuration setting for remote query timeout thats set at 600
seconds in SQL Server.
My question is as a result of this setting, every query will abort if
running for more than 600 seconds. I want to say that it is not the case and

My master and tempdb are in Latin collation, but all my other
databases are in Chinese_PRC_AS_CI, the problem comes when I do SQL
queries that require the usage of tempdb:
SELECT a.*

I am trying to create an alert.  I get the following error message,
and am asking for help on figuring out how to fix this.  TIA.
=======
TITLE: Microsoft SQL Server Management Studio

We have Team Foundation Server 2005. In our normal maintenance plan, we are
getting the following database consistency error on the database 'TWO':
Command:
DBCC CHECKDB WITH NO_INFOMSGS

I have read all the post in here and did not see any solution for the
problem i get.
I have 5 sql servers and 1 of them started to do some problems with the
backup and transaction logs backup.

We just started conducting data file backups and transaction log backups
through SQL 2005 maintenance plans.  No matter how often I shrink the
transaction log file, the file is huge everyday and is timestamped with 11:29
PM the previous night.

I have seen many trains of thoughts on defragmentation practices.
According to ShowContig both these tables are at less that 10% logical
fragmentation.  But the scan density is 20/25% which depending on how
you look at it means 75-80% fragmented.

On a development box, a database became unavailable.  The first error
we saw was
 The operating system returned error 38(Reached the end of the file.)
to SQL Server during a read at offset 0x0000019eef0000 ...