There are several ways of storing XML documents in SQL Server table.
One way is to use a table with datatype varchar(max) or nvarchar(max).
another option is to use XML data type column
or you can use varbinary(max)
if you are using SQL 2012, then there is yet another option: use filetable and filestream
Let’s look quickly at these options:
Continue reading […] Storing XML in SQL Server – note to self […]
In my earlier blog post I wrote about setting up the WikiDB database and importing the files.
Initially I was inclined to import the XML files as they came – the files had different sizes ranging from 140 Mb to 7 Gb.
I managed to import the first 12 files, and thought I would stop there.
Continue reading […] Azure vs. inhouse SQL Server – the Wiki project – performance tuning […]
Recently I got a question:
We are thinking to use partitioning for our DW database, since we have monthly incoming data of 30 million rows and partitioning will make the reads and writes much faster; we are using a 2 CPU machine with 16 Gb, 2 hard drives of 500Gb each.
Could you recommend a good strategy
Continue reading […] Can partitioning solve it all? […]