thank for all replys. I have the answer, that is 1> there is a table with very big size, and 2> It's not necessary to get 100% accuracy, for...
I have some big size tables which have millions of records, I want to get count of records quickly. Someone tell me that I can use Rows field in...
I rewrite my statement. We can divide a task of trigger into two parts: rule check and data operation, right? So when someone said : yep, sp is...
quote:Originally posted by benwilson In my opinion using triggers is fine as long as you are aware how often they will run, and what the cost of...
first, sorry for my poor English. [:I] Others often tell me that shall use less trigger because trigger may cause performance problem. Anyone can...
great, thx a lot ^_^
I wonder there are tools/scripts/tricks to simulate accessing/modifing database by multi-user to estimate the concurrent performance. e.g. to test...
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5 SP4 includes packages for the following...
I think it's impossible, because if we can see the contents of extended sp, then we can see the contents of DLL.
Separate names with a comma.
