tag:blogger.com,1999:blog-7924929528826389309.post2273344184095242246..comments2024-03-28T01:12:26.334-07:00Comments on Tips and Tricks for SQL-BI: Table PartitionHari Sharmahttp://www.blogger.com/profile/17519330349426599363noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7924929528826389309.post-917662299951164452010-05-17T02:39:39.697-07:002010-05-17T02:39:39.697-07:00NO i just have a primary file groupNO i just have a primary file groupRahul Shandilyahttps://www.blogger.com/profile/17673580466422284009noreply@blogger.comtag:blogger.com,1999:blog-7924929528826389309.post-86075643794537940392010-05-14T09:48:29.480-07:002010-05-14T09:48:29.480-07:00Hi Rishi (Rahul),
Did you create multiple file gro...Hi Rishi (Rahul),<br />Did you create multiple file groups or datafiles? To find out the actual root cause, I would like to know the Partition Function and Schame you have had implemented on those tables.Hari Sharmahttps://www.blogger.com/profile/17519330349426599363noreply@blogger.comtag:blogger.com,1999:blog-7924929528826389309.post-76630598987830290702010-05-14T05:51:16.529-07:002010-05-14T05:51:16.529-07:00I have a table "AdvAcFinancialDetail" i...I have a table "AdvAcFinancialDetail" in which i have 25 lacs record <br /><br />I have create another thable that have same record as table "AdvAcFinancialDetailPartition"<br />I have Created A PartitionFunction and partitioned schema on this table on the "AccountKey" column <br /><br /><br />But when i execute a query on both table <br /><br />With where Condition <br />AC_KEY>7000000 AND AC_KEY<8000000<br /><br />Both query takes Same time why?<br /><br /><br />as I have created a partion on one table <br /><br /><br />ReasonRahul Shandilyahttps://www.blogger.com/profile/17673580466422284009noreply@blogger.comtag:blogger.com,1999:blog-7924929528826389309.post-35594746033464432952010-05-13T23:34:33.714-07:002010-05-13T23:34:33.714-07:00Hi Rahul,
Good to hear a comment! You had posted a...Hi Rahul,<br />Good to hear a comment! You had posted a very good question. I am giving two approaches to answer your query:<br /><br />Approach1:<br />-----------<br />Create new table using T-SQL code provided in the Post and Load data from existing table to new table. Once data is loaded, Drop existing table and shrink database. You may or may not like this approch.<br /><br />Approach2:<br />-----------<br />1. Alter your database and add new file groups.<br />2. Create Partition Function for required Ranges.<br />3. Create Partition Scheme and add above file groups.<br />4. Create Culstered Index on existing table using above Partition Scheme to move data in partitions.<br /><br />However I am planning to post a new title "Table Partitioning to an existing table"Hari Sharmahttps://www.blogger.com/profile/17519330349426599363noreply@blogger.comtag:blogger.com,1999:blog-7924929528826389309.post-15081723073591146522010-05-13T04:20:45.496-07:002010-05-13T04:20:45.496-07:00how to creat partition on existing table and datab...how to creat partition on existing table and databaseRahul Shandilyahttps://www.blogger.com/profile/17673580466422284009noreply@blogger.com