ALTER TABLE County ALTER COLUMN Name varchar(32)
ALTER TABLE Diagnosis ALTER COLUMN Name varchar(128)
ALTER TABLE Note ALTER COLUMN Body varchar(8000)
CREATE NONCLUSTERED INDEX IX_DiagnosisName ON dbo.Diagnosis (Name)
CREATE NONCLUSTERED INDEX IX_PaymentBilling ON dbo.Payment (BillingDate)
CREATE NONCLUSTERED INDEX IX_PaymentBillingRecievedDate ON dbo.Payment (ReceivedDate)

ALTER TABLE Person ALTER COLUMN FirstName varchar(128)
ALTER TABLE Person ALTER COLUMN LastName varchar(128)
ALTER TABLE Person ALTER COLUMN MiddleName varchar(128)
ALTER TABLE Person ALTER COLUMN State varchar(2)

CREATE NONCLUSTERED INDEX IX_PersonFirstName ON dbo.Person (FirstName)
CREATE NONCLUSTERED INDEX IX_PersonLastName ON dbo.Person (LastName)

ALTER TABLE Note ALTER COLUMN Body varchar(8000)

ALTER TABLE Payment ALTER COLUMN Method varchar(32)
ALTER TABLE Payment ALTER COLUMN Type varchar(32)


CREATE NONCLUSTERED INDEX IX_PaymentBillingDate ON dbo.Payment (BillingDate)
CREATE NONCLUSTERED INDEX IX_PaymentReceivedDate ON dbo.Payment (ReceivedDate)