Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | anhar_fananiStarting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2007-03-21 : 04:31:44 
 |  
                                            | My company use SQL server 2005 standard. considering deal with huge data, how if we want to split data (date range yearly or monthly) in order to ease transaction. that's simply for us to use query, but how if we want to split data that can be easily execute by operator (non-admin privilege). Is there any another way? |  |  
                                    | harsh_athalyeMaster Smack Fu Yak Hacker
 
 
                                    5581 Posts | 
                                        
                                          |  Posted - 2007-03-21 : 04:49:21 
 |  
                                          | Read about Partitioning data in SQL 2005 Books online.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |  
                                          |  |  |  
                                |  |  |  |