Resources For IT Professionals
Get this Tag RSS feed
Popular Tags

Browse by Tags

 >  TechNet Articles  >  All Tags  >  SQL Server Database
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...
    on15 Sep 2013

  • 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...
    on15 Sep 2013
Page 1 of 1 (2 items)
Can't find it? Write it!

Post an Article