Storing XML in SQL Server - note to self

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:

The

Continue reading […] Storing XML in SQL Server – note to self […]

 

Full-Text catalog properties - SQL Server

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 […]

 

Azure vs. inhouse SQL Server - the Wiki project results

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.

The Hardware:

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 […]