SkyMac (7/21/2013)

---

I know this topic has been talked a lot but, i'm having this issue right now, the Developers team at work want to start using Entity framework, and that...

Intersect is your friend.

Best answer yet ChrisM, provided he is on a version that supports it.

GilaMonster (6/19/2013)

---

Will the users be happy if the data that the queries return is...

There are some business and potentially legal reasons behind the decision. I have not personally used partitioning but I know what it is and I'll brush up on the topic...

William Plourde (6/20/2013)

---

Yep, that is correct. Assuming 6 dbs out in the future. A person (and...

mayurkb (6/19/2013)

---

ARITHABORT doesn't really do anything. It is just a setting, you can set it off from the tools->Options. Once you do that you will see the same plan that...

free_mascot (6/18/2013)

---

It depend on the query(what you are executing?). But definitely if table is having index and view is having huge data and you run a query without index on...

Necro post much? Its over a year old this thread.

kk.86manu (6/18/2013)

---

Thank you All for your suggestions.

If there are no performance difference between a view and querying from a fact table then What are the advantages of creating views in...

I tend to create 3 tables for this excercise. The first table defines the "Account". A non data related PK, first name, last name. Real simple stuff...

I would also add, that depending on a lot of variables like size of the field, number of rows, density etc, Full Text Search (FTS) might be considered as well.

Assuming you have down time, my suggestion would be:

Merge all your tables into one table with no constraint, with an additional column indicating the source database/table it came from. ...

If this...

Lynn Pettis (4/15/2013)

---

Not true, using advanced...

One thing to bear in mind, the Generate Script does NOT include any column COLLATION settings. These still have to be set manually.