我有兴趣学习哪些技术开发商更喜欢使用,以便在服务器中强制实行独一无二的特性: UNI RequestCONTRAINT or UNIquest INDEX. 鉴于在实际执行方面几乎没有差别,你如何决定哪些是最好的?
是否除了业绩之外还有其他理由来评价最佳解决办法?
是否有数据库管理的优势?
它们是:。 页: 1 当你制造一个独特的制约因素时,服务器将自动为你建立一个独特的指数。
由于编制指数的辛迪加,你可以更好地控制确定一个独特的指数,具体列出集群/未分类,包括栏目、档案组、索引过滤(SqlSvr2008),等等。
在大多数情况下,限制更为可取,因为它表达了独一无二的意图:这是制约因素。 指数没有表达这一意图。
至于可管理性,影响最小。 你们可以管理指数(rebuild, reorg),就像它是在没有限制的情况下创建的。 唯一的区别是,制约因素取决于指数,以便降低指数,你也必须放弃限制。
我的两点: 当我想要提高业绩时,我想描述商业逻辑和指数时,我将使用限制。 可在房舍管理处实施同一规定并不意味着对界定这些物体的理由加以区分并不重要。
独一无二的制约因素只意味着独一无二,排除制约因素将消除发动机产生的指数。 可以改变一个指数,以消除其独一无二之处,而且你仍然有自己的指数。 我认为,可以假定,一栏中大多数会迫使独一无二,也会因业绩原因成为一种指数;我主要使用独特的指数。 我只对需要独一无二但业绩不佳的栏目(即需要独一无二的斜体(200))使用独特的限制;在这种情况下,我要明确指出,尽管有基本指数,但这种限制是独一无二的,但可能并不好。
I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...
In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user ...
I have been trying to execute a MS SQL Server stored procedure via JDBC today and have been unsuccessful thus far. The stored procedure has 1 input and 1 output parameter. With every combination I ...
Is it possible to use the sqlcmd command to dump table structure the way it can be done with mysqldump?
Hi I have the following SP, however when I use LINQ to SQL it generates 2 multiple recordsets. For my sanity I am trying to fathom out what it is in the stored procedure that is doing this and would ...
I want to create a table in MS SQL Server 2005 to record details of certain system operations. As you can see from the table design below, every column apart from Details is is non nullable. CREATE ...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...
How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8
