Normally, a measure is stored within the cube when the cube is processed. Aggregations of that measure will also be stored depending on which aggregations have been designed for...

Can't help you with your 64 bit question but if you want to find out how taxed your server is, performance monitor is the tool to use. Have a...

Why don't you use SQL Agent Alerts to notify you when a replication job fails ? This is standard functionality which is extremely easy to configure. Assuming you...

The statistical index you are seeing is usually the result of having

"Auto create statistics" turned for the database. If SQL Server needs to know more information about a...

This is actually quite easy to setup.

If you are using Enterprise Manager to create the articles, you should go to the article properties. You can get there...

Have you checked out the information that performance monitor shows you - the performance object "SQL Server:Replication Dist." has a counter called "DistDelivered Trans/sec" which does sound like the information...

SQL Profiler might be your next option - if you know what is actually happening on the SQL Server at the time the timeout occurs, you should be able to...

SQL 2005 now has "Snapshot Isolation" which is intended to avoid this problem. Haven't have a chance to play around with it as yet though.

Something else to consider wrt IDENTITY columns is that, because they are typically much smaller than the equivalent primary key they are a good candidate for being the clustered index...

Have a look at the data type "TIMESTAMP". Functionally, it is similar to IDENTITY in that is automatically increments. It is a binary number starting at 0 and...

You can do this with SQL 2005 using the APPLY operator

SQL Server does not require you to create the database prior to restoring it. I would simply run the restore specifying the relevant file locations. It will still...

A common issue that happens when 3 machines are involved (client PC, app server, database server) is because the impersonation and delegation properties for the various user and service accounts...

Mmmm, you can't actually create a trigger on a system table.

Alerts are the way to go. In Enterprise Manager, got to Management--> SQL Server Agent --> Alerts

If you create...

The follow will give you the column names in every index for a table. You should be able to derive the CREATE UNDEX statements from this.

select object_name (SI.id), SI.name,...