If you've only deleted a few million records from a database that size, why shrink the database?

You're probably only going to have to see it expand again as records are...

http://www.microsoft.com/azure/sql.mspx

hth

Update statistics might be an idea too

Chris (8/18/2009)

---

Hi there everyone,

My employer has purchased an ERP with an off the shelf database of over four thousand tables. Even the vendor doesnt have a diagram of it. (So...

Mind - a good point earlier - some index maintenance (SQLFool has a very well regarded script for reorganising and rebuilding - and there's some very good stuff on here...

Briefly.

Why do you want to shrink your database file? Do you have a pressing reason such as a critical discspace shortage that can not be addressed any other way?

Assuming...

StyleCop is a C# tool.

If you're looking for a way of refactoring SQL code to meet specific style rules - look at SQL Refactor from Redgate (which I've used and...

The way hte online rebuild works, as I understand it, is that the system effectively takes a copy of the current index, and uses that for queries while rebuilding the...

There are really too many variables at play here to give a definitive answer there. However, have you checked your disc partition alignment on the RAID array? If...

Marios Philippopoulos (5/8/2009)

---

Grant Fritchey (5/8/2009)

---

Actually, if it's still in sys.dm_exec_sql_text and in sys.dm_exec_query_stats, then it's still in cache. It hasn't aged out yet. If it were not in cache, then...

Marios Philippopoulos (5/8/2009)

---

Grant Fritchey (5/8/2009)

---

Actually, if it's still in sys.dm_exec_sql_text and in sys.dm_exec_query_stats, then it's still in cache. It hasn't aged out yet. If it were not in cache, then...

No, plans get aged out if there is no more memory available in plan cache due to the need to hold plans for more recently used queries. This is...

Have you checked out Gila's sqlinthewild stuff on indexing?

Have you tried running sp_who2 to see if there's anything blocking the shrink process, or killed all processes using that dB?

I can think of one particular example who has about 500+ posts, and every one I have seen has been dross, positively dangerous, or "Yes, that is good advise". ...