Remove data in the db or compress the backup.

Option 1 may look ridiculous but sometimes you don't need to keep data as far back as 10 years... maybe 2 is...

I'm with you here. There's no point to have them on prod servers but there's definitely a possible need for them on dev server (especially if you're learning BI).

As...

GilaMonster (9/21/2010)

---

Didn't miss it, but was trying to get out to usergroup meeting.

I wouldn't recommend changing compat level. Could cause queries to change behaviour or break. However, what people often...

GilaMonster (9/21/2010)

---

Ninja's_RGR'us (9/21/2010)

---

Is there a way to take a backup of prod and restore on a dev / test server to be able to run the "Indexes used by Queries"...

GilaMonster (9/21/2010)

---

You forgot to attribute some of those queries to the people who wrote them

What queries are using the indexes: http://www.sqlservercentral.com/Forums/FindPost966688.aspx Jonathan Kehayias

Missing indexes: http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx Bart Duncan

Unused indexes: http://blogs.technet.com/b/vipulshah/archive/2007/12/04/finding-missing-indexes-and-unused-indexes-using-dmvs.aspx ...

GilaMonster (9/21/2010)

---

You forgot to attribute some of those queries to the people who wrote them

What queries are using the indexes: http://www.sqlservercentral.com/Forums/FindPost966688.aspx Jonathan Kehayias

Missing indexes: http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx Bart Duncan

Unused indexes: http://blogs.technet.com/b/vipulshah/archive/2007/12/04/finding-missing-indexes-and-unused-indexes-using-dmvs.aspx ...

TheSQLGuru (9/20/2010)

---

Virtually everyone is STUNNED when I tell them about how few rows it takes (1-2% is common) before the SQL Server relational engine will switch from index seek/bookmark lookup...

where Datestamp >getdate() - 'sep28 1902 12:00 AM'

I highly doubt that this will ever do anything but a scan untill that value is changed to something much more recent.

GilaMonster (9/20/2010)

---

Covering index is not a feature that's available in some versions and not in others. It just means that...

GilaMonster (9/17/2010)

---

Thank...

Lowell (9/17/2010)

---

upgrading an installation form SQL 2000 to SQL 2008 is as simple as running the msi and clicking next 5 or 6 times;

there is no reason to upgrade to...

CirquedeSQLeil (9/17/2010)

---

Brandie Tarvin (9/17/2010)

---

gonickl (9/16/2010)

---

I think it's interesting that the sheepization, I mean monetization proposals here were all based on making a tangible object, until I suggested a subscription model....

GilaMonster (9/17/2010)

---

My personal favourite...

Brandie Tarvin (9/17/2010)

---

GilaMonster (9/17/2010)

---

My...

Brandie Tarvin (9/17/2010)

---

GilaMonster (9/17/2010)

---

Brandie Tarvin (9/17/2010)

---

You can't shrink other databases while the disk is full. SQL Server requires space in which to do the shrinking, in which to add markers...