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 - performance tuning

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.

But on

Continue reading […] Azure vs. inhouse SQL Server – the Wiki project – performance tuning […]

 

How come the Hourglass? Why database applications slow down

A new article of mine is out!

This time I write about the meaning of “my database is slow” and what hidden secrets database contain. I.e. databases are never a single player in the game of performance.

Here is the article: How come the Hourglass? Why database applications slow down.