It is not just for performance...

ek-822869 (7/16/2010)

---

I am looking for a free tool/software to monitor Oralce queries similar to SQL Profiler and how to see the trace. Does anybody know about this. I have installed...

My personal preference is to use natural keys when possible when modeling general purpose or OLTP databases - while doing dimensional modeling I recognize the benefits of relying on surrogate...

Thank you for your kind words - glad to help.

david.c.holley (7/15/2010)

---

I'm building an Access FE for a SQL Server backend. We're in a situation where we're going to have 40 or so records that I want to available at...

FairFunk (7/16/2010)

---

How ever what would happen further down the line when it comes to implementing the design and if I decide not to roll up the subtypes to the supertype....

FairFunk (7/16/2010)

---

Currently I have a supertype > Subtype relationship set up with Organisation being the super type and charity, company and trust being the subtypes. The organisation Super type contains...

Spam! reported, please no replays.

May I try a more simple explanation?

How about a...

You can script PKs and FKs the same way you script tables or indexes; that would do it.

Post suggests each Department wants to run its own version of a generic database in its own server.

If this is the case you have to do nothing but installing SQL...

Are you trying to access SSAS locally?

If this is the case be sure both Browser Service and SSAS Service are set to login as "Local System" account.

You are most welcome Señor Jeff 😀

Microsoft may have what you are looking for.

SQLIOSim - formerly SQLIOStress utility is an I/O stress utility for SQL Server.

The idea behind doing test-stressing on storage is that I/O subsystem...

That's the problem, can't do data modeling without knowing the business including how data is used and...