What service pack level of 2005 are you running?

In any case, why not just detach the database from 2000 and then do an attach for 2005? If you're using...

In case it doesn't fill in the application name (as it's usually a property of the connection string) you could still look to see which database the query is being...

Could you run SQL Profiler against your database and see which queries are taking the longest to execute? From that you could see if you have

a) Poor indexing on...

The google-powered search on this site works wonders... 🙂

Search for dates gaps.

See these links

http://www.sqlservercentral.com/Forums/Topic145928-197-1.aspx#bm437872

http://www.sqlservercentral.com/Forums/Topic452000-356-1.aspx

Finding gaps and reporting ranges is a commonly discussed issue with many solutions...

How many extra transactions are there in your db after the delete happened?

Might it be easier to

1. Run some transaction detail reports in your db as it stands

2. Do the...

The database SET options for indexing a computed column and creating an indexed view are exactly the same.

Easy fix - just set your default server SET options and then all...

I had to install SQL Express (gasp!) yesterday. The download already had SP2 🙂

I suppose MS go to the trouble of allowing Windows to be slipstreamed because you tend...

Create a covering index to avoid the lookup. If you post some sample data and what indices you currently have we'd be able to offer some more targeted advice.

When in doubt, use the GUI tools to investigate what it thinks exists in backups, then use its scripting feature to script out your backups and restores. This way...

Chances are you are not using the same user account in query analyser as you're using in your VB6 application. Log into query analyser using the application's user account...

As Jeremy explained, you cannot do that. You'll need to use a temporary table rather than a table variable. Temporary tables have a wider scope - they'll be...

If I'm interpreting your logic correctly you should just get rid of the ELSE and you'll be fine. Actually, try this

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER TRIGGER [trig_updateOrganization]

ON [dbo].[OrganizationDetail]

FOR UPDATE...

If SQL zeroed out the data pages when you deleted data then deletes would take a while 🙂 It's the same reason why you can "undelete" files on your...

Silly question, but how much more data do you have in production compared to your test environment? Is your test data obviously fake test data such as lots of...

Oh, and you should probably read this article http://www.sqlservercentral.com/articles/Best+Practices/61537/ - a good name for your post would go a long way to getting people's attention for your question...