tag:blogger.com,1999:blog-5849265.post116151764514117096..comments2023-10-29T20:45:15.971+05:30Comments on Vadivel's blog: Brief Theoretical Knowledge about Table PartitioningVadivelhttp://www.blogger.com/profile/13387133927257826888noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5849265.post-57920097383207150492007-02-20T08:47:00.000+05:302007-02-20T08:47:00.000+05:30Thats true. My argument holds good as long as the ...Thats true. My argument holds good as long as the users haven't changed their default filegroup of installation :)Vadivelhttps://www.blogger.com/profile/13387133927257826888noreply@blogger.comtag:blogger.com,1999:blog-5849265.post-44679534720837134332007-02-20T08:31:00.000+05:302007-02-20T08:31:00.000+05:304. For your information, default Filegroup is alwa...4. For your information, default Filegroup is always “primary filegroup“. If at all you don’t believe me! Create a dummy table something like this,<BR/><BR/>Create Table Test<BR/>(<BR/>sno int<BR/>)<BR/>Go<BR/><B><BR/>Alter database xyz modify filegroup abc default;</B><BR/> will change the default filegroup for new object creation.Anonymousnoreply@blogger.com