Free Newsletters:
DatabaseDaily  
 		Database Journal
Search 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
» DBA Jobs
» Sitemap

News Via RSS Feed


follow us on Twitter





Brocade Doubles Down on 16 Gbps Fibre Channel

Microsoft Wants iOS Apps to Run on WP7

Avaya Debuts New Virtual Services Switch
Database Journal |DBA Support |SQLCourse |SQLCourse2







Technical Specialist – Pre-sales (MA)
Next Step Systems
US-MA-Littleton

Justtechjobs.com Post A Job | Post A Resume

Featured Database Articles

MS SQL

December 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
Troubleshooting SQL Server Jobs
Troubleshooting SQL Mail
Troubleshooting SQL Server Alerts
Troubleshooting SQL Server 2000 installation issues
Troubleshooting OLAP Problems
Troubleshooting SQL Server Backup/Restore Problems
Troubleshooting DTS Problems
Troubleshooting Replication Problems
Troubleshooting Full-text Search Problems

Comparisons
The comparison of SQL Server 2000 with MySQL v4.1
A Comparison of Oracle 9i with DB2 v8.1
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

Optimization Tips
Application Design Optimization Tips
SQL Server Bulk Copy Optimization Tips
Analysis Services optimization tips
SQL Server Optimization Tips for Designing Tables
SQL Server Stored Procedures Optimization Tips
SQL Server Backup/Restore Optimization Tips
SQL Server DTS Optimization Tips
Replication Optimization Tips
Full-Text Search Optimization Tips
Miscellaneous SQL Server Optimization Tips
Transact-SQL Optimization Tips
SQL Server 6.5 Optimization Tips
Operation System Optimization Tips
SQL Server 2000 Optimization Tips
Database Settings Optimization Tips
SQL Server Settings Optimization Tips
Optimizing SQL Server Performance by Using File and Filegroups
Optimization Tip for SQL 6.5: Using UNION ALL Statement
Index Optimization Tips
Optimization Tips for MS SQL 6.5: Storage Nullable Fields

Step-by-step Guides
Setting Up Full Text Search: A Step-by-step Guide
Setting Up Merge Replication: A Step-by-step Guide
Setting Up Snapshot Replication: A Step-by-step Guide
Setting Up Transactional Replication: A Step-by-step Guide

Articles

Tools:
Add databasejournal.com to your favorites
Add databasejournal.com to your browser search box
IE 7 | Firefox 2.0 | Firefox 1.5.x
Receive news via our XML/RSS feed

MS SQL Archives
Comment and Contribute

 


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

 

 



Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Script Component: Working with BLOB 0010 4 January 27th, 03:03 PM
Will an MS SQL db table trigger affect the value returned by scope_identity? wreade 2 December 19th, 04:48 PM
BULK UPDATE error benedec 1 December 14th, 08:39 AM
Toggling problem in Matrix report ssrs 2008 dev_ritesh 0 December 2nd, 02:17 PM