No announcements
Found 4078425 threads
-
0 VotesRe-partition Large Table
or if we need to copy the data into a new table (which would be huge time/space requirement). In short what is the best way to re-partition a ...Answered | 4 Replies | 836 Views | Created by Scott Dinnis - Wednesday, November 6, 2019 5:40 PM | Last reply by Dedmon Dai - Tuesday, November 12, 2019 8:02 AM
-
0 Votes
Best practice about table partition?
Hi, Gurus, As I have loaded massive data into a large table with over 300 million records. In order to speed up query against it, I want to know if there ...Answered | 3 Replies | 4083 Views | Created by PiggyZhou - Monday, June 8, 2009 3:57 PM | Last reply by Mohammad-Sufian - Tuesday, June 9, 2009 1:13 PM -
0 Votes
Removing a partition (the partition itself not the data in a partition) from a table
the ALTER TABLE tbl SWITCH to re-assign the data to the new table. Or if you want to move it to a new file group then you ...Answered | 4 Replies | 5466 Views | Created by Chaines - Wednesday, May 23, 2007 2:36 PM | Last reply by DaleJ - Wednesday, May 23, 2007 3:39 PM -
0 Votes
Dynamic table partition
if there is a new plan id . I can't do on decision date because at any given time it has only 2 years data and not always I need to extract from same ...Answered | 3 Replies | 422 Views | Created by ank hit - Monday, March 13, 2017 8:55 PM | Last reply by Erland Sommarskog - Tuesday, March 14, 2017 11:12 PM -
0 Votes
Table partition creation
Firstly, determine if you really want to partition it for each day. What is the volume of data that you are expecting/getting loaded into the table for each day? ...Answered | 5 Replies | 6075 Views | Created by ms_bi_pete - Friday, March 25, 2011 9:56 AM | Last reply by ms_bi_pete - Thursday, March 31, 2011 2:56 PM -
0 Votes
Partition the table
users can see sales data for only certain regions. Some users must be permitted to see sales data from multiple regions. I ...Answered | 1 Replies | 1948 Views | Created by jefferycxl - Friday, February 12, 2016 3:47 AM | Last reply by Benjamin Kettner - Wednesday, March 2, 2016 9:19 PM -
0 Votes
disadvantages of partition table?
should always take advantage of switch out switch in to delete and insert data. depending on your partitioned table ...Answered | 9 Replies | 13472 Views | Created by Tharindu Dhaneenja - Monday, May 28, 2012 4:49 AM | Last reply by Eric.Y.Zhou - Tuesday, May 29, 2012 7:51 AM -
1 Votes
partition table: transactionHistory/ transactionHistoryArchive scenario
preparation for the next monthly cycle. Each month, data from the oldest month is moved from TransactionHistory into TransactionHistoryArchive (with ...Answered | 3 Replies | 1113 Views | Created by kobosh - Monday, September 28, 2015 7:58 PM | Last reply by Ed Price - MSFT - Saturday, July 9, 2016 2:11 AM -
1 Votes
Querying table partition
= prv.function_id ORDER BY v FOR XML PATH('') ) --non-null partition boundaries + ...Answered | 2 Replies | 685 Views | Created by GD_SNC - Monday, August 1, 2016 10:16 AM | Last reply by Uri Dimant - Monday, August 1, 2016 11:55 AM -
2 Votes
Get table partition name
What do you mean by "partition name"? Check this blog post from Dan Guzman. Partition Details and Row ...Answered | 2 Replies | 9451 Views | Created by DVR Prasad - Friday, January 20, 2012 4:51 PM | Last reply by DVR Prasad - Friday, January 20, 2012 5:06 PM -
3 Votes
query data in partition table
normal table. Partitioned table to the end user is transparent. If you were asking for how to partition a table then the ...Answered | 6 Replies | 2738 Views | Created by xuyen le - Monday, August 27, 2012 7:21 AM | Last reply by Steven Wang - Shangzhou - Monday, August 27, 2012 9:17 AM -
0 Votes
partition SSAS table
manually. 4. Use Date keys from your Fact table( also you if you have other mostly commonly queried dimension) in query binding to ...Answered | 9 Replies | 3699 Views | Created by SQL Henry - Thursday, November 17, 2011 4:55 PM | Last reply by rok1 - Friday, November 18, 2011 3:11 PM -
0 Votes
Table partition issues
I have created a partition function. It is like there are 24 partitions and for each hour of a day one partition. for example if I insert data at 1 am(the table ...Answered | 1 Replies | 7556 Views | Created by Santhosh Kumar - Friday, June 23, 2006 3:59 PM | Last reply by Ryan Stonecipher - MSFT - Friday, June 23, 2006 4:30 PM -
0 Votes
Partition Table - Data and Index Filegroup
I am creating a partitioned table. With non-partition tables, I set up PRIMARY, DATA, INDEX and LOG filegroups to hold respective information. With ...Answered | 2 Replies | 6259 Views | Created by Jeelani Kamal - Tuesday, December 28, 2010 11:30 PM | Last reply by John Sansom - Wednesday, December 29, 2010 9:24 AM -
0 Votes
How to partition a sql server table
--create a staging table to temporarilly hold the right-most partition create table t_stage(id int) on ...Answered | 2 Replies | 670 Views | Created by Sudip_inn - Sunday, February 2, 2020 10:27 AM | Last reply by Dan Guzman - Sunday, February 2, 2020 12:03 PM -
0 Votes
Add sql server Partition scheme to a non partitioned table
User-595703101 posted Did you checkAnswered | 2 Replies | 38 Views | Created by Anonymous - Wednesday, July 21, 2010 6:19 AM | Last reply by Anonymous - Friday, July 23, 2010 7:19 AM -
0 Votes
table partition issue with index
hi everyone, i am stuck in a situation where i want to partition a very huge partitioned table , for this i created a partitioned function , ...Answered | 1 Replies | 2706 Views | Created by Shanu_Shri - Monday, October 3, 2011 7:22 AM | Last reply by Uri Dimant - Monday, October 3, 2011 7:30 AM -
0 Votes
Index then Partition or Partition only on 250gb table
to Partition this table by year and then compress old data to save space as they are rarely queried. ...Answered | 1 Replies | 1137 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
Table & Partition refresh duration
There does not appear to be a table or partition property displaying the refresh duration. I can measure indirectly using a SQL Agent job step that calls the refresh. ...Answered | 1 Replies | 544 Views | Created by Colin Hodges - Wednesday, June 7, 2017 3:20 AM | Last reply by willson yuan - Wednesday, June 7, 2017 7:55 AM -
0 Votes
add partition on existing table
step guide: https://www.mssqltips.com/sqlservertip/2888/how-to-partition-an-existing-sqlAnswered | 2 Replies | 636 Views | Created by AsmaGh - Wednesday, November 6, 2019 10:14 AM | Last reply by Rachel_Wang - Thursday, November 7, 2019 7:54 AM
No announcements
