Ah, thanks. That's great. I don't want to miss out on the party.

Now, where's my boss........

I don't suppose there's any way to use 2 codes when registering?

I've got a code that gets me a massivly discounted rate (because I submitted an abstract for the...

Any fuinction applied to a column will prevent index seeks, even if it's something simple like column+0

Check the queries for unnecessary work been done or inefficient queries

Check the blocking on the server

Check for hardware bottlenecks (disk, memory, cpu, network)

It's SQL Server 2000 sp4 running on Windows Server 2003 build 3790, SP1.

the 8.0.2039 refers to SQL, the build and teh sp that @@version returns refers to the underlying operating...

Can you post the text of the stored proc?

If timestampstr is an automatically generated value, then it's easy. don't mention the column in the insert or the select.

It it's not autogenerated, then you need to find out...

If you need a point-in-time copy of a database that must survive hardware failures and natural disasters and exist for several months, then just restore a backup and set it...

I'm a little confused. Does this mean that the snapshot will be updated each time data in the source data file is changed?

Not necessarily. Sorry if I confused, let me...

No, because a snapshot is not a real copy of a database. It's a virtual copy where pages that are changed in the source database are copied to the snapshot before...

As GilaMonster says, check your perfmon counters on your disk i/o - I'd figure that was your problem.

My guess is memory is the primary bottleneck.

With frequent inserts, updates and...

One thing that I like about snapshots is the ability to combine then with mirroring and turn your inactive failover server into a reporting server.

As for on my production server,...

They might be blocking in TempDB, especuially if both are creating temp tables or running queries that require hash tables or work tables.

When you notice blocking, take a note of...

The only way to guarentee the order of a resultset from a query is to put an order by on the query. You cannot depend on the order that the...

Some comments on order by

SQL is allowed to ignore an order by in a subquery, if there is no top present. There is no order guarenteed in the following query.

SELECT...