No announcements
Found 921247 threads
-
0 VotesPartitioning best practice
Do I need to create a partition scheme and a partition function for each table or may I use the same ones for all the tables which have the same granularity?Answered | 2 Replies | 6772 Views | Created by ms_bi_pete - Thursday, March 23, 2017 8:28 PM | Last reply by Dan Guzman - Thursday, March 23, 2017 10:48 PM
-
10 Votes
Partitioning and File Groups best practices?
Is it also a good practice to have that clustered index (with the partitioned date key) on the table wit the column store (containing all columns) for partition alignment ...Answered | 13 Replies | 10837 Views | Created by Bassrocks27 - Tuesday, October 4, 2016 7:14 PM | Last reply by davidbaxterbrowne - Thursday, October 6, 2016 9:48 PM -
0 Votes
Aggregation design best practice when using partitions
Please refer to Aggregation Design Best Practices in the BOL below:Answered | 4 Replies | 3840 Views | Created by John Edwards NZ - Friday, July 31, 2015 1:21 AM | Last reply by Simon_Hou - Friday, July 31, 2015 10:14 AM -
0 Votes
removing old partition data - best practices
You cannot attach/detach partition files.Answered | 2 Replies | 4592 Views | Created by kr_b - Monday, November 9, 2009 9:00 AM | Last reply by Bikash Dash - Tuesday, November 10, 2009 6:51 AM -
0 Votes
any best practices for C partition please.
Doing this will delete all the data on the recovery partition.Answered | 3 Replies | 476 Views | Created by newtoazuree - Tuesday, October 23, 2018 9:14 PM | Last reply by JoeyLau-MSFT - Thursday, October 25, 2018 4:57 AM -
4 Votes
Best practice in table partitioning, seeking advice
You can still probably get to 20m rows without partitioning.Answered | 8 Replies | 8841 Views | Created by Kira76 - Thursday, August 5, 2010 5:57 AM | Last reply by JRStern - Monday, August 9, 2010 8:35 PM -
0 Votes
Suggestions and best practices for OLAP design
Hi Klimentina, In terms of data processing, number one, could be the best solution, because you can tune it up/partition accordingly to achieve this in case you ...Answered | 5 Replies | 1323 Views | Created by klimentina - Tuesday, July 15, 2014 10:05 AM | Last reply by Alan Koo - Tuesday, July 22, 2014 2:46 PM -
4 Votes
Best Practices
Best practice is option a.Answered | 5 Replies | 3007 Views | Created by RyanDunn - Thursday, July 16, 2009 4:18 PM | Last reply by Wyck - Thursday, July 16, 2009 6:32 PM -
0 Votes
Best practice PDW database backup strategy/plan
Hello , Consider partitioning large fact tables Consider partitioning fact tables that are 50 to 100GB or larger.Answered | 3 Replies | 2399 Views | Created by Anish_20 - Sunday, April 5, 2015 4:33 PM | Last reply by Anish_20 - Thursday, April 16, 2015 8:02 PM -
1 Votes
Best practice to install SQL Server
So I wanted to know how many data drives will be needed to install the SQL, and what is the best practice to install.Answered | 5 Replies | 927 Views | Created by Gautam Reloaded - Tuesday, August 7, 2018 4:26 PM | Last reply by Mohsin_A_Khan - Wednesday, August 8, 2018 12:15 PM -
0 Votes
Azure table design best practice
Basically, we have two options which have their advantages and disadvantages: One Option: having a single partition by having the same value for ...Answered | 3 Replies | 1426 Views | Created by Raj Krish - Thursday, November 20, 2014 12:27 PM | Last reply by Raj Krish - Friday, November 21, 2014 12:35 PM -
0 Votes
best practices
HI, General questions about best practices, Supposing I have a form that allow users to create new Database ...Answered | 1 Replies | 2965 Views | Created by Dagz - Sunday, September 7, 2008 4:08 PM | Last reply by Shimmy Weitzhandler - Monday, September 8, 2008 7:50 AM -
1 Votes
What is best practices to select storage options on azure
Hello Manish, here you find best practices of Data partitioning guidance ...Answered | 5 Replies | 1082 Views | Created by manishcal16PPS - Sunday, April 10, 2016 6:26 AM | Last reply by manishcal16PPS - Thursday, April 14, 2016 3:44 AM -
0 Votes
SQL Server HDD configuration best practice.
> What is the best way to install SQL 2005 with this drive array configuration?Answered | 1 Replies | 6735 Views | Created by dsantel - Friday, October 7, 2011 6:27 PM | Last reply by amber zhang - Monday, October 10, 2011 9:33 AM -
1 Votes
database file size best practice
I vaguely recall some discussions about keeping filesize below some number like that as a best practice for some obscure NTFS reasons, or something, which might ...Answered | 4 Replies | 8653 Views | Created by Skiiiiii - Monday, July 23, 2012 5:47 PM | Last reply by JRStern - Tuesday, July 24, 2012 9:31 PM -
2 Votes
SSDT Data Project for Warehouse Best Practices
Partitions are only one of the things I am concerned about.Answered | 2 Replies | 1305 Views | Created by SquattGmail - Friday, November 8, 2013 8:56 PM | Last reply by SquattGmail - Wednesday, November 13, 2013 4:01 PM -
2 Votes
Multi-tenant best practice
IMO, this kind deal should be a native abstraction by SQL server with some kind of tenant partition deal that does the right thing.Answered | 7 Replies | 3718 Views | Created by Rune Bjørnstad - Wednesday, May 11, 2011 9:18 AM | Last reply by Rune Bjørnstad - Thursday, May 12, 2011 7:28 AM -
0 Votes
Best practice
Ok, I have a question on what would be the best practice for a translator...Answered | 3 Replies | 4931 Views | Created by sontek1 - Tuesday, April 4, 2006 12:08 PM | Last reply by Brian Kramer - Wednesday, April 5, 2006 1:54 AM -
2 Votes
Team Services Best practice
Hi, There is a very useful guide on how to work the Team Foundation Server, includes patterns and best practices on how to deal with TFS from fundmentals to ...Answered | 2 Replies | 5408 Views | Created by PEARlS2016 - Wednesday, June 29, 2016 9:39 AM | Last reply by Mahmoud Tolba - Wednesday, June 29, 2016 10:57 AM -
0 Votes
xp_logininfo and Best Practice
The general best practice for security is to grant only the minimal permissions needed for an application to ...Answered | 2 Replies | 1062 Views | Created by grajee - Saturday, February 2, 2019 12:55 AM | Last reply by Dan Guzman - Saturday, February 2, 2019 4:36 PM - Items 1 to 20 of 921247 Next ›
No announcements
