You should benchmark performance before and after making these changes.

If you have your data split into multiple filegroups and files, SQL will start an i-o stream for each file.  In...

My understanding is that extended stored procedures will exist in SQL2005, but will be deprecated.

From SQL2005 onwards you will have .Net CLR support directly within SQL Server.  This means you...

Frank's link has some good stuff.  I would recommend you look at some of these things.

However, if you want to stick with just SQL and DB2, you can also do:

a)...

As a few people have said, in SQL Server it is not possible to restrict what anyone with Sysadmin authority can do.  SQL Server simply does not check if a...

Unless you want to re-code some MS supplied SPs, what you want to do CANNOT be done with SQL2000. 

There are some critical SPs that check if you are either...

The SQL syntax to support recursion directly in SQL does not exist in SQL2000, but is (finally) introduced in SQL2005.  Some other DBMSs have had recursion for years.  The DB2...

If you want to move the system databases after you have completed the install, see http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

I strongly recommend you complete all operations on a given database before you start...

Tempdb is re-created every time SQL is started.  If you stop SQL, delete the tempdb files, and restart SQL this might cure your problem.  You do not need to keep...

You could easily implement your SP as a view, by joining your two selects into a single statement.

This would make it easier to join the results from this process with...

There is not an easy answer to this question.  You should consider the application and data retention issues in addition to 'pure' SQL Server issues before making a decision.  The...

SQL2005 IS should be able to pull data from any ODBC compliant data source.

If you can find an ADABAS ODBC driver for Windows, then IS can get your data.  (ADABAS should...

One potential problem of option B is that that Crystal may produce sub-optimal SQL to access the database.

This is a generalisation, but most high-end reporting tools have logic to decide...

We have used the script below to pull off permissions for database roles:

-- Build statements to replicate authorities for a Database Role

SELECT

  CASE p.protecttype

  WHEN 205 THEN

    CASE

     ...

I have not applied this fix, but looking at the hotfix components there are definitely server-based components.

SQL hotfixes are always cumulative, and this hotfix will update your server to level...

Don't forget that your calculations will just give you the distance as the crow flies, not the surface travel distance.  The two can be significantly different where a river estuary...