Deleting 5000 rows at a time, no matter how long it takes, is a vast improvement over failing and rolling back because the log completely fills the disk.  The database is already...

I also applaud Alain's detailed comments, but I have a quibble.  This is a SQL 7, 2000 forum and the ALTER TABLE ... ALTER COLUMN IDENTITY() statement was introduced in SQL...

This website is a good place to start.  There are other websites, like http://www.sql-server-performance.com/

Microsoft has a lot of information and blogs.  Books Online has a lot of good information. ...

I would rearrange your list and put DBCC DBREINDEX at the top.  I generates a huge amount of log information, sometimes as large as the database itself.  If you think...

You can look at the graphical execution plan in Query Analyzer (select SQL statement or statements and press Ctrl-L) to get some idea of what part of a query is the most...

Users and logins are two different things.  Users are copied with the database when you restore or attach it to the QA server.  Logins must be copied over by scripting,...

The sp_MSforeachdb procedure does some bizarre things with global cursors, my guess would be there is some interaction between it and the sp_executesql or the backup commands.  Rather than holding a...

You can get everything you need from the INFORMATION_SCHEMA views, if want to avoid using system tables that may be version-dependant.

SELECT k.*

FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE

If your tempdb log isn't alone on the disk, it's possible that something else ate all the free space without generating a message and you didn't realize it.  Even if...

Maybe you missed this important aspect of SQL functions?

"User-defined functions cannot be used to perform actions that modify the database state."

There may be workarounds (I'm not talking), but you need...

If you are running .NET 2.0 and add the MultipleActiveResultSets=True attribute to the connection string, it should work.  Your error message sounds like you were trying to re-open the open connection. ...

I have no problem getting SSIS packages to use config files from common folders.  But SourceSafe doesn't maintain separate paths for each file in a project, if you bring the...

Assuming you opened a connection with the MARS=True attribute:

Using

cnn As New SqlConnection("Persist Security Info=False;Integrated Security=SSPI;server=xyz;database=abc;MultipleActiveResultSets=True")

The most significant disadvantage is that 32-bit SQL Server will not be able use as much memory.  This may not be an issue if your server has 4GB or less...

A table exists in only one filegroup.  The table and the clustered index are inseparable, so creating a clustered index on a different filegroup will move the entire table to...