What are the exact values you are using to specify the max memory? How are you determining how much memory SQL Server is using?

You should use perfmon to determine...

Explicitly grant permissions on the schema, for example:

GRANT EXECUTE ON SCHEMA::myschema TO myroleoruser;

george sibbald (7/7/2010)

---

Jeffrey Williams-493691 (7/7/2010)

---

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

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...