Cliiford Stoll's "The Cuckoo's Egg" was a 1990 compuetr spy thriller. Very good read.

I always found it strange that the first thing that businesses did when they bought Oracle was to go and hire a DBA. Why because it was expensive and perceived...

If you have GO statements, edit the script replace GO with GOXYZ (or something else). Run the script and then you will need to edit each job step with the...

Have a dig through the sysindexes table for the user database. Ideally each table should have at least a clustered index (indid =1). As a very rough real of thumb...

You should look into why you transaction log filled. What is your database recovery mode?. If it is full then you should be backing up the transactionlog regularly. If simple...

Terry,

I have used rebuildm to change the sort order on an incorrectly built server - took less than 10 minutes and then I just had to reattach the user databases....

From home can you ping the SQL Server? If so then you can register via the IP address with port if its not 1433. If you need name resolution use...

For a large number of servers - you really need proactive monitoring of your hardware, disk space and SQL Server jobs.

Once everything is in check and running fine get...

Firstly are you sure you got a deadlock? You got the message that your transaction has been chosen as the victim? Just want to be sure as a lot of...

Nothing in the min dump explicitly points to a memory error, but it is only dumping out what is in memory at the time. I agree that the memory module...

There are different service packs for SQL (Standard and EE editions)  than MSDE - you may need to download the MSDE SP3a and apply that.

Is there anything in the SQL error log that may indicate resources being used up.

How much memory do you have in the server and how much is going to SQL.

Also how...

Further clarification.

Delete is a physical delete - each row gets deleted and logged.

Truncate is a logical delete that deallocates the extents used by the table, marking them as empty for...

Creating view on top of view is inherently ineffecient. You are better off creating a new view referencing the underlying tables. Also be aware of broken object ownership chains.

Also check to make sure who has created objects. You may need to change object owners as well.