Just truncate the table.  SQL Server will automatically handle the indexes.

Had the same problem.  Resolved by dropping and recreating clustered index.

The reason that the option to restore a transaction log is grayed out, is that the database is not in condition to accept a transaction log restore.  The database has...

You can do full database backups without messing up log shipping.  I backup all databases in full each day and do log shipping almost continuosly to my failover server.

Well, you have a couple of options.

1. When you want serverA back up, detach the databases from serverB and attach them to serverA.  Problem with this one is that usually...

Before you buy the bit datatype, consider that bit column indexes are usually valueless (because of the low selectivity of the column 1/0)

In addition, you'll only be able to make...

If you're doing lots of IO, then the best thing you can do (other than optimize your queries and indexing) is to add memory.  Looks like the SQL server has...

Since an order can have several status and a status can be in effect for many orders, the relational representation is:

Order table (OrderID PK)

StatusTable (StatusID PK)

and a resolution table OrderStatus...

SQL Server is applying the changes stored in the transaction log.  Your transaction log is probably very large.  Are you dumping your transaction log on a regular basis?   It's possible,...

What's interesting is that the error message refers to "linked server ('null')."  I wonder whether your linked servers are properly configure and whether the SERVERNAME is set on all of...

If you're asking as to whether you can change the text of a stored procedure without having to reset permissions, then "alter procedure" will do that.  If you want to...

There's likely to be a slowdown when the snapshot takes place.  I would suspect that it won't be much more than when you do a full database backup.  Whether the...

If you don't want to expose the sa password, create a user that has only the right to backup databases and run the isql command using his username and password.

Yes, Express Edition.  I assume that you're familiar with Windows Task Manager and writing batch files.  The call in the batch file is:

isql -Usa -P<your password> -S<your server> -dmaster -Q"dump database <your database>...

I do backups by using a combination of Windows Task Manager calling a batch file which uses isql to dump the database.