Improve company productivity with a Business Account.Sign Up

x
?
Solved

Multple boundary Limits for sql server partition

Posted on 2010-11-10
2
Medium Priority
?
501 Views
Last Modified: 2012-05-10
Can we have mutiple boundary limits while setting the partition on the database?
I am talking about having something like  monthly partitions which gets merged into yearly partition at the end of the year.
 
0
Comment
Question by:venk_r
2 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 750 total points
ID: 34102918
not in the same table
0
 
LVL 8

Author Closing Comment

by:venk_r
ID: 34243004
THANKS
0

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question