SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Arshad Ali / SQL Server 2008 T-SQL Enhancements Part - V / Latest Posts

RE: SQL Server 2008 T-SQL Enhancements Part - V

david.white-836767 — Mon, 28 Sep 2009 05:22:30 GMT

Hi,Brilliant articles, full of helpful information - thanks for all the hard work.On what might seem a trivial point, I was a bit confused at first that at the bottom of ALL five articles, it says "This is the fourth ..."

RE: SQL Server 2008 T-SQL Enhancements Part - V

diopbirama — Thu, 03 Sep 2009 16:23:43 GMT

wondeful, I thank you a lot

RE: SQL Server 2008 T-SQL Enhancements Part - V

Arshad Ali-556241 — Thu, 03 Sep 2009 09:56:07 GMT

SQL Server 2005 introduced the ability to partition a large relation into smaller logical chunks to improve the administration and management of large tables. It has also been used successfully to improve query processing, especially when it comes to large decision-support applications. Further SQL Serve 2008 has enhanced this feature with partitioned table parallelism (PTP) feature.[b]Partitioned Table Parallelism[/b][url=http://technet.microsoft.com/en-us/magazine/cc434693.aspx]http://technet.microsoft.com/en-us/magazine/cc434693.aspx[/url]

RE: SQL Server 2008 T-SQL Enhancements Part - V

Arshad Ali-556241 — Thu, 03 Sep 2009 00:13:32 GMT

Hi,Thanks for your encouragement. Here are some pointers which might be helpful for you on table and index partitioning as well as on Filtered Index of SQL Server 2008.[b]Partitioned Tables and Indexes in SQL Server 2005[/b][url=http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx]http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx[/url][b]Partitioned Table and Index Strategies Using SQL Server 2008[/b][url=http://msdn.microsoft.com/en-us/library/dd578580.aspx]http://msdn.microsoft.com/en-us/library/dd578580.aspx[/url][b]Filtered Index of SQL Server 2008[/b][url=http://www.mssqltips.com/tip.asp?tip=1785]http://www.mssqltips.com/tip.asp?tip=1785[/url]

RE: SQL Server 2008 T-SQL Enhancements Part - V

diopbirama — Wed, 02 Sep 2009 17:43:05 GMT

great article,i'm waiting the part VI, hope that will be partition table and index .I'm a database admin in a a large telco industry in senegal and I want to organize my CDR( call data record) by monthly table within it il wish to create file group by month and also i want to partition the table by day and affect the partition of a day of week to their corresponding filegroup

RE: SQL Server 2008 T-SQL Enhancements Part - V

Steve Jones - SSC Editor — Mon, 31 Aug 2009 11:40:40 GMT

Nice job. A good introduction to spatial features.

SQL Server 2008 T-SQL Enhancements Part - V

Arshad Ali-556241 — Sat, 29 Aug 2009 14:05:10 GMT

Comments posted to this topic are about the item [B]SQL Server 2008 T-SQL Enhancements Part - V[/B]