469,602 Members | 1,826 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Distributed view joining int and bigint

My company had a partitioned view across 5 SQL 2000 and 2005 clusters, with 1.9B rows of data, with the key using datatype of int. At this point, we need to convert everything to bigint very soon. We were hoping to change the view to cover both int and bigint so that we do not have to change all 1.9B rows of data to bigint. However, we are running into performance issue with these views.

Here is the setup:
- Clusters of 2000 and 2005, joined by partitioned view
- PK on int on old tables, with check constraint on each table
- New tables set up with bigint data type
- All check constraints converting the data types to bigint

Any suggestion would be appreciated.
Sep 10 '08 #1
0 1073

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by KK | last post: by
7 posts views Thread by J Goldman | last post: by
1 post views Thread by MK | last post: by
2 posts views Thread by Dave Bazell | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.