No announcements
Found 3139301 threads
-
0 Votes
Indices on Partitioned Tables
So, I can create another partition scheme on the same partiton range and use one for data and other for indices.Answered | 6 Replies | 6033 Views | Created by ChiranSQL - Monday, May 9, 2011 4:11 PM | Last reply by ChiranSQL - Tuesday, May 10, 2011 3:04 PM -
1 Votes
Retrive data from a specific partition on a table
Does anyone has any idea on how to retrieve data from a selected partition of a table.Answered | 4 Replies | 641 Views | Created by naveej - Friday, October 10, 2014 2:12 PM | Last reply by Manish_Kaushik - Friday, October 10, 2014 2:57 PM -
0 Votes
Table partition performance
I think your intent of your first query is: SELECT col1,col2 FROM dbo.tblpartition (NOLOCK) WHERE gid = 1 AND ...Answered | 2 Replies | 3573 Views | Created by Old Garey - Tuesday, July 12, 2011 1:58 AM | Last reply by Dan Guzman - Tuesday, July 12, 2011 12:30 PM -
0 Votes
Partitioning table on a column
The other tables have there own Primary Key ( but of course not the CustomerID) and hence the data in such tables will not be in the sequence of CustomerID ...Answered | 3 Replies | 1893 Views | Created by Amit Birla - Wednesday, July 24, 2013 11:18 AM | Last reply by Dan Guzman - Friday, July 26, 2013 12:40 PM -
0 Votes
partitioning the table based on the Data column
This article explains how you can do it https://www.mssqltips.com/sqlservertip/2888/how-to-partition-an-existing-sql-server-table/ Basically you ...Answered | 3 Replies | 883 Views | Created by Ychinnari - Friday, March 9, 2018 2:04 PM | Last reply by Visakh16 - Monday, March 12, 2018 11:21 AM -
0 Votes
Table Partitioning
Hello Mohammad, You can use the $PARTITION (Transact-SQL) to query information about the partioning usage.Answered | 4 Replies | 1288 Views | Created by Mohammad.Siddiqui - Monday, May 6, 2013 9:40 AM | Last reply by Mohammad.Siddiqui - Wednesday, May 8, 2013 9:28 AM -
0 Votes
Table Partition Vs Cube Partition
These are two different things eventhough a cube partition could be aligned with a table partition but it is not required.Answered | 1 Replies | 1517 Views | Created by Navind - Monday, July 1, 2013 6:04 PM | Last reply by Hunchback - Monday, July 1, 2013 6:56 PM -
3 Votes
Generic Design of Partition of Tables.
I know each case is different for partition of tables; still we would need to follow some sequence in partition of tables. so waiting for your replies ?Answered | 5 Replies | 1281 Views | Created by Shivraj Patil - Friday, November 15, 2013 9:44 AM | Last reply by Dan Guzman - Friday, November 15, 2013 12:33 PM -
0 Votes
Partition table and index
Well, there is one particular operation where partitioning improves performance, and that is when aging old data.Answered | 2 Replies | 891 Views | Created by kolasani - Friday, February 21, 2014 6:19 AM | Last reply by Erland Sommarskog - Friday, February 21, 2014 8:00 AM -
0 Votes
Partition of table
Hello, To use partitionned tables you have to define morte than one file group on your database, define the partition function, the ...Answered | 1 Replies | 8327 Views | Created by D Murli - Monday, July 19, 2010 5:08 AM | Last reply by Jaouher KASRAOUI - Tuesday, July 20, 2010 1:22 PM -
0 Votes
how to load bulk data into partitioned table fast?
Hello envykok, If the partition is empty, then you can use a stagging table of the same structure; after loading the data you can switch the ...Answered | 1 Replies | 5764 Views | Created by envykok - Monday, January 11, 2010 4:45 AM | Last reply by Olaf Helper - Monday, January 11, 2010 5:22 PM -
0 Votes
table and index partitioning
>Is it necessary to partition all indexes on a table that has partitions?Answered | 1 Replies | 747 Views | Created by kvd123 - Tuesday, September 19, 2017 9:54 PM | Last reply by Lin Leng - Wednesday, September 20, 2017 5:24 AM -
0 Votes
Database and Database Table Partitioning
You do partitioning at the table/index level.Answered | 2 Replies | 955 Views | Created by ekuemoah - Wednesday, October 25, 2017 9:19 PM | Last reply by TiborK - Thursday, October 26, 2017 6:48 AM -
0 Votes
Partition Table
SQL does support partitioning: http://blogs.msdn.com/b/sqlazure/archive/2010/06/24/10029719.aspx.Answered | 1 Replies | 2175 Views | Created by rick.duarte-br - Saturday, January 5, 2013 6:59 PM | Last reply by Jeff Sanders - Wednesday, March 6, 2013 6:33 PM -
1 Votes
SQL Table Partitioning - by YEAR and columnstore index on Main table
You cannot switch in daily partition if your table is partitioned by year.Answered | 1 Replies | 1353 Views | Created by MittalPatel - Tuesday, June 9, 2015 9:16 AM | Last reply by Shakeel Ahsan - Wednesday, June 10, 2015 9:13 PM -
0 Votes
Index then Partition or Partition only on 250gb table
You can partition the heap without changing the design of your database.Answered | 1 Replies | 1275 Views | Created by Praba R - Monday, August 17, 2015 6:01 PM | Last reply by davidbaxterbrowne - Monday, August 17, 2015 6:35 PM -
0 Votes
Relaitonship Table Partition
Read the article from Brent Ozar before you decide ...Answered | 3 Replies | 1869 Views | Created by SubhadipRoy - Thursday, October 4, 2012 4:59 AM | Last reply by Uwe Ricken - Thursday, October 4, 2012 5:53 AM -
0 Votes
How to Partition an existing table by Year
The partition scheme should be: CREATE PARTITION SCHEME myPartitionScheme AS PARTITION [myPartitionRange] TO ([HistoricalFileGroup], ...Answered | 4 Replies | 808 Views | Created by Veena Srinivas - Thursday, April 2, 2020 6:57 PM | Last reply by Dan Guzman - Tuesday, April 7, 2020 9:48 AM -
3 Votes
Table Partitioning - Filegroup & Files
so am not sure how best to store Partitioned Tables on a SAN.Answered | 3 Replies | 4293 Views | Created by vikas_k - Wednesday, April 24, 2013 4:17 AM | Last reply by Kalman Toth - Saturday, May 18, 2013 4:36 PM -
0 Votes
Use of Switch partition in real world
From the Above Example, I need to specify the partition number of the stage table and partition number of target table(from ...Answered | 5 Replies | 10090 Views | Created by ravikiransid - Tuesday, December 4, 2012 11:51 AM | Last reply by Dattatray Nale - Tuesday, December 11, 2012 2:38 PM
No announcements