Exotic food - Yummmmmm.

Fried Alligator tails

Fried Conch

Fried Rattlesnake

Raw Rattlesnake

Elk

Moose

Bear

Raw Sea Urchin

Camel

Reindeer

Pigeon

Horse

Eel

Fried Octopus

Fried Squid

Grilled Squid

(note on Octopus and Squid - if you really want to have fun, stick the tentacles to...

When my son caught chicken pox, the day care called me to pick him up at 11:00am. At 1:30pm my manager called me at home and asked me when...

Once I received a phone call from the former CEO of my company (he retired and moved to another state but remained as a consultant of my company) on Friday...

Matt,

My query is not involved one table, it joins 4 or 5 tables, so how am I going to put a cluster index?

So Jeff, what do you think which solution is the better solution and do you have a better one yourself?

You are right, the problem with using ROW_NUMBER slows everything down.

What are you trying to design anyway? a database model, a data flow diagram, a business model ?

Data warehouse is different concept for regular transaction database, unfortunately not many companies or people realized that. In most cases, many companies just put a sql developer to build...

Since you already have a DateID in the fact table, you don't put last month's data in the current month fact table.

So the fact table should look liked

ID

PRODID

DATEID

DISTID

TotalSales

If you want...

What does CureentMonth1.....CurrentMonth-11 mean ?

What is the DateID in the fact table doing? What does it represent?

If the shopper database is small, it has no problem, but if there are more than 2 million shoppers, right now they put it in LDAP database because when it...

The system is already existed but my company tries to re-write it. The reason is the existing system cannot handle more than 5 million shoppers.

The system is a basically...

The current shopper table was developed by the web developers so it was terrible, no foreign key to other tables that used shopper id.

Here is the old shopper table.

CREATE TABLE...

I totally agree to that. Besides the technology changes so...

Yes Jeff is very knowledgeable about SQL server and he yelled at me a lot too.:)

Mark

I just went through a whole bunch of interviews to look for a job. ...

BTW, if you have enterprise edition, you should have reporting service. It is a reporting tool.