The issue with switching to SIMPLE recovery model is that you break the log chain. By doing that, if your current backup is corrupted - you will not be...

Do you really need the report files? I turn that feature off since I have found that the report files don't really have any useful information.

Nope - the only files that are written to sequentially are the log files. If you have multiple files in a single filegroup, they will be written to using...

Indianrock (7/6/2010)

---

Looking for options. I'm considering the need to go to simple recovery mode during our weekly reindexing maintenance window. Our systems team handles backups with Commvault Idata...

Leo, I believe you don't have to use a different filegroup to add a file on a different LUN. You can have multiple files per database - with each...

You use DBCC SHRINKFILE with the EMPTYFILE option. Once the file is empty, it can be removed.

Well - the standard answer applies here: it depends...:-)

It depends a lot on the SAN that you are using, how that SAN has been configured and how the LUN's are...

The point Paul was making is that column placement doesn't matter. Since you reference columns by name, their order in the table has no bearing on performance or storage.

At...

I would use powershell to loop through each file in a directory and pass the file to sqlcmd if I had to use those scripts.

If I could use an existing...

Sometime after the full backup was taken - the log chain was broken. Once that happens, no further transaction log backups can be taken until the log chain is...

The Dixie Flatline (7/2/2010)

---

There are lots of variations that will work.

Here's another that gives you a six-character string in the format YYYYMM.

...

You can add your domain account to the SQL Server specific local windows group. That group should have sysadmin rights and allow you to login to the system to...

It looks like you are using a global temp table. The temp table has a constraint on column XXXX which does not allow null values.

First, why are you using...

I am going to agree with the others - mostly.

IF you are using SAN snap clone technology that is configured to work with SQL Server and freezes SQL Server during...

I use the Performance Dashboard in SSMS 2008 with no problems. I know there are a couple of issues running the reports against a 2008 system, but for the...