If I understand correctly, you want objects in a particular schema to go to a dedicated filegroup. Unfortunately, there's no such feature.

Your best bet is a DDL trigger (example...

sql-lover (3/4/2015)

---

Watchout!

I also use...

It is in general.

Here's a link to the whitepaper: https://msdn.microsoft.com/en-us/library/hh372970.aspx

SSDs can really help improve performance, but it's not guaranteed that tempdb is what you want to put on that drive.

Probably your heavily written user tables would benefit from SSDs...

If you want a static copy of the data, use adOpenStatic when opening the recordset.

Your issues might come from modifications done by concurrent sessions.

Log files have a totally different I/O pattern compared to data files. On log files you typically have sequential reads and writes, while on data files you typically have random...

Shrinking the database in this case is ok: you need it, do it.

Backups do not copy empty pages, so the backup process itself will not be any faster.

If you...

Brandie Tarvin (3/3/2015)

---

Ed Wagner (3/3/2015)

---

Brandie Tarvin (3/3/2015)

---

Ed Wagner (3/3/2015)

---

Brandie Tarvin (3/3/2015)

---

Ed Wagner (3/3/2015)

---

Brandie Tarvin (3/3/2015)

---

Not to be weird, but...

YAY! I HAVE MY FIRST SUSPECT DATABASE!

It's a non-prod reporting database that...

You can grant the security policies using the mmc (start, run "secpol.msc").

It is recommended by the H-V documentation (and in general is a good idea).

Overcommitting memory means assigning to virtual...

You're welcome

Dynamic memory can be used with no issues. It just depends what you're after.

I use it on some virtual machines and it works fine. Make sure you grant the lock...

Can you please expand?

Hmmm, looks quite unlikely.

Are you sure you're getting suplicate values? How did you determine that?

Run the browser executable from a command prompt and post the output please.

Replace GETDATE() with DATEADD(day,-1,GETDATE())