Artefact(ArtefactId,EntityTypeId,UserId,GroupId,ArtefactAttachmentId,Name,Summary,Description,TenantId...etc)

User(Userid,OrganizationID,TenantID,UserPassword,SecretQuestion,SecretAnswer,FirstName,MiddleName,LastName,Gender,DateOfBirth,DateOfJoining,Email etc...)

Rows (Artefact)

:(1,1,1,1,1,'Title','Summary','Desc',1,..etc)

Rows(User)

:(1,1,1,'password','Secrete Question','Secrete Ans','FirstName', 'LastName','MiddleName','LastName','M','14-04-2012','3-03-2010','email@email.com' etc...)

Ok I can share some information i.e I may fetch records from upto tables. The query may contains statements like UNION. e.g. ArtifactLibrary(ArtifactId,Title,CreationDate,....etc), Users(UserId,FirstName,LastName,etc...),

Groups(GroupId,GroupName,etc...)

ArtifactLibrary may contains records around 10Million, Users...

What's your experience say's, will this do the job? Doing something and reading something is altogether different job. I will use CTE, UNION and Paging along with Table Partitioning. But...

What i have concluded right now after some R&D is that Partition table can solve the issue. It will not only ease Manageability issue but also improve performance. What do...

I know that this depends on DB Design. We are already in development phase and I know we can use UNION statements for combining results from different queries, but I...

"You are not allowed to to use Full Text Indesing Service because of Azure limitations" apologies for skipping not

Yes we are planning to build up a multi tenant application that has millions/billions of records. To avoid the application to crash after a month, I am looking for a...