Re: No of columns in a table
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/20/04
- Next message: Viswanatha krishnan: "Auto number and boolean"
- Previous message: Vishal Parkar: "Re: query to list field data types"
- In reply to: Retna: "No of columns in a table"
- Next in thread: Hugo Kornelis: "Re: No of columns in a table"
- Reply: Hugo Kornelis: "Re: No of columns in a table"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Apr 2004 10:48:00 +0530
Hi,
Columns per table : 1024
How it will affect the performance of a query:
Columns in a table will not affect the performance of the query in anyway,
The performance will be affected based on TSQL
statement and Index you are using.
What is the optimum max no of columns a table can contain?
There is no such restrictions on this.
Thanks
Hari
MCDBA
"Retna" <anonymous@discussions.microsoft.com> wrote in message
news:DA96640E-9762-4761-A199-042DA2101E6D@microsoft.com...
> Hi all,
> Is there a limit on no of columns in a table. How it will affect the
performance of a query. What is the optimum max no of columns a table can
contain.
> Pls give your expert advice .
- Next message: Viswanatha krishnan: "Auto number and boolean"
- Previous message: Vishal Parkar: "Re: query to list field data types"
- In reply to: Retna: "No of columns in a table"
- Next in thread: Hugo Kornelis: "Re: No of columns in a table"
- Reply: Hugo Kornelis: "Re: No of columns in a table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
- DTS ActiveX task
... I have a task that I want to use a combination of ADO recordsets and TSQL. ...
How do I, for instance perform a count query, and do some functionality ... (microsoft.public.sqlserver.dts) - Re: How to View Result Data with SQL Profiler?
... > Is it possible to see the result set data returned by a query in SQL ...
> I can see the TSQL inside by Stored Procs listed in my trace, ... (microsoft.public.sqlserver.programming) - View Results With SQL Profiler?
... Is it possible to see the result set data returned by a query in SQL ...
I can see the TSQL inside by Stored Procs listed in my trace, ... (microsoft.public.sqlserver.tools) - How to View Result Data with SQL Profiler?
... Is it possible to see the result set data returned by a query in SQL ...
I can see the TSQL inside by Stored Procs listed in my trace, ... (microsoft.public.sqlserver.programming) - Re: Unique
... Execute the below TSQL in query analyzer:- ... > Which stored proc
can be used to list all the unique constraints in all ... (microsoft.public.sqlserver.server)
