|
Home > Archive > MS SQL Server > March 2006 > Table partitioning in SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Table partitioning in SQL Server
|
|
|
| Hi All,
Can some one tel me if SQL Server (Version 8) has any built in
table partitioning features or we need to code on partitioning the
table.
i have a table in which columns are created dynamically. Sometimes,
the total number of columns exceeds 1024 columns (max columns allowed
in a table). so the table creation fails.
Plz help me in this.
Thanks,
Sai
| |
| Tibor Karaszi 2006-02-28, 8:23 pm |
| In general, column created dynamically smells that you should look at the datamodel, and see if you
can achieve your goal in some other way. Perhaps turning those columns into rows. But to answer your
direct question: No, there is no horizontal partitioning features in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"sai" <p.saikrupa@gmail.com> wrote in message
news:1141020839.782743.131910@p10g2000cwp.googlegroups.com...
> Hi All,
> Can some one tel me if SQL Server (Version 8) has any built in
> table partitioning features or we need to code on partitioning the
> table.
> i have a table in which columns are created dynamically. Sometimes,
> the total number of columns exceeds 1024 columns (max columns allowed
> in a table). so the table creation fails.
> Plz help me in this.
>
> Thanks,
> Sai
>
| |
| doobdave 2006-03-30, 7:23 am |
| I'm very surprised that a "SQL Server MVP" should say that SQL Server does
not have any horizontal partitioning features... Tibor, are you really an MVP?
SQL Server BOL has several articles on horizontal partitioning.
Also, please see this link for more info:
http://msdn.microsoft.com/library/d...titionsindw.asp
And/or do a Google search for "Sql Server" "Horizontal partitioning", and
you should find all the info you need to get going.
Best Regards,
David
"Tibor Karaszi" wrote:
> In general, column created dynamically smells that you should look at the datamodel, and see if you
> can achieve your goal in some other way. Perhaps turning those columns into rows. But to answer your
> direct question: No, there is no horizontal partitioning features in SQL Server.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> Blog: http:// solidqualitylearning
.com/blogs/tibor/
>
>
> "sai" <p.saikrupa@gmail.com> wrote in message
> news:1141020839.782743.131910@p10g2000cwp.googlegroups.com...
>
>
| |
| Tibor Karaszi 2006-03-30, 7:23 am |
| > I'm very surprised that a "SQL Server MVP" should say that SQL Server does
> not have any horizontal partitioning features... Tibor, are you really an MVP?
Relax, that was only a typo from my side. If you read the original question, you will see that it is
about vertical partitioning. I just mistyped "horizontal" instead of "vertical".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"doobdave" < doobdave@discussions
.microsoft.com> wrote in message
news:07CA5123-E837-4A07-B2A0- 1B26CCEE5245@microso
ft.com...[color=darkred]
> I'm very surprised that a "SQL Server MVP" should say that SQL Server does
> not have any horizontal partitioning features... Tibor, are you really an MVP?
>
> SQL Server BOL has several articles on horizontal partitioning.
> Also, please see this link for more info:
> http://msdn.microsoft.com/library/d...titionsindw.asp
>
> And/or do a Google search for "Sql Server" "Horizontal partitioning", and
> you should find all the info you need to get going.
>
> Best Regards,
>
> David
>
> "Tibor Karaszi" wrote:
>
| |
|
|
|
|
|
|
|