GSquared (7/21/2009)

---

Lynn Pettis (7/21/2009)

---

GSquared (7/21/2009)

---

... Made the mistake of buying season 1 and 2 of Battlestar Galactica. Should have rented those. That was before my Netflix...

Thank you for the feedback.

GSquared (7/21/2009)

---

... Made the mistake of buying season 1 and 2 of Battlestar Galactica. Should have rented those. That was before my Netflix addiction kicked in...

While your at it, please format the code so that it is easier to read as well. White space is a freind to the eyes.

Then I suggest you contact RedGate as specified in 2.2.

Personally, I've never received any emails from sites I didn't personally visit and request, including TechTarget.

Looks to me like someone (not necessarily you, Tara) followed the advice of DTA without reviewing what it suggested. That index just duplicates your table. If you need...

Well ., you are back in time to see The Thread break 7000....

Sounds like data growth to me. Possibly have page splits in some of your tables and indexes.

JohnSQLServerCentral (7/21/2009)

---

I'm getting a little overwhelmed with these unsolicited emails from techtargetlists.com. I repeatedly unsubscribed over the past few weeks, but it appears that you keep adding new lists...

Okay, help us help you. Read the first article I reference below in my signature block.

Provide us with the DDL for the tables, sample data for the tables, expected...

Any index rebuilds or large data imports?

dba_pkashyap (7/21/2009)

---

there is also a bug in SQL 2005 with autogrowth when you restore a db or restart the services etc.

In the view sys.database_files is_growth_percent changes from 0-1, which means...

A guess:

Database size (in MB) Growth (@ 10%)

100 ...

bdragoo (7/21/2009)

---

Our primary DB is ~400GB, and the last time the .mdf primary data file grew, it expanded by 20%, instead of the 10% that it was set at. A...

Here is a third way to skin a cat:

select

t1.vendorid,

t1.vac1

from

table1 t1

left outer join table2 t2

...