It will help in the fact that the indexes you build on each table will be smaller.

But will mainly help if you query by the item you separate the tables...

A little difficult to discuss in a forum

Check out this Tut

http://www.sqldts.com/default.aspx?278

Try

strSelect = "Select * From DocTable1 Where " & @fieldname & " = @text"

Does your problem seem to resolve after a server reboot?, or just a sql server service stop and start?

In any case it sounds like you have found the shotgun approach...

Small.

For a couple reasons, Isolates code so if there is an error it will be in a single smaller procedure.

Re Use, you can reuse smaller insert/update procedures as singles in...

Unfortunatelly you have to perform a union

Select 'First Name' as FieldName, FirstName as Value

From mytable

where id = 1

union

Select 'Last Name', LastName

From mytable

where id = 1

Select 'Gender', Gender

From mytable

where id =...

Who is this someone?

And does this someone know that the case statement is the most effective way to implement this?

What does this someone Propose you do instead?

You have the solution,...

1)  Do I need a developer edition for each computer to use client tools to access the SQL servers with standard edition?

No, Client tools do not require a license. and...

Look in sql server books online for "Image" Data type

or follow a similar post

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=236476

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_13_8orl.asp

WHy is there an issue with having gaps in your student id?

You are creating a ton of additional logic and time keeping the numbers contiguous.

Note: Sql server does not "care"...

Look up Text datatype in books online, they are different data types and take additional design and management requirements.

From books online about text:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_13_8orl.asp

I would pass the file information in...

A good read:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133

Where review_date < dateadd(d, -7, getdate())

are there any Null Values?

Select * from  po_shipment where container is NULL

Sure, just apply a default to the parameter

Create procedure myprocedure @var1 int, @var2 int = 0

as

if @var2 <> 0

begin

   Do something

end

Else

Begin

   Do something else.

End

For this procedure to execute you Must...