Alexander Chigrik

Introduction In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 2000. sp_MSget_qualified_name This stored procedure is used to get the qualified name for the given object id. Syntax sp_MSget_qualified_name object_id, qualified_name where object_id – is the object id. object_id is int. qualified_name – is the qualified […]

Introduction In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 7.0. sp_columns_rowset This stored procedure returns the complete columns description, including the length, type, name, and so on. Syntax sp_columns_rowset tbname [, table_schema ] [, column_name] where tbname – is the table name. tbname is sysname. […]

Introduction In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 6.5. sp_fixindex This stored procedure can be used to fix a corruption in a system table by recreate the index. See this link for more information: “How can I fix a corruption in a system table?” […]

Introduction Server Roles Database Roles Fixed Database Roles Public Role User-Defined Database Roles Application Roles   Introduction Roles are the new SQL Server 7.0 feature, which was not available in the previous versions. SQL Server roles act like Windows NT local groups. SQL Server 7.0 supports several different types of roles. There are: server roles […]

Introduction Extended stored procedure is a dynamic link library that run directly in the address space of SQL Server and is programmed using the SQL Server Open Data Services API. You can write your own extended stored procedure in a programming language such as C. You can run extended stored procedures from the Query Analyzer, […]

There are two security modes (authentication modes) in SQL Server 7.0: Windows NT Authentication Mixed The security mode is selected during SQL Server 7.0 installation and can be modified at any time. To change the security modes, you can do the following: Click Start, Programs, Microsoft SQL Server 7.0 and click SQL Enterprise Manager to […]

SQL Server 6.5 uses three security modes: Standard Integrated Mixed The security mode is selected during SQL Server 6.5 installation and can be modified at any time. To change the security modes, you can do the following: Click Start, Programs, Microsoft SQL Server 6.5 and click SQL Enterprise Manager to run SQL Enterprise Manager from […]

Introduction Distribution Statistics View Distribution Statistics Update Distribution Statistics Introduction Sometimes it is difficult to determine which indexes to use when processing a query. In this case, the query optimizer uses distribution statistics. SQL Server 7.0 can update distribution statistics automatically, so in most cases it is not necessary to update distribution statistics manually and […]

Introduction Distribution Pages View Index Statistics Update Distribution Statistics Introduction Sometimes it is difficult to determine which indexes to use when processing a query. In this case, the query optimizer uses distribution pages. SQL Server 6.5 cannot update distribution statistics automatically as SQL Server 7.0 can, so you should manually update distribution statistics when a […]

Introduction General details Transaction Isolation Levels Lock types Locking optimizer hints Lock Escalation Deadlocks Viewing locks (sp_lock, sp_lock2) Literature Introduction In this article, I want to tell you about general details of SQL Server 7.0 locking, about Transaction Isolation Levels, what kind of Transaction Isolation Level exists, and how you can set the appropriate Transaction […]

Introduction General details Transaction Isolation Levels Lock types Locking optimizer hints Lock Escalation Deadlocks Viewing locks (sp_lock) Setting insert row lock Literature Introduction In this article I want to tell you about general details of SQL Server 6.5 locking, about Transaction Isolation Level, what kind of Transaction Isolation Level exists, and how you can set […]

Introduction Meta Data UDFs COL_LENGTH2 COL_ID INDEX_ID INDEX_COL2 ROW_COUNT Introduction I would like to write the series of articles about useful User-Defined Functions grouped by the following categories: Date and Time User-Defined Functions Mathematical User-Defined Functions Metadata User-Defined Functions Security User-Defined Functions String User-Defined Functions System User-Defined Functions Text and Image User-Defined Functions In this […]