Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Alexander Chigrik
SQL Server 2000 Useful Undocumented Stored Procedures – SQLServerCentral
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 name of the object. qualified_name is nvarchar(512).
Some Useful UDFs for SQL Server 2000 – SQLServerCentral
Introduction UDF examples Database creation date Date the object was created Get date part of datetime value Get time part of datetime value Get the number of working days between two dates Literature Introduction SQL Server 2000 supports User-Defined Functions (UDFs) - one or more Transact-SQL statements that can be used to encapsulate code for reuse. User-defined functions cannot make a permanent changes to the data or modify database tables.
SQL Server 2000 Undocumented System Tables – SQLServerCentral
Introduction Undocumented system tables syscursorcolumns syscursorrefs syscursors syscursortables sysfiles1 sysfulltextnotify syslocks sysproperties sysxlogins Introduction In this article, I want to tell you about undocumented system tables shipped with SQL Server 2000. These tables are used by some system stored procedures and stored in the master database (only sysfiles1, sysproperties and sysfulltextnotify system tables are stored in each database).
SQL Server 7.0 Undocumented Extended Stored Procedures – SQLServerCentral
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.table_schema is the table schema. table_schema is sysname, with a default of NULL. column_name is the column name.
SQL Server 6.5: Index Statistic Details – SQLServerCentral
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 large amount of data in an indexed column has been added, changed, or deleted.
SQL Server 7: Some Useful Undocumented DBCC Commands – SQLServerCentral
Introduction Undocumented DBCC commands: DBCC BUFFER DBCC BYTES DBCC DBINFO DBCC DBTABLE DBCC DES DBCC HELP DBCC IND DBCC LOG DBCC PAGE DBCC PROCBUF DBCC PRTIPAGE DBCC PSS DBCC RESOURCE DBCC TAB Literature Introduction In this article I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 7.0 for administering and monitoring. DBCC is an abbreviation of a DataBase Consistency Checker.
A Few Meta Data UDFs – SQLServerCentral
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 article, I wrote some useful Meta Data...
Roles in SQL Server 7.0 – SQLServerCentral
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.
A Few Mathematical UDFs – SQLServerCentral
Introduction Mathematical UDFs Factorial PercentFrom PercentValue Degree Allocation Combination 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 article, I wrote some...
Some Undocumented Stored Procedures – SQLServerCentral
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, for example, as normal stored procedures. Extended stored procedures are used to extend the capabilities of SQL Server.
Optimizing SQL Server Performance by using File and Filegroups – SQLServerCentral
General concepts Optimization tips Literature General concepts There are no devices and segments in SQL Server 7.0 and SQL Server 2000, as in SQL Server 6.5. Now databases reside on operating-system files. There are three types of such files: primary secondary log Each database consists of at least two files: one is a primary data file (by default, with the .mdf extension), the other is log file (by default, with the .ldf extension).
Undocumented Stored Procedures in SQL Server 6.5 – SQLServerCentral
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.
SQL Server 7.0 Installation – SQLServerCentral
Introduction Hardware and Software Requirements SQL Server Editions Installation Types Testing an installation Literature Introduction In this article I want to tell you about some general details of SQL Server 7.0 installation. I also described hardware and software requirements for SQL Server 7.0 and SQL Server 7.0 editions.
Installation Problems in SQL Server 7.0 – SQLServerCentral
In this article I want to tell you about some problems, which you can have when you install SQL Server 7.0, and how you can resolve these problems. If you have problems with installation, check the following: 1. Check the hardware requirements.
Lock View: sp_lock2 – SQLServerCentral
Introduction sp_lock2 Literature Introduction As a SQL Server DBA, I often need a reference to information about locks. Microsoft recommends to use sp_lock system stored procedure to report locks information. This very useful procedure returns the information about SQL Server process ID, which lock the data, about locked database ID, about locked object ID, about locked index ID and about type of locking (type, resource, mode and status columns).
SQL Server 6.5 Security Modes – SQLServerCentral
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 the Microsoft SQL Server 6.5 program group.
Locking in SQL Server 7.0 – SQLServerCentral
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 Isolation Level, about Lock types and Locking optimizer hints, about Lock Escalation, about Deadlocks,...
Locking in SQL Server 6.5 – SQLServerCentral
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 the appropriate Transaction Isolation Level, about Lock types and Locking optimizer hints, about Lock Escalation,...
SQL Server 7.0 Security Modes – SQLServerCentral
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 run SQL Enterprise Manager from the Microsoft SQL Server 7.0 program group.
Locking in SQL Server 6.5 – SQLServerCentral
Introduction General details Lock Escalation Setting insert row lock Introduction In this article I want to tell you about some general details of SQL Server 6.5 locking, about Lock Escalation, and how you can set insert row lock for a particular table or tables. General details There are three units of data storage in SQL Server 6.5: Page Extent Allocation Unit SQL Server 6.5 stores data on the 2Kb data pages.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Alexander
Contact Alexander, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack