Storing XML in SQL Server - note to self

RIL_button( “http://sqlconcept.com/2013/02/27/storing-xml-in-sql-server-note-to-self/”, “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

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

February 27th, 2013 | Category: Database File Design, SQL Server 2012 | Leave a comment
Work on itWell, now...OKGoodGood job! (No Ratings Yet)

If you give 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 ...

 

Can partitioning solve it all?

RIL_button( “http://sqlconcept.com/2011/06/22/can-partitioning-solve-it-all/”, “Can partitioning solve it all?” );

Recently I got a question:

We are thinking to use partitioning for our DW database, since we have monthly incoming data of 30 million rows and partitioning will make the reads and writes much faster; we are using a 2 CPU machine with 16 Gb, 2 hard drives of

Continue reading [...] Can partitioning solve it all? [...]

June 22nd, 2011 | Category: CPU, Data Warehousing, Database File Design, Disk System, Indexing, IO, Memory, Performance audit, Ramblings | One comment - (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 ...

 

 
  Older Entries »