splitting large table

Hot Topic

Convert, downsize, SQL Server database to Microsoft Access
SSIS Sequence container,data flow task
DTS & SQL Server Management Studio Express
how to create Extended procdure to invoke a webservice with C#
Help Please...request to send data to the computer running IIS has failed
Is there a way to protect an olap db meta data - technically
Copied Package ConnectionManager has photographic memory?
Puzzled by concurrent update
Generate RDL using XSDObjectGen XSD.EXE XMLTextWriter or XSLT...
DCOM Error 10016 Problem with opening http://localhost/reports$sqlExpress

SQL Server

Using a hyperlink in sql server reporting services
HTTP Access to Analysis Services 2005
with new hard drive- Error 3: the system cannot find the specified path
Migration of SQL Serve r2000 packages
Report Project and Report Designer
Possible to use Reporting Services w/o Sql Server?
better sql join
Chart Colours
Errors in OLAP storage Engine: The attribute Key cannot be found: URGENT
Certificate limitations in SQL Server 2005

splitting large table

can anybody help me, my previous collegue designed the database and created a table with around 100 columns which i feel is uneccesary and want to split , as the database is online, i am afraid to lose data , is there any solution.


Answer this question

splitting large table

  • doug gorman

    Not sure what your question is. If you split your table, you may have to update your application to retrieve values from both the tables using a join. Let us know the parameter you are working with and perhaps I can give some pointers.

    Thank you,

    Shankar
    Program Manager
    Microsoft SQL Server
  • splitting large table
Answer this question