Prev: BUY FAKE PASSPORTS OF AUSTRALIA,FAKE AUSTRALIAN PASSPORTS FOR SALE
Next: ROLLBACK on error
From: TheSQLGuru on 24 May 2010 23:22
It is a strategem that has probably existed since cave men first started
collecting rocks. :-)

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Bob Barrows" <reb01501(a)NOyahoo.SPAMcom> wrote in message
news:u5PEED0%23KHA.5224(a)TK2MSFTNGP06.phx.gbl...
> Ah, the old delete-it-and-see-who-complains strategem :-)
>
> TheSQLGuru wrote:
>>
>> If your SLA allows it, just generate scripts for detach/attach of all
>> databases. Start picking 100 at a time or so and detach them. When
>> you get a support call, 10 seconds later the database can be ready to
>> go when you execute the attach script for the appropriate database.
>> Many people will laugh at this, but it is actually is a viable
>> strategy for some entities. I will note that before I do that I
>> would use the index usage stats DMV to narrow down the hit-list. :-)
>>
>>
>>
>>
>> "sChapman" <sumanthcp(a)googlemail.com> wrote in message
>>
> news:6c0e3ebd-3791-431e-a8a0-ed304cf7d227(a)m33g2000vbi.googlegroups.com...
>> On 18 May, 18:55, "TheSQLGuru" <kgbo...(a)earthlink.net> wrote:
>>> Just a general question: why don't you jus add more space? :-)
>>
>> That is not possible in our environment, we have 5.6TB capacity and we
>> have around 2000 databases! we run out of space quite regularly.
>> Adding more space increases costs (impacts backup capcity etc.) and
>> makes it harder to manage the huge size/number.
>>
>> We are using Sql Server 2005. We can not move to 2008 as yet as the
>> software we use does not support 2008.
>
> --
> HTH,
> Bob Barrows
>
>


First  |  Prev  | 
Pages: 1 2 3
Prev: BUY FAKE PASSPORTS OF AUSTRALIA,FAKE AUSTRALIAN PASSPORTS FOR SALE
Next: ROLLBACK on error