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 [...]
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.
Continue reading [...] Azure vs. inhouse SQL Server – the Wiki project – performance tuning [...]
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? [...]