Usually the C drive should only be reserved for Windows. Any other Application, including SQl should be installed on, lets say D with the Database files on others.

You...

We have a database DDL trigger in place that records any changes made to any object. This allows to rapidly go back to a previous version if something breaks. Developers...

homebrew01 (4/26/2010)

---

So ... you would advise against creating a...

... just realized that when I saw your post... 🙂

In any event, seems the OP has other issues at hand here....

You might want try running that dmv with the 'LIMITED' option:

FROM sys.dm_db_index_physical_stats (DB_ID(' DB '),OBJECT_ID(' Table'A' '),NULL, NULL, 'LIMITED')

as it will have better performance, specially if it is a big...

Dave, great article. very detailed and nicely outlined. Kudo's......

You can also use 3rd party backup software like Quest LiteSpeed, Red Gate SQL Backup Pro or Idera SQL Safe backup which allow you to get a compression of about...

I know that, but when you have a TB database size, compressed down to about 207GB... that still would be about 52 files!!!!

Toby White (4/12/2010)

---

Redgate and quest also provide object level restores with their backup solutions. Additionally Quest offers the ability to save a backup as a self extracting .exe file that...

Gary,

what disks are those? 30 hours for 550GB seems to be EXTREMELY slow. We backup natively with SQL 1 TB in about 2.5 hours on our SAN.

...

....an even scarier thought is such a long database recovery chain.... if any of the log backups in the interim is kaputt, you can only go back as far as...

You should probably just leave the default format and pick out the columns you need:

DECLARE @tasklist TABLE (taskname NVARCHAR (500))

INSERT INTO @tasklist

EXEC xp_cmdshell 'tasklist'

DELETE FROM @tasklist WHERE taskname IS NULL...

Great article Paul! Looking forward to next weeks article.

For 80 CALs + Server License you'd probably pay more than 2 CPU Licenses....

If it is only 1 CPU, then per CPU license is definitively the way to go.\So, in...

The way you are running it, it will still do it on all the objects in that database and then only return the results for the Invoice table.

You might want...