Changes between Version 2 and Version 3 of MS SQL issues


Ignore:
Timestamp:
11/01/11 12:07:47 (13 years ago)
Author:
Nick Holden
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • MS SQL issues

    v2 v3  
    11Putting some notes in here that relate to SQL Server specific isssues.
    22
    3 On linux boxes, accessing MS SQL is easiest using 'sqsh' a command-line Transact-SQL client.
     3On linux boxes, accessing MS SQL is easiest using 'sqsh' a command-line Transact-SQL client:
     4''sqsh -S UHLSQLBRICCSDB\\UHLBRICCSDB -U username -P password''
    45
    5 
    6 On the primary MS SQL server provided by the UHL, we have configured the following:
     6On the primary MS SQL server provided by the UHL (UHLSQLBRICCSDB\UHLBRICCSDB), we have configured the following for use by the i2b2 instance on uhlbriccsapp02:
    77
    88{{{
     
    2020}}}
    2121
    22 Links
     22And the following for use by the uhlbriccsapp03 i2b2:
     23
     24{{{
     25
     26create database i2b2_app03_metadata
     27create database i2b2_app03_demodata
     28create database i2b2_app03_workdata
     29create database i2b2_app03_metadata2
     30create database i2b2_app03_demodata2
     31create database i2b2_app03_workdata2
     32create database i2b2_app03_b1_metadata
     33create database i2b2_app03_b1_data
     34create database i2b2_app03_b1_workdata
     35create database i2b2_app03_hive
     36create database i2b2_app03_pm
     37}}}
     38
     39
     40=== Links===
    2341
    2442This is useful on rebuilding indexes: http://www.sqldbpros.com/2010/11/sql-server-rebuild-indexes-the-fastest-way/