Browse by Tags

• access
• best practice
• clustered
• dmv
• guid
• indexes
• metadata
• monitoring
• overhead
• package
• performance
• principal
• privileges
• public
• security
• server state
• sql server
• tsql
• uniquire
• users

SQL Server 2005: Deny Server-Level Dynamic Management Views to public group
21 December 07 06:47 AM | SQL Master | 2 Comments   

As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine. Just to introduce about DMVs, there are two types of dynamic Read More...

Filed under: performance, sql server, security, package, dmv, users, view, best practice, monitoring, public, server state

Performance consideration or overhead having primary key with 3 GUID (Clustered Index)
25 September 07 02:17 PM | SQL Master | 2 Comments   

During a database design there has been an interesting discussion that will there be any performance addition in adding a second non-clustered index on a Globally Unique ID ( GUID ) column that has already a unique clustered index. IF needed you need Read More...

Filed under: performance, sql server, indexes, clustered, view, overhead, uniquire, guid

Control metada visibility using few 'simple' statements
09 August 07 03:03 AM | SQL Master | 2 Comments   

You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the Read More...

Filed under: security, access, tsql, principal, metadata, privileges, view