If I understand the writeup correctly, the portion of the total that is not allocated to one of the contributing amounts is then allocated to just one of the records....

With regard to partioned tables, does the partitioning key have to be the first column of the clustering index? It seems that way to me.

Also, if you have a...

I changed all of my variable data tyes to float and the variable-based expression produced the desired result.

I also found that decimal (38,10) also works, so I might...

I am trying to figure out how to get the right result using the variables. The expression with the numbers as constants produces the correct result.

Thanks Gail.

So, it seems reasonable to assume that the next SQL version after SQL2008 will drop support for 2000 compatibility.

Does Microsoft have any plans for discontinuing older compatibility levels? If so, where can this information be found, in particular, dates.

I am talking about developers debugging through programs that access the database. So, they will run native SQL queries and also be able to see data retrieved by VB...

Unfortunately, it isn't an encryption problem. It has to do with privacy laws and the use of third party contractors and maybe out-of-country developers. So, these people need...

Riga,

The script below is set to create rollover files of 250 mb and to retain the five most recent iterations.

/****************************************************/

/* Created by: SQL Server Profiler 2005 ...

Markus,

I have noticed that when I script a trace, for some reason, it doesn't pick up all of the column filters.

On the subject of trace files, I have a situation where the application running against a database periodically experiences severe systemic contention. We haven't had much luck figuring out...

Nice call. The trigger explains it all. When I update the single row in WTABLE, a trigger then updates 61 rows in another table.

I can see dropping the non-clustered indexes before reloading the table. What about the clustered index?

Also, does it help to have the input file sorted in cluster index order?

Jeez, this sounds like the all-American contractor redoing my bathrooms.  Certainly work across cultures and languages amplifies the possibilities for misunderstanding, but the problem of poor quality delivery is endemic...

Related question:

I have two variations of a query.  According to the estimated execution plan, both queries should have about the same cost.  In actual execution, however, one of the queries...