| 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 | |