.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Partitioning

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server
 

Hi,

I have a table which is 65 GB at present and will grow to 1 Terabyte in a year. We get data at daily level

1) What should be the maximum size of a Partition in a Partitioned Table in MBs or GBs?

Thanks,

 


Amit


View Complete Post


More Related Resource Links

Partitioning a table in SQL Server 2008

  
Our application has got few tables which has grown to a larger size. Hence one suggestion put forward is to consider table partitioning. Since this does not involve any code changes in the application, we are looking into this option. 1. Is there any disadvantage if we use table partitioning feature 2. Will table partitioning affect the current indexes that exist on the table? 3. Database mirroring is enabled in our schema. Will partitioning have any effect on this? 4. Any suggestion on how we should try this out?  

Partitioning Indexes

  
I have a partitioned table that has a partitioned index.  If I add another index does it have to be partitioned as well or can I have some partitioned indexes and some not? Thanks.

Problems joining Partitioned Tables and using the partitioning!

  

Hi,

I am joining three tables called "SNAP", "TABLE_A" and "TABLE_B" both of these 3 tables are partitioned by DAY_CODE column of type integer.
TABLE_A is about 10 million rows ( about 2 millions per day ), TABLE_B is like 60 million rows ( about 12 million per day ) and SNAP table is just a small table saying what days i have.

So, i am trying to use a query like this:

select ....
FROM SNAP S
INNER JOIN TABLE_A A
 ON S.DAY_CODE = A.DAY_CODE
INNER JOIN TABLE_B B
 ON S.DAY_CODE = B.DAY_CODE
 AND A.ID = B.TABLE_A_ID
WHERE S.DAY_CODE = 20100923

Like you can see, i am just using the SNAP table to align the filtering on the partitioned column. The problem is that the partitioned is not selected and somehow all columns of TABLE_B at least are being scanned for what the explain plan tells me. ( It runs for more than 12 hours and no results ).

If i change the query to:

Problems joining Partitioned Tables and using the partitioning!

  

Hi,

I am joining three tables called "SNAP", "TABLE_A" and "TABLE_B" both of these 3 tables are partitioned by DAY_CODE column of type integer.
TABLE_A is about 10 million rows ( about 2 millions per day ), TABLE_B is like 60 million rows ( about 12 million per day ) and SNAP table is just a small table saying what days i have.

So, i am trying to use a query like this:

select ....
FROM SNAP S
INNER JOIN TABLE_A A
 ON S.DAY_CODE = A.DAY_CODE
INNER JOIN TABLE_B B
 ON S.DAY_CODE = B.DAY_CODE
 AND A.ID = B.TABLE_A_ID
WHERE S.DAY_CODE = 20100923

Like you can see, i am just using the SNAP table to align the filtering on the partitioned column. The problem is that the partitioned is not selected and somehow all columns of TABLE_B at least are being scanned for what the explain plan tells me. ( It runs for more than 12 hours and no results ).

If i change the query to:

Vertical partitioning

  
Horizontal partitioning can be implemented so as to be transparent to the client application.  Is it possible to implement vertical partitioning which is transparent to the client.  We use a third party app that relies on the schema they built and want to implement partitioning to increase performance.
John Schroeder

document/file partitioning in a web farm

  
I have a .Net application running on a web farm that allows users to upload files and download them later via link to that file.  Currently, I use Windows DFS to replicate the local IIS directory where the files are stored across the web farm servers (/data).  However, as this solution does not scale out, I want to implement a more scalable solution by partitioning the documents.  Specifically, say I set up multiple file storage servers (Fs1, Fs2, Fs3, etc.) on the network.  Further, let's say I change my upload page to save the uploaded file to one of the file storage servers on the local LAN (based on some logic).  I assume so far I am safe with ASP.NET doing this much assuming I have the correct permission for the ASP.NET process ID.  The question I have is with regards to download links.  When a user gets served a download link to their document (e.g. http://www.testco.com/data/doc1.txt) is there a way for me to "intercept" that HTTP request and underneath the covers serve the doc1.txt from the file storage server (e.g. Fs2) it resides on?  Any sample code would be appreciated.  Thanks.

Cube Partitioning by Year and month in SSAS 2008 R2

  
Hi there,
I need to make partitions by year and month in a SSAS cube to improve the performance. Please let me know the process.

Thanks,
Palash
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend