Posted by David Portas on 12/21/05 11:29

adi wrote:
> Advice noted. I will re-design the app. Meanwhile can anyone of you
> give me some nove ideas on how the whole thing can be scalable.
> Frankly I am new to SQL Server and new to 'planning'
>
> :-)
>
> thanks
> adi

Did you read the article in the link that Mike posted? That answers
your original question.

What I'm saying is that any efforts to support such a design would be
better invested in replacing it. If you don't have anyone with
experience of database design then you should hire someone because I
think you'll need more help than you can get in a newsgroup. If you
have a more specific question then come back and give us some details.

--
David Portas
SQL Server MVP
--

• Next in forum: Re: SQL/ASP - Timout Problem w/ Particular Statement
• Prev in forum: Re: Cannot resolve collation conflict for equal to operation.
• Thread view: Re: How to pass table names to a Stored procedure

[Reply to this message]