Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Alexander Chigrik

SQLServerCentral.com profile

I would like to offer consultation on MS-SQL by E-Mail

I am from Rostov-on-Don in Russia.I work for a firm Bis Ltd (Banking Information Systems) as a Microsoft SQL Server DBA and developer. I have more than 4 years solid experience with version 6.5 and more than 2 years experience (since december 1998) with version 7.0.

Current Certifications:

  • Brainbench:Master MS SQL Server 6.5 Administration
  • Master MS SQL Server 6.5 Programming
  • Master MS SQL Server 7 Administration
  • Master MS SQL Server 7 Programming
All exams on Brainbench

I am in the list of 15 top experts on MS SQL under the version of experts-exchange:http://www.experts-exchange.com/jsp/qList.jsp?ta=mssql

   Items 1 to 20 of 25    Older >>
 

Some Useful UDFs for SQL Server 2000

Alxander Chigrik presents some useful User Defined Functions you can add to your SQL Server.   Read more...
Rating: |  Discuss |   Briefcase | 8,547 reads

SQL Server 2000 Undocumented System Tables

Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.   Read more...
By Alexander Chigrik 2001/11/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,813 reads

SQL Server 2000 Useful Undocumented Stored Procedures

In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.   Read more...
By Alexander Chigrik 2004/08/27 (first published: 2001/10/08) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 30,137 reads

Roles in SQL Server 7.0

A look at the different types of roles in SQL Server 7.0.  Read more...
By Alexander Chigrik 2001/10/12 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 3,496 reads

An Alternative Way To Get the Table's Rowcount

This article examines an alternative method for finding the rowcount of a table besides using a select count(*)   Read more...
By Alexander Chigrik 2001/10/05 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 4,745 reads

A Few Meta Data UDFs

Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 4,031 reads

A Few Mathematical UDFs

Alexander Chigrik presents a few Math UDFs he has developed for common functions.  Read more...
By Alexander Chigrik 2001/10/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,908 reads

SQL Server 6.5: Index Statistic Details

This article examines how index statistics are used in SQL Server 6.5   Read more...
By Alexander Chigrik 2002/02/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 150 reads

Optimizing SQL Server Performance by using File and Filegroups

A look at files and filegroups in SQL Server 7.0, including some optimization tips.   Read more...
By Alexander Chigrik 2001/09/27 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,773 reads

SQL Server 7: Some Useful Undocumented DBCC Commands

This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0   Read more...
By Alexander Chigrik 2001/10/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,916 reads

Some Undocumented Stored Procedures

This article examines some of the undocumented stored procedures that exist in SQL Server 7.0   Read more...
By Alexander Chigrik 2001/09/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,533 reads

SQL Server 7.0 Installation

This article examines the basics of installing SQL Server 7.0   Read more...
By Alexander Chigrik 2001/09/03 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 3,611 reads

Undocumented Stored Procedures in SQL Server 6.5

This article examines some useful undocumented stored procedures in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/09/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,224 reads

Installation Problems in SQL Server 7.0

This article examines some of the common issues that may occur when installing SQL Server 7.0   Read more...
By Alexander Chigrik 2001/08/23 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 3,277 reads

SQL Server 6.5: Index Statistic Details

This article examines how index statistics are used in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/10/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,246 reads

SQL Server 7.0 Undocumented Extended Stored Procedures

A few stored procedures that are not documented in SQL Server 7.0, but may come in handy for DBAs   Read more...
By Alexander Chigrik 2001/11/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,690 reads

SQL Server 6.5 Security Modes

A look at the different security modes availabe in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/07/19 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,380 reads

SQL Server 7.0 Security Modes

A look at the different security modes available in SQL Server 7.0   Read more...
By Alexander Chigrik 2001/07/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,260 reads

Locking in SQL Server 7.0

This article examines how locking occurs in SQL Server 7.0   Read more...
By Alexander Chigrik 2001/07/16 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 6,429 reads

Locking in SQL Server 6.5

This article examines how locking occurs in SQL Server 6.5   Read more...
By Alexander Chigrik 2001/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,860 reads
   Items 1 to 20 of 25    Older >>