I usually look for filegroups creeping over an arbitary threshold, in this case 90% full, with something along the lines of:

DECLARE @PctFullThreshold SMALLINT 

SET @PctFullThreshold =...

I'm afraid you can't use a variable in this manner

Cheers,

- Mark

Steve,

Actually a table spreads itself across the filegroup to which it's assigned.

Jarretg,

I've seen this happen before, but not as radically as your example. It's mainly due to the order...

Back to barking up the "shrink" tree .... maybe an explicit DBCC shrinkfile/shrinkdb after the 5am deletions will force the background ghost cleanup to do its...

So much for that theory.

How about a Maintenance Plan job (with "remove unused space") maybe scheduled for the wrong time of day. Or maybe some other scheduled shrink?

Cheers,

- Mark

As well as removing "about" from the noise words list, I think you'll have to rebuild the FT catalogs.

While it's been in the noise words list, "about" has...

Is the database set for autoshrink?

Cheers,

- Mark

If your query plans are identical then I assume they're both (clustered) index scans.

I would suggest that the CASE statement is introducing additional CPU (try profiler to confirm or refute...

Yes, it would be a performance problem, but to what extent I can't gauge. It will be particularly inefficient if the primary key columns are volatile (ie. updated frequently)....

bj007,

Is customercode in fact a unicode column? (ie. nchar or nvarchar). If it's char, varchar or anything else then a conversion has to be done, so an index...

Hitendra,

When you have databases in full recovery mode (which it appears you do), it's important to schedule regular transaction log backups. This backs up and then truncates the inactive...

I wouldn't rely too much on WITH ENCRYPTION for your truly top secret code. The encryption algorithm is fairly easily cracked.

Cheers,

- Mark

Edited by - mccork...

I've sent all my SQL 6.5 servers to the recycle bin, but I think the syntax is:

DUMP TRANSACTION YourDBName WITH NO_LOG

or

DUMP TRANSACTION YourDBName WITH TRUNCATE_ONLY, NO_LOG

If these fail, you might...

Over here I've seen companies use the MessageNet email-to-SMS service, and then set up Exchange entries pointing to the relevant STMP addresses (eg. 0414555555@messagenet.com.au). SQL Mail could then send...

Phill,

tkc has indicated what /* various fields* / and /* various parameters */ look like.

I'm assuming they're quite longwinded.

Cheers,

- Mark