Browse by Tags

Tagged Content List
  • Wiki Page: Using Bulk Insert to import inconsistent data format (using pure T-SQL)

    Table of Contents Introduction The problem Our Case Study The solution: STEP 1: Identify the import's file format Finding the problematic columns and the consistent columns format STEP 2: insert the data into temporary table Step 3: parsing the data into the final table Summary Comments Resources...
  • Wiki Page: Shrink SQL Database During Restore

    Table of Contents Case Study: First option: using compressed folder & symbolic link Step 1: Create a compressed folder Step 2: Backup your database Step 3: Create symbolic link to the compressed folder Step 4: Restore your database using the symbolic link. Step 5: Shrink the Database Step 6: Detach...
Page 1 of 1 (2 items)
Can't find it? Write it!