1. Create daily/hourly job that will record log total and used size to some table.

2. For several days, constantly run server-side trace which will capture processes with duration > xx...

"Estimated Subtree cost" at the leftmost icon

1. When you just started shrinking check whether shrinking is blocked

2. Check for heavy processes running on your server. If you have multiple instances, check of all of them.

3. Check...

Kurt W. Zimmerman (3/26/2014)

---

GilaMonster (3/26/2014)

---

You said the production DB has initial size of 15GB, what's the actual size of the data file on disk?

Edit: Native backups? What's the backup command?...

It is possible only if you will add ColumnA to the clustered index.

In order to find the reason, run RESTORE FILELISTONLY from the same source which you use for actual restore. It will show all file sizes in bytes

That was rather simplified example. In reality I have a table with 150 mln records, and it is partitioned by integer column (it is some ID and clustered primary key)...

Do they have similar function for run_duration ?

You can place a condition inside of your T*SQL code : RAISERROR(...).

No, server is the same. Databases are different. It is not related to DR.

I backed up a file from a database A and want to restore it to database B...

That powerfull rule engine is SCOM - System Center Operations Manager.

I don't have Outlook in my home MS Office set. Any other methods to archive ?

Thanks

Thanks, Jeff and SQLRNNR.

That's interesting solution. But the problem is that at work they block access to yahoo mail. I have officially licensed MS Office 2007 or 2010 at home,...

Code is very large. In the result set, column list is tabbed to the right some 700 character positions. After running for a bout 2 min, it returned 20k+ rows...

Can you elaborate more about manageability ?

About performance: all your partitions placed in the same filegroup. If you have 1-1 between FG and files, you can't achive performance gain because...