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 ...

 

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 ...

 

Connecting to SQL Server - latency, part 1

RIL_button( “http://sqlconcept.com/2012/12/18/connecting-to-sql-server-latency-part-1/”, “Connecting to SQL Server – latency, part 1″ );

After clarifying the terminology in my previous post, it is time to perform some use cases.

In this use case I will take a simple query, like this one:

?Download download.txt1
2
3
4
5
6
7
8
9
10
11
12
13
14
use [AdventureWorks]
 
SELECT TOP 10 [SalesOrderID]
,[SalesOrderDetailID]
,[CarrierTrackingNumber]

Continue reading [...] Connecting to SQL Server – latency, part 1 [...]

December 18th, 2012 | Category: Benchmarking, CPU, Memory, SQL Latency Monitor | One comment - (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 »