At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!
CREATE TABLE tbl_Course_ExamModules ( CourseExamModuleID INT IDENTITY(1,1) NOT NULL, CourseCode VARCHAR(3) NOT NULL, ExamModule VARCHAR(10) NOT NULL, CashInCode BIT NULL, AcademicYear INT NOT NULL, StudentLevel INT NOT NULL, CourseModuleCount INT NOT NULL ) ALTER TABLE tbl_Course_ExamModules ADD CONSTRAINT pk_Course_ExamModules_CourseExamModuleID PRIMARY KEY CLUSTERED (CourseExamModuleID) CREATE UNIQUE NONCLUSTERED INDEX idx_CourseExamModules_Code_Module_Year ON tbl_Course_ExamModules (CourseCode, ExamModule, AcademicYear)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.