September 2006 - Posts

• Skipping rows in the datafile that contains NULL for a column that does not allow NULLs

  I recently ran into a customer who wanted to import data into a table that did not allow NULL for one column. However, his data file had some rows that had NULL for that column. He tried the following Bulk Insert command bulk insert customer.dbo.test Read More... Posted Friday, September 29, 2006 1:25 AM by Sunil Agarwal | 4 Comments Filed under: Bulk Import/Export

• What Master???

  I've come across a few interesting DR scenarios lately, (interesting in the sense that the resolution wasn't immediately obvious, and fortunately the answer didn't start out with "update your resume...") The situation that comes to mind is a customer Read More... Posted Tuesday, September 26, 2006 10:18 AM by kfarlee | 6 Comments Filed under: Disaster Recovery, Backup, Restore

• CHECKDB (Part 5): What does CHECKDB really do? (part 4 of 4)

  (Another airport, another blog post - I really must make an effort to come up with more original banter - I'm sure I've used that line before. TechEd Guangzhou has finished and I'm on the way to Beijing for TechEd #3. Checking in and getting through security Read More... Posted Wednesday, September 20, 2006 10:03 AM by Paul Randal - MSFT | 3 Comments Filed under: DBCC, DBCC CHECKDB Series

• Fragmentation (part 4): what are heaps?

  Ok - really catching up with the various blog post series I started back in June/July - time to bang out the next few posts in the series on index fragmentation. Remember I'm starting from first principles and covering What are records? What are pages? Read More... Posted Tuesday, September 19, 2006 2:18 AM by Paul Randal - MSFT | 9 Comments Filed under: Index Fragmentation Series, On-Disk Structures

• CHECKDB (Part 4): What does CHECKDB really do? (part 3 of 4)

  (OK - I was wrong about the posting frequency - events overtook me and I got bogged down preparing for these TechEds. China is an amazing place and I wish I had more time to soak up some of its culture while I'm here but with the TechEds being so close Read More... Posted Monday, September 18, 2006 10:43 PM by Paul Randal - MSFT | 4 Comments Filed under: DBCC, DBCC CHECKDB Series