Indexes on a foreign key have nothing to do with referential integrity, the foreign key ensures that. If you're suggesting dropping the foreign keys, don't.

As for whether or not you...

Table definitions, index definitions and execution plan please. Also the definition of all the functns used in there will help.

Is that distinct really necessary?

Then you can take any combination of file or filegroup backups and providing you have an unbroken log chain covering all of them, you can restore from multiple file/filegroup backups...

Normally you'd go a lot further into the design phase before considering physical implementations.

Warning: Since the DB is in simple recovery, you can take file and file group backups at different times, but you won't be able to restore them (unless all but...

Depends on IO throughput and database size mostly. A backup to my external drive over USB 2 is not going to be as fast as a backup to an SSD.

Grant Fritchey (10/1/2013)

---

GilaMonster (10/1/2013)

---

SQLRNNR (10/1/2013)

---

Good.

I'll...

Not at all. The mods have that position to keep order...

Report them.

If you only modify the table once a day, the 'disadvantages' are minimal as there aren't that many data modifications. It's when you have a lot of changes that you...

Nope. But have something in mind.

Please note: 8 year old thread.

SQLRNNR (10/1/2013)

---

Good.

I'll probably be late...

Keith Tate (10/1/2013)

---

Actually RCSI is the "big hammer" approach to snapshot isolation. Once turned on it will change all queries that are currently running in read committed isolation level (which...

Cartesian products aren't things that help 😉 This is a cartesian product:

SELECT <stuff> FROM LargeTable1 CROSS JOIN LargeTable2

You get a huge resultset with a number of row equal to the...