Steve.hitch (2/25/2011)

---

I worked on the IBM AS/400 system for years. When I created a file and built key fields, the default was unique keys. You could override that and say...

Steve.hitch (2/25/2011)

---

I would like a key or index on employee and transaction date. However, the data is not unique, so I can't make them primary keys. If SQL could have...

abotha-1117340 (2/25/2011)

---

I have a situation where I want to delete some records on a Oracle DB from a SQL Server DB via a linked server. The SQL command is called...

Rookie R (2/14/2011)

---

I am bit confused... I know we develop OLAP using Fact and Dimension tables. Do we call the database that contains Facts and dimension tables as a datawarehouse?...

FACT tables should store data at granular level, aggregations can be done either on-the-fly or in cubes for recurrent ones.

Interesting choice for a new Data Warehouse - nothing wrong about it, just interesting.

In this particular case basic indexing should include...

1- Unique indexes on all PK constraints on...

MonsterRocks (2/21/2011)

---

I have login table.. which consists the follwing columns

user_id int autoincrement primary key

user_name varchar(30) unique key

password varchar(30)

:

while login i checks

select * from ...

John.Liu (2/21/2011)

---

temp table is created in TEMPDB, unless you already in the TEMPDB, you have to...

May I ask how big is the database?

Also, may we know how much t-log gets generated per minute/hour/day?

sqlgreg (2/21/2011)

---

Well, I was gonna start a new thread on the linked server issue, but whatever fiddling was done by the admins on the servers over the weekend has apparently...

diamondgm (2/20/2011)

---

There will probably be people who object to the use of "WHERE IN (SELECT...)" as opposed to using joins, but I am illustrating a principle and not which manner...

I usually use syntax below...

if exists (select * from sys.tables where name like '#mytemptable%')

drop table #mytemptable

create table #mytemptable(table definition as needed)

Please replace "mytemptable" with the appropriate name.

Just to rule out most likely suspects please check...

1- Query is written using four-parts-names.

2- There is an unique index on target table.

3- DTC is setup and running.

Please allow me to start one step before the indexing strategy.

What DWH model are you following? is it a Star schema or is it a Relational model?

For basic indexing,...

Oh yes... I know what you mean, they are delicious...