Professor, é comum o AspNet Identity criar a tabela com o tamanho dos campos tão grandes desnecessariamente?
A maioria dos campos é nvarchar(max)
Código de criação das tabelas:
CREATE TABLE [dbo].[AspNetUsers]( [Id] nvarchar NOT NULL, [FullName] nvarchar NULL, [Email] nvarchar NULL, [EmailConfirmed] [bit] NOT NULL, [PasswordHash] nvarchar NULL, [SecurityStamp] nvarchar NULL, [PhoneNumber] nvarchar NULL, [PhoneNumberConfirmed] [bit] NOT NULL, [TwoFactorEnabled] [bit] NOT NULL, [LockoutEndDateUtc] [datetime] NULL, [LockoutEnabled] [bit] NOT NULL, [AccessFailedCount] [int] NOT NULL, [UserName] nvarchar NOT NULL, CONSTRAINT [PK_dbo.AspNetUsers] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO