Viewing 15 posts - 391 through 405 (of 3,738 total)
Jacob Wilkins (11/23/2015)
First, the As Partition YearlyDateRange_pf All To ([Primary]) bit at the end of...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 23, 2015 at 2:33 pm
Thanks!
Could you please take a crack at correcting the syntax?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 23, 2015 at 11:02 am
Thanks for the information.
I have already created an Archive Database with a Lookup table used to control the batch size and the WHILE Loop.
Edit: Not sure to do with the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 20, 2015 at 2:36 pm
I would prefer to archive the database using code that I already wrote.
I do not see any value added in partitioning the table.
Another thing is that the current file groups...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 20, 2015 at 2:23 pm
Thanks Scott.
The current indexes could be a lot better.
The main problem is that the tables are so large.
They have old data which needs to be archived
Another issue is that the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 20, 2015 at 12:45 pm
I think that partitioning the tables is not the best approach.
There are hundreds of Stored Procedures and embedded T-SQL in .NET Code.
It could be a disaster.
All I need to do...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 20, 2015 at 11:28 am
Luis Cazares (11/20/2015)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 20, 2015 at 8:43 am
What circumstances do you consider in making an Index aligned or not?
I have googled but I have not found a straight forward answer.
Thank you.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 20, 2015 at 7:03 am
Thanks Gail.
Could you please provide me a few reason to do both?:unsure:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 19, 2015 at 4:22 pm
I am a lot more clear after reading the following articles:
http://blogs.msdn.com/b/felixmar/archive/2011/02/14/partitioning-amp-archiving-tables-in-sql-server-part-1-the-basics.aspx
http://blogs.msdn.com/b/felixmar/archive/2011/08/29/partitioning-amp-archiving-tables-in-sql-server-part-2-split-merge-and-switch-partitions.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 11, 2015 at 1:42 pm
What is really interesting is that all of the data files are on the same drive.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 10, 2015 at 2:38 pm
I had written code to archive tables into an Archive Database because some tables are very large and it is having an adverse impact on performance.
That was simple but I'm...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 10, 2015 at 2:22 pm
SQL Server 2012 Enterprise Edition SP2. Moving to 2014, probably soon.
Please let me know what other information that need to make a determination.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 9, 2015 at 5:37 pm
Jeff Moden (11/9/2015)
Welsh Corgi (11/9/2015)
I have been asked to Partition the tables.
Would I be better off to hold off on the archiving...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 9, 2015 at 5:16 pm
I created a new solution and now the Data Source tasks and data destination tasks are not visible.
What am I missing?
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 5, 2015 at 2:44 pm
Viewing 15 posts - 391 through 405 (of 3,738 total)