Select DATENAME(weekday, YourDateHere)

SELECT master.id, master.field1, child.field1

FROM master Left outer JOIN child on master.id = child.masterID

Did you try creating a definition table for different statuses such as pending , approved etc. You can have timestamp and userID which will help with query performance. May be...

Declare @nameoftable varchar(50)

set @nameoftable = 'your Table here'

Select *

from Sys.Columns C Inner join Sys.objects O

C.object_id = O.object_id

where O.name = @nameoftable)

We had a similar situation for not too big of a database and not too many changes.

We created a table to record the changes to the original table. The triggers...