SCDW/DTS:   Primary 6 tables that SCDW data is retained in: SC_AlertFact_Table SC_AlertHistoryFact_Table SC_AlertToEventFact_Table SC_EventFact_Table SC_EventParameterFact_Table SC_SampledNumericDataFact_Table Commands to execute to modify the data...

Last updated 10-12-10     Large Table query .   (I am putting this at the top, because I use it so much – to find out what is taking up so much space in the OpsDB or DW) SELECT TOP 1000 a2.name AS [tablename], (a1.reserved + ISNULL(a4.reserved...