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 […]
Recently I have been working with the Wiki project – just to prove that my desktop PC can be as fast as Windows Azure in hosting and searching through the entire Wiki content.
In order to do that I created a local database which contains all wikipedia articles in XML format and it uses XML indexing
Continue reading […] Full-Text catalog properties – SQL Server […]
As I blogged yesterday, the competition is on: in-house SQL Server vs. Windows Azure.
It does feel like the war of the robots!
Yesterday I started importing the data, and today I have some results.
Here are some notes of the process, though.
As I mentioned, I am using a home desktop with Pentium Dual Core E5400 @
Continue reading […] Azure vs. inhouse SQL Server – the Wiki project results […]