Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In a db full of data should I create new columns or a new table?

steiakakissteiakakis Member Posts: 2
In a project I work in we have a database which is filled with great amounts of data (meaning thousands of rows). In the course of things however the need for new columns in specific tables appears. For that reason we are creating new columns via are C++ framework, (using insertcolumn e.t.c.) one at a time. We are wondering therefore wether it would be more efficient to create a temp table to keep all the data we already have, create a new table with the extra columns needed and the transfer the Data from the temp table to the new one?

We use SQL Server 2000 under windows 2000

thank you

Comments

  • Andre YoungAndre Young USAMember Posts: 0

    _ [ http://forcoder.org ] free ebooks and video tutorials about { Python Visual Basic R C# MATLAB JavaScript Swift Delphi PHP Assembly PL/SQL Java Objective-C C++ C Ruby Perl Scratch Go Visual Basic .NET Scala Bash Erlang Kotlin Dart Awk LabVIEW D Julia Lisp Alice Logo ABAP Hack Crystal Fortran Apex Prolog COBOL Rust Scheme Lua FoxPro Transact-SQL Ada SAS Clojure VBScript F# ML } ______

Sign In or Register to comment.