I think I see Sergiy's point, but it seems like arguments from both sides aren't connecting with the other side (it may partially be due to language barriers). The...

The easiest way is probably to use one of the tools available for data comparisons such as Apex SQL Diff, Red Gate SQL Data Compare, or xSQL...

The definition of the behavior of an Identity property on a column is:

SQL Server assigns each new row inserted in a table a value that is some increment greater...

If by "disabling" one means "turn off the automatic assignment of sequentially-generated numbers upon insert into this table, and instead allow me to supply the value I wish to use...

Are you saying that in the case of "discount the price for the top 10 most expensive products" that using TOP would indeed be a better choice, but for more...

Couldn't this same query:

UPDATE Products

SET UnitPrice = 0.9 * UnitPrice

WHERE ProductID IN

(

SELECT ProductID FROM(

SELECT ROW_NUMBER() OVER (ORDER BY UnitPrice DESC) AS Number, ProductID FROM Products) AS...

You can set SQL Profiler to run for a certain amount of time and log the results to a SQL table and then run queries on that table to find...

It could be an expression precedence problem.

If

Select *

from table t

where t.value_a/t.value_b > 10

AND t.value_c 10 AND t.value_c < 100)

instead of this:

(t.value_a / t.value_b) AND...

I posted this once but it went to the wrong place.  The original post went here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=280&messageid=297580.  I couldn't find a way to delete that post.

I am having difficulty...

Somehow this post didn't make it to where I wanted it.  It was supposed to be in this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=280&messageid=294217

Can someone move it?