|  | 1 | Putting some notes in here that relate to SQL Server specific isssues. | 
          
            |  | 2 |  | 
          
            |  | 3 | On the primary MS SQL server provided by the UHL, we have configured the following: | 
          
            |  | 4 |  | 
          
            |  | 5 | create database i2b2metadata | 
          
            |  | 6 | create database i2b2demodata | 
          
            |  | 7 | create database i2b2workdata | 
          
            |  | 8 | create database i2b2metadata2 | 
          
            |  | 9 | create database i2b2demodata2 | 
          
            |  | 10 | create database i2b2workdata2 | 
          
            |  | 11 | create database i2b2_b1_metadata | 
          
            |  | 12 | create database i2b2_b1_data | 
          
            |  | 13 | create database i2b2_b1_workdata | 
          
            |  | 14 | create database i2b2hive | 
          
            |  | 15 | create database i2b2pm | 
          
            |  | 16 |  | 
          
            |  | 17 | Links | 
          
            |  | 18 |  | 
          
            |  | 19 | This is useful on rebuilding indexes: http://www.sqldbpros.com/2010/11/sql-server-rebuild-indexes-the-fastest-way/ | 
          
            |  | 20 |  |