Alexander Chigrik

Monday Dec 9th 2002 by DatabaseJournal.com Staff
Share:

Alexander Chigrik's Articles

chigrik@mssqlcity.com


I am the owner of MSSQLCity.Com - a site dedicated to providing useful information for IT professionals using Microsoft SQL Server. This site contains SQL Server Articles, FAQs, Scripts, Tips and Test Exams.

Current Certifications:

Brainbench:
Master MS SQL Server 2000 Programming
Master MS SQL Server 7 Administration
Master MS SQL Server 7 Programming
Master MS SQL Server 6.5 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


Series Articles

Troubleshooting

Comparisons

Optimization Tips

Step-by-step Guides

Articles

- Understanding SQL Server 2000 Locking
- Troubleshooting SQL Server Jobs
- Troubleshooting SQL Mail
- Application Design Optimization Tips
- SQL Server Bulk Copy Optimization Tips
- The comparison of SQL Server 2000 with MySQL v4.1
- Troubleshooting SQL Server Alerts
- A Comparison of Oracle 9i with DB2 v8.1
- SQL Server Stored Procedures Administration
- Managing Users Permissions on SQL Server
- Reducing SQL Server Index Fragmentation
- Backing Up and Restoring SQL Server Databases and Transaction Logs
- Attaching and Detaching Databases on SQL Server
- Using Microsoft SQL Server Constraints
- Choosing SQL Server 2000 Data Types
- A Comparison of SQL Server 2000 with Access 2000
- A Comparison of SQL Server 2000 With Sybase ASE 12.5
- A Comparison of SQL Server 2000 with DB2 v8.1
- The comparison of SQL Server 2000 with Oracle 9i
- Troubleshooting SQL Server 2000 installation issues
- Analysis Services optimization tips
- Troubleshooting OLAP Problems
- SQL Server Optimization Tips for Designing Tables
- Solving SQL Server Connection Problems
- SQL Server Stored Procedures Optimization Tips
- SQL Server Backup/Restore Optimization Tips
- Troubleshooting SQL Server Backup/Restore Problems
- SQL Server DTS Optimization Tips
- Setting Up Full Text Search: A Step-by-step Guide
- Troubleshooting DTS Problems
- Replication Optimization Tips
- Troubleshooting Replication Problems
- Full-Text Search Optimization Tips
- Troubleshooting Full-text Search Problems
- Miscellaneous SQL Server Optimization Tips
- Transact-SQL Optimization Tips
- SQL Server 6.5 Optimization Tips
- Operation System Optimization Tips
- Using SQL Server Cursors
- SQL Server 2000 Optimization Tips
- Database Settings Optimization Tips
- SQL Server Settings Optimization Tips
- Data Validation for Merge Replication
- Setting Up Merge Replication: A Step-by-step Guide
- Setting Up Snapshot Replication: A Step-by-step Guide
- SQL Server 2000 Undocumented System Tables
- SQL Server 7.0 Undocumented System Tables
- Optimizing SQL Server Performance by Using File and Filegroups
- SQL Server 2000 Useful Undocumented Stored Procedures
- SQL Server 7.0 Useful Undocumented Stored Procedures
- SQL Server 6.5 Useful Undocumented Stored Procedures
- Understanding SQL Server Roles
- Useful Undocumented Extended Stored Procedures
- SQL Server 7.0 Security Modes
- SQL Server 6.5 Security Modes
- SQL Server 7.0 Index Statistics Details
- SQL Server 6.5 Index Statistics Details
- Locking in SQL Server 7.0
- Locking in SQL Server 6.5
- Meta Data User-Defined Functions
- Mathematical User-Defined Functions
- Date and Time User-Defined Functions
- String User-Defined Functions
- SQL Server 2000: Some Useful Trace Flags
- Working with COM Objects from within T-SQL
- Useful Links for Microsoft SQL Server
- Some Useful User-Defined Functions for SQL Server 2000
- Detailed Locking View: sp_lock2
- SQL Server 2000: Some Useful Undocumented DBCC Commands
- SQL Server 7.0: Some Useful Undocumented DBCC Commands
- SQL Server 6.5: Some Useful Undocumented DBCC Commands
- SQL Server 6.5: Locking
- SQL Server 2000 Installation
- Transaction Isolation Level
- Update Methods Used in MS SQL 6.5
- SQL Server 7.0: Installation Issues
- SQL Server 7.0 Installation
- SQL Server 7.0: Some Useful Trace Flags
- SQL Server 7.0: Hash Joins
- SQL Server 7.0: Merge Joins
- SQL Server 7.0: Nested-Loop Joins
- SQL Server 6.5: Nested-Loop Joins
- SQL Server 6.5: Some Useful Trace Flags
- Some Tips About tempdb Database
- Viewing the Transaction Log
- Copy Text or Image into or out of SQL Server
- Optimization Tip for SQL 6.5: Using UNION ALL Statement
- Alternative Way to Get the Table's Row Count
- Index Optimization Tips
- Setting Up Transactional Replication: A Step-by-step Guide
- Optimization Tips for MS SQL 6.5: Storage Nullable Fields
- Data Row Structure in MS SQL Server 6.5
- Data Page Structure in MS SQL Server 6.5
- Update Methods Used in MS SQL Server 7.0
- Data Validation for Transactional Replication

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved