MSSQLCity.Com - All about MS SQL
     
About Us  
SSWUG Articles  
Articles  
Administering  
Comparison  
General  
Know How  
Replication  
Tuning  
Undocumented  
UDF  
SQL 6.5  
FAQ  
Scripts  
Tips  
Test Exams  
Advertise  
Download  
Search  
Related Links  
     
Your button logo
Add to Favorites
 
     
 

SQL Server Articles

Administering

  • Troubleshooting SQL Server Jobs
  • Troubleshooting SQL Mail
  • Troubleshooting SQL Server Alerts
  • Stored Procedures Administration
  • Managing Users Permissions
  • Reducing SQL Server Index Fragmentation
  • Backup and restore databases and transaction logs
  • Attaching and Detaching Databases
  • Troubleshooting SQL Server 2000 installation
  • Troubleshooting OLAP Problems
  • How to troubleshoot connection problems
  • How to troubleshoot backup/restore problems
  • How to troubleshoot DTS problems
  • How to troubleshoot full-text search problems
  • Troubleshooting SQL Server 7.0 installation
  • Setting up full-text search: step by step guide
  • Microsoft SQL Server roles
  • Locking in Microsoft SQL Server
  • Detailed locking view: sp_lock2
  • SQL Server 7.0 Security Modes
  • SQL Server 7.0: index statistics details
  • SQL Server 7.0 Installation
  • SQL Server 2000 Installation
  • Comparison

  • SQL Server 2000 vs MySQL version 4.1
  • SQL Server 2000 vs Access 2000
  • SQL Server 2000 vs Sybase ASE 12.5
  • SQL Server 2000 vs DB2 v8.1
  • SQL Server 2000 vs Oracle 9i
  • Oracle 9i Database vs DB2 v8.1
  • The comparison of Access 97/2000 with SQL Server 7.0/2000
  • SQL Server 7.0 vs MSDE 1.0
  • The comparison of SQL Server 7.0 with SQL Server 2000
  • The comparison of SQL Server 6.5 with SQL Server 7.0
  • General Concepts

  • Understanding SQL Server 2000 Locking
  • Using Microsoft SQL Server Constraints
  • Choosing SQL Server 2000 Data Types
  • Transaction Isolation Level
  • Microsoft SQL Server Nested-Loop Joins
  • Microsoft SQL Server Merge Joins
  • Microsoft SQL Server Hash Joins
  • Update Methods Used in MS SQL 7.0
  • Working with COM objects from within T-SQL
  • SQL Server 7.0: Some useful trace flags
  • SQL Server 2000: Some useful trace flags
  • Using SQL Server Cursors
  • Know How

  • View Transaction Log
  • Copy text or image into or out of SQL Server
  • Alternative way to get the table's row count
  • Replication

  • How to troubleshoot replication problems
  • Setup Snapshot replication: step by step guide
  • Setup Transactional replication: step by step guide
  • Setup Merge replication: step by step guide
  • Data Validation for Transactional Replication
  • Data Validation for Merge Replication
  • Tuning and Optimization

  • Index Optimization Tips
  • Some tips about tempdb database
  • Optimizing SQL Server Performance by using File and Filegroups
  • Undocumented Power

  • SQL Server 7.0 undocumented system tables
  • SQL Server 7.0 Useful undocumented stored procedures
  • SQL Server 2000 undocumented system tables
  • SQL Server 2000 Useful undocumented stored procedures
  • Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands
  • Useful undocumented extended stored procedures
  • User-Defined Functions

  • Meta Data User-Defined Functions
  • Mathematical User-Defined Functions
  • Date and Time User-Defined Functions
  • String User-Defined Functions
  • Some useful UDF for SQL Server 2000
  • SQL Server 6.5

  • Data row structure in MS SQL 6.5
  • Data page structure in MS SQL 6.5
  • Locking in SQL Server 6.5
  • Update Methods Used in MS SQL 6.5
  • SQL Server 6.5: Nested-Loop Joins
  • SQL Server 6.5: Some useful trace flags
  • SQL Server 6.5 Security Modes
  • SQL Server 6.5: index statistics details
  • SQL Server 6.5 Useful undocumented stored procedures
  • SQL Server 6.5: Some useful undocumented DBCC commands
  • Using UNION ALL statement in SQL Server 6.5
  • Optimization tips for MS SQL 6.5: storage Nullable fields

  •  

     
    Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

    (c) 1997, 2010 Bits on the Wire, Inc