Ninja's_RGR'us (1/31/2011)

---

Here's a question I ask myself when I feel like using hints :

Am I really smarter than the best MS engineer who had 10 000s of hours to...

Books Online, the documentation that comes with SQL Server, should be open on your desktop most of the time. It sure is on mine.

After that, you've got here at SSC...

I was bad. I was very bad. Just had to slap down a poster, couldn't help it. "Hey, I need a complete system design, thanks." Man I hate those.

I would ditch all the query hints entirely. Using hints you're forcing the optimizer and the query engine to do things your way instead of letting them figure out the...

I have to say, you're asking for a complete system design on a rather complicated set of requirements, which you haven't completely provided. Many of us are paid to do...

Another problem is cross-database dependencies. If you have lookup tables in different databases, you can't use declarative referential integrity, foreign keys, to ensure the consistency of the data. You'd have...

My general approach is a little different than others. I tend to cluster on the most frequently accessed path into the data that is also selective enough to index well....

There's no magic way to to do it. You're going to have a bunch of work in front of you. The easiest part is creating the blank database. You can...

Perfmon is measuring the memory used. Task Manager is, I believe, showing you the size of the executable, not the memory allocated for it.

That's a formatting issue, not a data storage issue. You should deal with that on the client side, not in your database.

Without using a third party tool, your only option is as described above, a full restore to a different location or a different database and then migrate the tool over.

You...

free_mascot (1/31/2011)

---

When you are transfering large data to new table; I suggest you create just basic structure of the table i.e. without indexes, rules etc.

Once transfer is done you...

I would create a role to assign the users to and then assign that role to ddladmin, data_reader, data_writer, and security_admin for the database. That last role is probably the...

The hint when applied to a query will take precedence.

Wow... That's a rather large query. A couple of notes. You have NOLOCK all over the place. Yes, that prevents locking, but it can lead to bad data being returned...