Tag Archive: xml

How to Import the StackOverflow XML into SQL Server

Want to play around with the StackOverflow database export?  Here’s how to import the XML files into SQL Server, and some notes about the tables and data schema.
Script to Import StackOverflow XML to SQL Server
This T-SQL script will create six stored procedures:

usp_ETL_Load_Badges
usp_ETL_Load_Comments
usp_ETL_Load_Posts
usp_ETL_Load_Users
usp_ETL_Load_Votes
usp_ETL_Load_PostsTags (which isn’t one of the StackOverflow tables – more on that in a [...]

Read the full article »

WOOHOO!
Mar 3 - Day with the DMVs - free day-long webcast about performance tuning.

Apr 17 - SQLSaturday Chicago - I'm doing the keynote with Kevin Kline.

More Upcoming Events