Here are more details on what I found:

Most aggregate operations on partitions take more resources, do more scans, and are slower. Here is simple example, in my partitions divided by...

I agree with the dataset being too small to be of a lot of value in this case. But, the discrepancy between the IO costs and IO operations seems to...

I see some value in Brian's argument. Nevertheless, my original question was whether or not local groups can be used at all in the cluster server implementation for granting SQL...

I think I can easily illustrate my concerns with the simplified structure posted by Amit.

I would create an "unpartitioned table" by combining the partitions, like this:

select * into AllSalesTBL...

Are each of your databases "self contained". By that I mean if you were to put each of your databases on two different servers, would the applications work just as...

You said when you logged in as "sa" you were able to access the data. Are you using EM for this?

Are you logging into the QA with the same account...

My partitioned tables meet all the conditions and they are updatable. More details emerged upon a closer look at the query plan and the statistics. Even though the query plan...

By default each SQL Server user has permissions to add, modify "their own" packages. Unfortunately, SQL Server does not have a default mechanism to allow developers to modify each others...

TargetServer role did  the trick. Once I add the users to this group they can see all the jobs. Now I can selectively grant exec permissions on sp_startjob to users...

Steve:

Let me clarify. I meant to keep all non-essential jobs owned by an account that is not part of the sysadmin role for security reasons. However, for jobs to be...

I would not worry too much about the master DB, since privileged procedures are already secured by checking explicitly for user access within the proc. So not much harm can...

Thanks for your input. I sincerely appreciate it.

Though I could add the sales filed to the NC index, I am short on time to test out the apps that use...

I do have indexes on Item (Clustered: Category, ItemID) and Stores(Clustered: Chain, StoreID) tables.

On the Sales Table, the initial clustered index is on Saleweek, Store and Item. The non...

Never mind,

I got it.

select s1.saledate, sum (s2.amount)

from sales s1, sales  s2

where s2.saledate between s1.saledate - 2 and s1.saledate

group by s1.saledate

If you do not want to give the users running the DTS packages DDL permissions, modify the DTS to move all those tables to a new work database and give...