_ms65g_ (7/13/2010)

---

Could you introduce an article about values of data integrity and enforcing and implementing it?

And Do we must implement it with using DDL or we can implementing it at...

As a DBA you are responsible for: Database integrity, Recoverability and Performance - data integrity is part of your job...

Allow me to propose an alternative point of view.

I'm particularly not a fan of logical deletes - on the long run logical deletes approach causes tons of issues mostly related...

If you are able to do it manually you are able to script/schedule it.

Just do your manual thing, script every step, create a job and schedule it.

It should be a...

azadsale (7/12/2010)

---

but if there are 4 data files and there is only one filegroup (primary).now if there is insertion going on.so the data will be divided between 4 files.i mean...

Question #1 is... is the client looking to really use it as a single helpdesk application or just wants (because somebody had the brilliant idea) to put the two databases...

Arie Jones-435881 (7/1/2010)

---

Sorry but that is simply not the case. Shemas are 'normally' allocated in blocks to group the logical data elements together.. that part is true. Much like you...

GilaMonster (7/8/2010)

---

Agreed. Exactly what I was thinking.

In my experience different database names minimize the chances of expensive - some times catastrofic errors and mistakes happening because somebody got confused.

We do have a naming convention that clearly...

A query retrieving a unique row by PK should be a subsecond query don't matter if the table has 1 million or 1 billion rows.

Would you mind in tracing the...

No doubt a select statement on a single table will show no overhead because...

PugMaster (7/7/2010)

---

I am not sure how to maintain the relationship between Fact and Type 2 Dimension.

i.e if a new row is inserted into a dimension table as an updated version...

8kb (7/6/2010)

---

Thanks for your response...can I ask a follow-up question? (and maybe this is more philosophical than technical, but I'm curious to hear your thoughts)

You refer to this method as...

ps. (7/7/2010)

---

These jobs are running fine as of now. I need to capture the output of these jobs (including detailed messages) into a temp table.

1. What structure should be best...

FKs certainly add overhead but I would refrain myself of saying that FK implementation is fatal in...