2005年
I have so many stored procedure , some of used update table records with transactions, some used for get the table records.
当一个特别项目在一张桌子上打上了桌子记录时,在哪里另一个特殊产品接收表数据的时候,那么它就应该在没有等待的情况下运行,需要做些什么?
我们应利用哪一个数据库孤立,哪一个孤立程度最好?
它可以用“过渡性 s光孤立程度”来证明。 但它将收集小组pdb数据库中旧的缩略数据,这种数据可以降低性能。
你们的建议是什么?
<代码>READ COMMITTED是服务器上的缺省交易孤立程度。
使用任何其他隔离水平(对我而言,任何途径)至少对我来说,构成“<>>>——至少需要某种实际理由,但在某些情形下使用的有限除外。
您应使用SNAPSHOT。 最好的办法是将READ COMMITTEDSPSHOT转至数据库一级,该数据库将无声地将所有未清的READ COMMITTED交易转化为速记交易。
The reasons why SNAPSHOT is best for applications, specially for applications that can run into blocking due to concurrency issues, are countless, and the benefits are endless. It is true that SNAPSHOT isolation occurs a cost in resources used, but unless you measured and find conclusive evidence that is the row version store that is causing the problems, you cannot dismiss it upfront.
永远不应使用的一个孤立等级是反恐执行局。 这就要求麻烦:。 Dirty的案文如下:。
REPEATABLE和SERIALIZABLE的使用案例极为狭窄,最可能永远不需要。 遗憾的是,SERIZABLE被互联网系统滥用。 交易和MTS/COM+的这类申请最终使用(而且由于其原因具有巨大的可变性问题),尽管不需要。
如果在某个表格中首次更新了数据,那么第二位将等待获得这一数据的任何进展(除了READ UNCOMMITTED的孤立程度之外,但在这种情况下,你的数据可能非常不一致)。
I ve got two tables: TableA Col1 Col2 TableB Col3 Col4 I want to join them together: SELECT * from TableA join TableB ON (...) Now, in place of ... I need to write an expression ...
TSQL query to select all records from Customer that has an Order and also select all records from customer that does not have an Order. The table Customer contains a primary key of CustomerID. The ...
I have a stored procedure which takes an XML parameter and inserts the data into multiple tables. If I run the stored procedure into a database using a SSMS query window, everything works fine. ...
Have a win 2003 box with MSSQL 2005 running on it. There is a database which is populated every morning with new/modified SalesOrder made the previous day. The database has several tables: SalesOrder, ...
I have a table with the following fields Id Name IsPublic i need to write a sql query that updates IsPublic to false where name has a duplicate. Only one of the duplicates should have IsPublic = ...
I have a Transact-SQL query that uses the IN operator. Something like this: select * from myTable where myColumn in (1,2,3,4) Is there a way to define a variable to hold the entire list "(1,2,3,4)"? ...
I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...
I m trying to transform the SQL Query below into Linq to SQL select Categorias.IdCategoria, Categorias.Nome, SUM(lancamentos.valor) from lancamentos left outer join Categorias on Lancamentos....
