Andy,

It could be that I did something wrong in the test, but when I completed the install without doing the uninstall, upon completion the Query Analyzer interface looked like the...

Not sure what you mean by new client tools. I am going to upgrade client machines, but am only testing server upgrades at the moment.

I have never done an...

If you are not changing the structure a Full Process is more than you need to do. A Refresh will get you the same result and will have less...

I'm curious to know the latency of your cube data. Does it need to be updated immediately.

I have a similar situation with one of my cubes. Every night...

This also seems to work:

SET @DateTime=DATEDIFF(DAY, 0, @DateTime)

This eliminates the CONVERT function.

Since all thoughts are welcome:

Why don't you put the business logic in a programming object? Whether it is an MTS object or a class module in a client server...

True, I've seen this used as an output variable, but then you have to set up the retrieval process with an output parameter rather than send the variable that will...

quote:

---

For stored procedures, I always include SET NOCOUNT ON as the first statement. I don't want the stored procedure to return those...

My intent was to show how you can use an array to pass the values. That it is clipped from a best practices document is more a best practices...

Here is a section from a document I wrote on ADO best practices:

Implicit Parameters

As explained above, implicit parameters can save code. For example, rather than create two lines of...

quote:

---

Both SiteServer and my user databases are using Windows Integrated security. Both have the required user set up and yet I still...

I ran your test. Here is my initial set of results:

4516 MILLISECONDS TO RUN 500 STORED PROCEDURES

5173 MILLISECONDS TO RUN 500 STORED PROCEDURES

4153 MILLISECONDS TO RUN 500 STORED PROCEDURES

5080...

quote:

---

Mromm, are you meaning that you do not normally like to use views for the data retrieval? Just curious as to your...

Ensure you execute the log backup command just prior to your database backup. This makes the backup as small as possible. I have also noticed that when I...

I recommend you set up a user for your SQL Server to use. During the installation, you have the choice to use local administrator or an NT user of...