Wednesday, December 26, 2012

Total size of an index or primrary key cannot exceed 900 bytes


When we are making primrary key of a multiple columns , then normally we can face this limit of sql server. Thats fixed and hard limit. You have to simply reduce the size of your columns on which you are creating primrary key .

if you ask why ?  I also dont know why this type of limits are used in MS  SQL SERVER .

No comments:

Post a Comment

ASP.NET Core

 Certainly! Here are 10 advanced .NET Core interview questions covering various topics: 1. **ASP.NET Core Middleware Pipeline**: Explain the...