Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Posted Dec 9, 2002

Alexander Chigrik

By DatabaseJournal.com Staff

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



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 



















Thanks for your registration, follow us on our social networks to keep up-to-date