A cube is more of a three dimensional object.  It sounds to me like you have 2 dimensions here, right?  Anyway, if you are looking for a method of storing...

Run DBCC CHECKDB against the database.  Correct any errors that it reports (by using the repair option).  If this does not report any errors, it is most likely an intermitant...

It is OK as far as the data type that you use.  This is one of the limitations of using Identity columns, they only last as long as the datatype. ...

As Robert said, look in BOL for information on how to implement locking hints. 

It is important to point out that using a locking hint is like giving SQL Server...

I don't think this is going to cause you any problems from a performance standpoint; EM should just be executing an INSERT statement behind-the-scenes.  Try running profiler and capturing what...

I am not quite clear on what you are after here, but from a quick glance, you need to check your join columns.  Why are you joining on branchID only? ...

The constraint error that you are getting is telling you that you are trying to insert an invalid GroupID into your UserGroups table.  The GroupID does not exist in your...

Collation can be set at multiple levels in SQL Server.  You can set Collation at the instance, database, or object level.  From what I am seeing from your post, your...

Well, there are many tools and methods that you can use to look at SQL Server performance.  There are many performance related articles on SSC and also on http://www.SQLServerPerformance.com.  Much of...

There is no TSQL command to make the DELETE statement in your query perform a cascaded delete.  You would need to write 2 DELETE statements in your query.  The first...

"The reason I ask is because putting the main database on the RAID really seems...."

When you say 'main database', I assume that you mean the 14 GB DB with your...

You are correct, you cannot use a variable with TOP.  Try this instead:

DECLARE @TopCnt int

SET @TopCnt = 100

SET ROWCOUNT @TopCnt

INSERT INTO #B

SELECT *

FROM #A

SET ROWCOUNT 0 --Make sure you...

Yes, it is rebuilding all non-clustered indexes on the table.  The clustered index key is part of all non-clustered indexes on a table where both exist, so any time you...

Have you looked in EM to make sure that sp_dboption is missing from your Master DB?  You may want to try running sp_dboption again, but fully qualifying the SP name...

SELECT MAX(DeliveryDate), Product FROM YourTable GROUP BY Product