Re: How Best to Store this Data

From: George Durzi (gdurzi_at_hotmail.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 14:42:21 -0700

One one hand, the SQL way is familiar, but as you said, it becomes a pain to
maintain the stored procedures and methods, etc.

The Xml alternative would be an interesting and different way to do this (
which is more preferable than sitting down to write a 50 parameter stored
proc ;)

I'll probably have about 1000 records per year. Does that qualify as a lot
of records, or is it still a manageable quantity for doing searches, etc.?

Thank you Bryan

"Bryan" <anonymous@discussions.microsoft.com> wrote in message
news:7FF35988-3A6E-46BB-9C7B-7FAE3DFCB5D6@microsoft.com...
> George,
> There are always advantages and disadvantages to everything... if
you're going to have a lot of records... you'll have to deal with the pain
of keeping up stored procedures and keeping evrything in SQL. If the amount
of records are going to be small then I'd go xml (This is what I've been
hearing). Searches through xml start to get slower as you create bigger
amounts of data. SQL is considerably faster through searches as your data
is bigger.

Relevant Pages

  • Re: How Best to Store this Data
    ... It sounds like you really do have a relational database (at least ... in a database product like SQL Server. ... > The Xml alternative would be an interesting and different way to do this ( ... > of keeping up stored procedures and keeping evrything in SQL. ...
    (microsoft.public.dotnet.framework.aspnet)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is there a way to convert ms sql 2008 tables to XML files?
    ... After looking at the code I made it work, since I removed 2 nVARCHARcolumns from the SQL statement where it is used as an RTF. ... I have the 2 XML files the bad and the good which are below: ... Verdana;}{\f1\fnil\fcharset0 Microsoft Sans ... Here is the actual string copied from the ms sql 2008 which works fine; ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: XML-Speicherung beim SQL Server 2005
    ... > also wenn die XML-Dokumente geparst werden, ... das der SQL Server dafür XQuery einsetzt. ... Struktur von XML. ...
    (microsoft.public.de.sqlserver)
  • Re: Help with Stored Procedure
    ... I did mean stuff like system stored procedures (even ... build the query, compile it, and optimize it, then, then this is less ... very not easy using dynamic sql. ...
    (microsoft.public.sqlserver.programming)