Glad it meets your needs. We've been running something similar here for 4 or 5 years and it's worked great for us!

The easiest way is probably to look at the Disk Usage report in SSMS. You can access it by right clicking on the database in question, selecting reports, standard reports...

Please check out the following, it should come close to meeting your needs: http://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/

You may need to modify it to accomodate your file naming standards but it should...

My Master's degree program won't let me use Wikipedia at all... If it doesn't come from the university library as a scholarly resource, use it at your own risk... 😀

fluffydeadangel (12/20/2012)

---

George M Parker (12/20/2012)

---

The primary difference is internal fragmentation versus external fragmentation. The Reorganize fixes external fragmentation when the 8k pages are physically out of sequence. The Rebuild fixes...

Totally disagree with the answer to the question.

"You can use UNIQUE constraints to make sure that no duplicate values are entered in specific columns that do not participate in...

The primary difference is internal fragmentation versus external fragmentation. The Reorganize fixes external fragmentation when the 8k pages are physically out of sequence. The Rebuild fixes internal fragmentation when there...

DKlein (12/7/2012)

---

I need to restore a database to a location that does not have enough space for the secondary data file. Is it possible to restore without the secondary data...

mani@123 (12/7/2012)

---

GilaMonster (12/7/2012)

---

Why?

Have you tested and...

Be wary of running sp_UpdateStats if you are regularly rebuilding your indexes. Rebuilding an index causes the statistics to be updated with a FULL SCAN. If you then run sp_UpdateStats...

You can also look into using the TABLEDIFF.EXE utility that ships with SQL Server. It can compare tables in two different databases and generate the scripts to synch the data...

sqlfriends (12/5/2012)

---

So if a database is set to read only , and by just querying the database, it won't create any log transactions, so no affect on log file, is...

capnhector (11/30/2012)

---

I have a question for the more experienced DBA's out there. im starting to develop queries and scripts that make administering the sql server instances i have (not...

Just be aware that the next transaction log backup will still need to include the extents that were changed during the index rebuild while in BULK LOGGED so it won't...

Great question and one that took some digging to determine the correct answers.