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

...

So change it again:

case when servcdate < CONVERT(datetime, '20040101', 112)...

Don't know. What is the error? You need to find and read the maintenacne plan log files.

Read this article How to Post Performance Problems[/url].

Follow the instructions in it regarding what needs to be posted so that we can provide you with better answers.

Without that information the...

Personally, I think Lowell has given you what you need to develop a set-based process for copying the records needed from one set of tables to another. I think...

Yes, you could potentially make the view an indexed view. You really need to read about those in BOL (Books Online, the SQL Server Help System) before going down...

Now that the Star Trek Universe has been altered, they have opened the door to new series and movies. I wonder how these things will pan out in the...

Was on a staycation for the week and didn't visit the forums often. Thanks for the feedback. Glad we could be of assistance.

Your question is fairly vague. What exactly are you looking for?

Why are you shrinking your databases? One, this will cause excessive index fragmentation. Two, the files will simply grow again when the database needs more space that will...

Okay, thanks for a partial setup, but please look at how I am presenting my code, including the DDL for the tables, the insert statements with the sample data. ...