Jeff's answer is great.

I would like to ask: what is your presentation layer for this information?

I ask because although this type of pivot can be done in T-SQL, it is...

For a small database, a schema and data differencing tool like the Red-Gate one will generate all of the objects and populate the data.

Other than that, I suggest you script...

I have never had to do anything with the firewall, so I think the answer is no.

Reporting Services and Integration Services both have this same problem. In the tutorials...

You are getting the correct number of scans, and I assume the plan is indicating an index seek and not an index or table scan.

So, it could simply be fragmentation....

I think you took offense to my reply to the original post - I can see how it would sound if I were the original poster, but I am not.

Are...

What does "access to management tools" mean to you?

If they need any server-level permissions (backup admin, sysadmin, create database, etc.) they will possibly be able to get to other people's...

The 3G switch tells the OS to use less memory for itself. Without this switch set, Windows allocates 2GB out of the first 4GB of memory to OS level...

You will end up with a pretty good number of facts, so it is probably a good idea for you to look into partitioning right away.

I think you are building a table with aggregations and using it with a product (Analysis Services - I assume) that is designed to calculate aggregations. Sound funny when...

"Other products (not SQL Server), often use exe versions"

SQL Server does use different file versions, your original post did not indicate that your tool could see file version information. ...

Because you have the data semi-pivoted already, you will have to go in and manually modify the groupings in the matrix. The default layout will not work.

I never use that template explorer, but it is my understanding that you can just right-click and create a folder, and then save your queries into this folder.

If the data type of the underlying table is VARCHAR, why would you want to double the size of the returned data in the view and wreck any of your...

From this and you other question I do not think you understand temporary tables. Temporary tables disappear when they go out of scope. Although you can create a...

You have not really given a clear example - some sample data and an actual test query would help, but I think you just have your "OR" logic in the...