[dba-VB] C# - Direct data manipulation

Shamil,

I have not.

All of that is rather esoteric stuff for a non DBA.  My job is processing data, and that is only a 
small part of my job, i.e. this is only one of many clients, and the only one that needs this kind 
of SQL Server stuff.

As I have said many times, if my job was to go into a company every day and play DBA then I would 
learn many more things SQL Server related.  As things stand I learn just enough to make things work, 
and a LITTLE extra in search of efficiency.  It is certainly not that I don't want to, I just don't 
have the time.

In the end I find the method I use comfortable from many angles.  I have to do some things that 
require creating views, other "processing" tables and so forth.  It really just works (for me) to do 
things this way, have separate databases to hold all of the "junk" associated with each list.  Kind 
of the old "encapsulation" thing.

Your suggestion would of course end up with all tables inside of a single "database", and as such 
the need for the Database parameter would go away but I still have to do the same thing to many 
different tables.

Again, could this be done by one of the experts on the SQL Server list.  Probably!  Will I ever get 
there?  Uhhhh doubtful.


John W. Colby
www.ColbyConsulting.com


Shamil Salakhetdinov wrote:
> John --
> 
> Have you tried to use MS SQL database filegroups and partitioned tables &
> views?
> 
> http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx
> 
> With them I suppose only initial import/insert of data have to be
> parameterized with table name, and the rest can be done without any dynamic
> T-SQL. Please correct me if I'm wrong.
> 
> Please note I'm not trying to "force" you to change your current working
> solution - just wondering is there a legal way to solve your task without
> dynamic T-SQL...
> 
> --
> Shamil
> 
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Wednesday, December 02, 2009 9:35 PM
> To: Discussion concerning Visual Basic and related programming issues.
> Subject: Re: [dba-VB] C# - Direct data manipulation
> 
> Shamil,
>