I have strong experience in T-SQL Developping, more then 5 years writing, tunning, solving issues in T-SQL code.
Reconstruction to maximize the performance of the database.
I have all instruments for working.
SELECT @@VERSION
GO
USE [DataBase]
GO
SELECT TOP 10 * FROM UserTable
Users
(Id,Login, FirsName,LastName,IsActive, CreatedDate)
Employee
(ID,FirsName,LastName,LastActivTime,IsActive,CreatedDate,UsersId)
Employee_History
(ID,FirsName,LastName,LastActivTime,IsActive,ChangeDate, UsersId)
Sales
(Sales_Id, EmpI_Id, Position, Date,IsActive,PartNuber, Qty, CreatedDate, UsersId )
Sales_History
(Sales_Id, EmpI_Id, Position, Date,IsActive,PartNuber, Qty, ChangeDate, UsersId)
CLS_ Position
(Id, Desc,isactive, ChangeDate, UsersId, EmpI_Id)
Fast speed completed.
Please let me this work.
Thank you.