MSSQLCity.Com - All about MS SQL
     
 About Us  
 SSWUG Articles  
 Articles  
 FAQ  
 Scripts  
 Tips  
 Test Exams  
 Advertise  
 Download  
 Search  
 Related Links  
     
Your button logo
Add to Favorites
 
     
 

History

|2003|2002|

December 16, 2003.

This article was added:
Understanding SQL Server 2000 Locking

MSSQLCity.Com contains:

  • 80 articles
  • 167 FAQ questions
  • 31 scripts
  • 269 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • December 7, 2003.

    This article was added:
    Troubleshooting SQL Server Jobs

    MSSQLCity.Com contains:

  • 79 articles
  • 167 FAQ questions
  • 31 scripts
  • 269 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • November 28, 2003.

    This article was added:
    Troubleshooting SQL Mail

    MSSQLCity.Com contains:

  • 78 articles
  • 167 FAQ questions
  • 31 scripts
  • 269 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • November 9, 2003.

    New Tips topic with 15 tips was added:
    Application Design Optimization Tips

    MSSQLCity.Com contains:

  • 77 articles
  • 167 FAQ questions
  • 31 scripts
  • 269 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • November 2, 2003.

    Two FAQ questions were added:
    How can I resolve the error 80040e21?
    How can I resolve the error 8007000e?

    MSSQLCity.Com contains:

  • 77 articles
  • 167 FAQ questions
  • 31 scripts
  • 254 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • October 26, 2003.

    Two FAQ questions were added:
    What is the difference between permanent and temporary tables?
    What is the difference between PRIMARY KEY and UNIQUE constraints?

    MSSQLCity.Com contains:

  • 77 articles
  • 165 FAQ questions
  • 31 scripts
  • 254 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • October 19, 2003.

    New Tips topic with 14 tips was added:
    Bulk Copy Optimization Tips

    MSSQLCity.Com contains:

  • 77 articles
  • 163 FAQ questions
  • 31 scripts
  • 254 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • October 12, 2003.

    Three FAQ questions were added:
    How can I make database to be read only?
    How can I set database to a single user mode?
    Why SELECT INTO statement does not work?

    MSSQLCity.Com contains:

  • 77 articles
  • 163 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • October 5, 2003.

    This article was added:
    SQL Server 2000 vs MySQL version 4.1

    MSSQLCity.Com contains:

  • 77 articles
  • 160 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • September 28, 2003.

    Three FAQ questions were added:
    What is the difference between char and varchar data types?
    What is the difference between clustered and nonclustered indexes?
    What is the difference between Oracle and SQL Server?

    MSSQLCity.Com contains:

  • 76 articles
  • 160 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • September 21, 2003.

    This article was added:
    Troubleshooting SQL Server Alerts

    MSSQLCity.Com contains:

  • 76 articles
  • 157 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • September 7, 2003.

    This article was added:
    Oracle 9i Database vs DB2 v8.1

    MSSQLCity.Com contains:

  • 75 articles
  • 157 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • August 31, 2003.

    Two FAQ questions were added:
    How can I add a user-defined error message?
    How can I grant to user the RESTORE DATABASE permission?

    MSSQLCity.Com contains:

  • 74 articles
  • 157 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • August 1, 2003.

    This article was added:
    Stored Procedures Administration

    MSSQLCity.Com contains:

  • 74 articles
  • 155 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • July 27, 2003.

    This article was added:
    Managing Users Permissions

    MSSQLCity.Com contains:

  • 73 articles
  • 155 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • July 20, 2003.

    This article was added:
    Reducing SQL Server Index Fragmentation

    MSSQLCity.Com contains:

  • 72 articles
  • 155 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • July 13, 2003.

    Three FAQ questions were added:
    How can I resolve the error 259?
    How can I resolve the error 1069?
    How can I resolve the error 80004005?

    MSSQLCity.Com contains:

  • 71 articles
  • 155 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • July 6, 2003.

    This article was added:
    Backup and restore databases and transaction logs

    MSSQLCity.Com contains:

  • 71 articles
  • 152 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • June 29, 2003.

    Three FAQ questions were added:
    How do I execute an operating-system command via Transact-SQL?
    How do I perform the same actions for all databases?
    How do I perform the same actions for all tables in a database?

    MSSQLCity.Com contains:

  • 70 articles
  • 152 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • June 22, 2003.

    Four FAQ questions were added:
    How do I read from the registry via Transact-SQL?
    How do I write to the registry via Transact-SQL?
    How do I delete a particular value for a key in the registry via Transact-SQL?
    How do I delete an entire key from the registry via Transact-SQL?

    MSSQLCity.Com contains:

  • 70 articles
  • 149 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • June 15, 2003.

    This article was added:
    Attaching and Detaching Databases

    MSSQLCity.Com contains:

  • 70 articles
  • 145 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • June 8, 2003.

    Three FAQ questions were added:
    How can I return from within a T-SQL the list of all character sets and code pages?
    How can I return from within a T-SQL the list of Windows NT/2000 groups?
    How do I reset the identity column?

    MSSQLCity.Com contains:

  • 69 articles
  • 145 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • June 1, 2003.

    This article was added:
    Using Microsoft SQL Server Constraints

    MSSQLCity.Com contains:

  • 69 articles
  • 142 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • May 25, 2003.

    One Maintenance script was added.
    One T-SQL script was added.

    MSSQLCity.Com contains:

  • 68 articles
  • 142 FAQ questions
  • 31 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • May 18, 2003.

    Four FAQ questions were added:
    How to install SQL scripts and import data to SQL Server from the command line?
    How to detect if the SQL Server is installed on the machine?
    What SQL Server editions support Custom Rollups?
    What SQL Server editions support Linked OLAP Cubes?

    MSSQLCity.Com contains:

  • 68 articles
  • 142 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • May 11, 2003.

    This article was added:
    Choosing SQL Server 2000 Data Types

    MSSQLCity.Com contains:

  • 68 articles
  • 138 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • May 4, 2003.

    This article was added:
    The comparison of SQL Server 2000 with Access 2000

    MSSQLCity.Com contains:

  • 67 articles
  • 138 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • April 27, 2003.

    Three FAQ questions were added:
    How can I return from within a T-SQL the list of all available OLE DB providers?
    How can I return from within a T-SQL the list of server's DSNs?
    How can I return from within a T-SQL the list of server's hard drives?

    MSSQLCity.Com contains:

  • 66 articles
  • 138 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • April 20, 2003.

    This article was added:
    The comparison of SQL Server 2000 with Sybase ASE 12.5

    MSSQLCity.Com contains:

  • 66 articles
  • 135 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • April 13, 2003.

    Three FAQ questions were added:
    How can I replicate objects permissions?
    How can I start replication agents via Transact-SQL?
    What SQL Server editions support replication?

    MSSQLCity.Com contains:

  • 65 articles
  • 135 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • April 6, 2003.

    This article was added:
    SQL Server 2000 vs DB2 v8.1

    MSSQLCity.Com contains:

  • 65 articles
  • 132 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • March 30, 2003.

    This article was added:
    The comparison of SQL Server 2000 with Oracle 9i

    MSSQLCity.Com contains:

  • 64 articles
  • 132 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • March 16, 2003.

    Two FAQ questions were added:
    How can I connect to OLAP cubes from the client's computer?
    What hardware and software requirements should I have for installing Analysis Services?

    MSSQLCity.Com contains:

  • 63 articles
  • 132 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • March 9, 2003.

    This article was added:
    Troubleshooting SQL Server 2000 installation issues

    MSSQLCity.Com contains:

  • 63 articles
  • 130 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • March 2, 2003.

    Two T-SQL scripts were added.

    MSSQLCity.Com contains:

  • 62 articles
  • 130 FAQ questions
  • 29 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • February 24, 2003.

    New Tips topic with 15 tips was added:
    Analysis Services optimization tips

    MSSQLCity.Com contains:

  • 62 articles
  • 130 FAQ questions
  • 27 scripts
  • 240 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • February 16, 2003.

    Three FAQ questions were added:
    How do I administer SQL Server remotely?
    How do I mark the stored procedure to automatic execution?
    I forgot the sa password. How I can reset it?

    MSSQLCity.Com contains:

  • 62 articles
  • 130 FAQ questions
  • 27 scripts
  • 225 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • February 9, 2003.

    This article was added:
    Troubleshooting OLAP Problems

    MSSQLCity.Com contains:

  • 62 articles
  • 127 FAQ questions
  • 27 scripts
  • 225 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • February 2, 2003.

    Three FAQ questions were added:
    Can I run OLAP Services 7.0 and Analysis Services 2000 on the same computer?
    What SQL Server editions support Data Mining?
    What SQL Server editions support user-defined OLAP partitions?

    MSSQLCity.Com contains:

  • 61 articles
  • 127 FAQ questions
  • 27 scripts
  • 225 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • January 26, 2003.

    New Tips topic with 15 tips was added:
    Optimization tips for designing tables

    MSSQLCity.Com contains:

  • 61 articles
  • 124 FAQ questions
  • 27 scripts
  • 225 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • January 19, 2003.

    Two FAQ questions were added:
    How many SQL 7.0 editions exist and what is the difference between them?
    How many SQL 2000 editions exist and what is the difference between them?

    MSSQLCity.Com contains:

  • 61 articles
  • 124 FAQ questions
  • 27 scripts
  • 210 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • January 12, 2003.

    Thirteen Index optimization tips were added.

    MSSQLCity.Com contains:

  • 61 articles
  • 122 FAQ questions
  • 27 scripts
  • 210 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • January 5, 2003.

    This article was added:
    How to troubleshoot connection problems

    MSSQLCity.Com contains:

  • 61 articles
  • 122 FAQ questions
  • 27 scripts
  • 197 tips
  • 4 test exams (on 75, 70, 10 and 10 questions)


  • |2003|2002|

     
    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