If you type CRTL-SHIFT-M or select Edit - Replace Template Paramters on the menu, Query Analyzer will pop up a window for you to enter a replacement value for each...

BCP (Bulk Copy Program) can (among other things) create a text file with the results of any query you want to write (although it is easier if you put the...

Without commenting on whether its a good idea to do this, and stipulating this is only for development (having multiple users running this simultaneously would be a really bad idea),...

If you run log backups more frequently they will not have to grow as big.  Try once an hour.

When you do a log backup the log is logically truncated but...

I use a zipcode table with a clustered primary key on zip5+zip4, and secondary indexes on latitude and longitude.  A properly-constructed query with BETWEEN conditions is the fastest, but you...

You probably don't need the full accuracy, especially since you're talking about some location (geometric center?) in the middle of a zipcode and not individual lat/lon for 9-digit zips.

But you...

You can't use simple geometry for latitudes & longitudes.  To begin with, latitude is constant anywhere but the size of a degree of longitude changes with latitude.  A better approximation...

It looks like this shouldn't happen, according to BOL:

Transaction boundaries are preserved. If, for example, 100 rows are updated in a transaction, either the entire transaction with all 100 data...

You can figure out how to get this information from the system tables, but since this is the Programming forum I think what you're looking for is SQL-DMO like Andrew...

If the fields on both sides of the comparison are nullable, and you want to consider NULL = NULL to be a match, you can use ISNULL on both columns with...

I went to PASS last year and it was definately worthwhile.  I would be going this year but phb thinks its somebody else's turn to get a trip.  I thought...

In addition to the excellent suggestions in the previous posts:

Enterprise Manager and SQL Profiler should help you see what queries cause blocking, query duration, and lock lifetime.  But if you don't want to...

Jesper: My orignal comment to Mark was to try to help him evaluate alternative queries that he may not immediatly understand.  If the benefit of the alternate version is not obvious,...

Mark:  If someone suggests a different query might be better, or you can think of two or more versions yourself but can't decide which to use, put both versions in...

Check Management - Current Activity - Locks / Object in Enterprise Manager to see what else might be going on in the database.

If all else fails, restart SQL Server and see if...