Not sure what you mean by "registers" in this context.

Without at least some clue as to what you're trying to resolve, I'm kind of at a loss as to what to suggest. If you say what kind of...

One of the things that I changed in my original suggestion was getting rid of "WHERE dbo.CSK_Store_Product.productID = dbo.CSK_Store_Product.productID". You do realize that that will ALWAYS be true, right?...

Table variables will do the same thing. They'll estimate at one row, pretty much regardless of what's going to actually be in them. Recursive CTEs are another one...

It depends on what the triggers do and can you replace them with something faster/better without losing important functionality and integrity.

In some cases (a very few), a trigger is the...

I'd create one function for each select. Use those instead of a parameter.

You could have three columns (VendorID, CustomerID, EmployeeID) in the UserLink table, with an FK from each to the corresponding table. Then add a check constraint that makes it...

If I'm understanding you correctly, I think you could use the row_number() function to do that. Check that out in Books Online.

What does it give you if you run this query:

SELECT OBJECT_NAME(parent_object_id) AS table_name, name

FROM sys.check_constraints

WHERE is_not_trusted = 1

I realized after I read my first post here that I'm making some assumptions.

I'm assuming you've tested the proc thoroughly.

I'm assuming you have a rollback script, so you can undo...

I can't say what procedure you must follow. It depends on the company policy, etc.

Technically, it doesn't require anything at all except running the script. It's policy, customer...

As far as the wording of the question goes, some people ended up misreading the intent of the question, one person even ended up bitter about it. I understand...

The formatting problem in the web page (the "THIS" thing you're talking about) is a problem with the forum software, if I remember what Steve said about it. It's...

"Once ze rockets go up, who cares where zey come down? That's not my...

SAMPLE number { PERCENT | ROWS }

Specifies the percentage of the table or indexed view, or the number of rows to sample when collecting statistics for larger tables or...