Stewart Joslyn may have hit on something - not BLOB, but TEXT data types. See: BOL "text, ntext, and image Data When text in row Is Set to ON" &...

old data still present where? original page (invalidated pointer) and changed data written to a different page?

Since best practices SQL Admin/Development say do not allow direct access to tables, you may have already (or could) perform deletes through stored procedures which replace all the data in...

We have GroupWise, but I've not even wanted to go about installing a GroupWise client on SQL Server server. I've seen some posts here about using SMTP (vendor neutral) to...

Just created a new system this week. I used the same methods alzdba recommends.

I was doing a similar conversion as "proof of concept" project. The SQL 2000 server's "Copy Database Wizard" could not access the SQL 6.5's databases. I had another machine with SQL 7 on...

Though I don't use "network storage" technology, haven't a read in other posts here on SSC that SAN was the preferred technology over NAS and it even had a link...

sorry for not including previously.

Our "Engineers" were telling me just that - old PC technology, need to upgrade, get faster drives & more memory $$$. 1 index to create covered...

Though PC departments like to spend, spend, spend: "Need more this", "Need more that", "Need bigger other"... I've found problems are usually more software related than hardware related (unless you've...

Jim,

Though I don't pretend to be a SQL code guru and haven't put too much thought into someone else's code (others might clarify/elaborate on these questions/observations):

1. "select * into #deleted from deleted" - why someone would...

Jim,

"...it has about 25 users connect mostly entering in orders..." and "Not one table has a primary key or clustered index" would be my FIRST point of research.

Use Profiler to...

F.Y.I. muk07 - when asking others for help, it's not a good idea to spout back at them "It is not an answer". Not if you expect to get any...

Sorry for the delay.

I take it you had to restart the server? The way our system is set up, SQL Server does not start automatically on Windows Startup. The logical...

Don't have to restore often enough to require "scripting" it out. Sorry.

We use Legato Co-StandbyServer in active/passive SQL Cluster environment. Legato works in a low-level "hidden" mode mirroring disk drives and SQL configuration changes. We treat the "Active" node like a...