While it is fun conversing about the situation and the brain storm sessions about it, it'll not be fun for Gail.

As much as I have the impression supporting software vendors...

Actually you've posted a nice example on how partitioning with sliding windows can help out very much when trying to keep "current" tables small and not losing online data with...

I think your only resource then would be

DBCC ind ( <database_name>, <table_name>, non clustered index_id*)

Have a look at Paul Randal s blog for more info of dbcc...

IMO you are fooling yourself by using the wrong PF with the correct table in your select query.

SELECT *

, $PARTITION.AnnualDateRange_PartitionFunction(OrderDate) AS PartitionNumber

,...

Have a look at "Managing Space Used by Objects" for the internals, how the engine manages it all.

Have a look at the poster Aaron Bertrand points to: http://sqlblog.com/blogs/aaron_bertrand/archive/2009/01/28/sql-server-2008-system-views-poster-is-now-available-for-download.aspx to get...

I've been out for the day :Whistling:

Anyway, any rollback statement will undo your whole transaction (including the original inserts and other stuff in the same transaction scope), so be careful...

did you manage to get your install corrected ?

just came across this art today at sqlblog : http://sqlblog.com/blogs/davide_mauri/archive/2011/02/13/sys2-scripts-updated-scripts-to-monitor-database-backup-database-space-usage-and-memory-grants-now-available.aspx

Maybe this can help you out.

I thought he was whispering it and SSC doesn't supply...

a trigger is declared on an object and objects don't share triggers (afaik).

So you'll end up creating the trigger ( same or different content ) as n triggers, at...

1) are the spaces ( after % and before the second % ) in your patindex needed ?

2) I would use datalength(pattern) in stead of len.

This is my ref url for mirroring:

http://support.microsoft.com/kb/2001270

monitoring state changes

http://msdn.microsoft.com/en-us/library/cc966392.aspx

Follow up is based on these scripts:

/*

* DB Mirroring : followup

*

*/

/* show mirrored databases and their mirror-state */

Select db_name(database_id) as...

Like Sean stated, many of us have been bitten by the "single row situation"-design of many triggers.

You should ( and I don't like to use "always" nor "never") in all...

did someone mention cheap USB-dr.... :slap:

but .. but .. :slap-again-harder-and-harder:

😉

Craig Farrell (2/11/2011)

---

...On another note, it's 2 in the morning and I'm still watching this job go so that I can get a project up to QA in the morning....