SQL Server 2012 Full-Text search and XML Search - the Wiki project

RIL_button( “http://sqlconcept.com/2012/12/30/sql-server-2012-full-text-search-and-xml-search-the-wiki-project/”, “SQL Server 2012 Full-Text search and XML Search – the Wiki project” );

Finally, here are some results from the Wiki project.

After a few days of development, here is the accounting for the wiki project:

Desktop PC with 8Gb RAM, single home use HDD
SQL Server 2012, using XML and Full-Text search
the total amount of data

Continue reading [...] SQL Server 2012 Full-Text search and XML Search – the Wiki project [...]

December 30th, 2012 | Tags: , , , | Category: Baselining, Big Data, CPU, Data import, Full-Text Search, SQL Azure, The Wiki project | One comment - (Comments are closed)
Work on itWell, now...OKGoodGood job! (4 votes, average: 4.75 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Full-Text catalog properties - SQL Server

RIL_button( “http://sqlconcept.com/2012/12/29/full-text-catalog-properties-sql-server/”, “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

Continue reading [...] Full-Text catalog properties – SQL Server [...]

December 29th, 2012 | Tags: , , , | Category: Data import, Database Objects, Full-Text Search, SQL Azure, SQL Server 2012, T-SQL, The Wiki project | Comments are closed
Work on itWell, now...OKGoodGood job! (3 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Azure vs. inhouse SQL Server - the Wiki project - performance tuning

RIL_button( “http://sqlconcept.com/2012/12/27/azure-vs-inhouse-sql-server-the-wiki-project-performance-tuning/”, “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

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

December 27th, 2012 | Tags: , , , | Category: Baselining, Big Data, CPU, Data Generation, Data import, Database File Design, Database Objects, SSIS, The Wiki project | 2 comments - (Comments are closed)
Work on itWell, now...OKGoodGood job! (2 votes, average: 4.50 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

 
  Older Entries »