frederico_fonseca,

I need to calculate the total number of records in the table inserted for the current date.

For example, i.e Current date is December 8th, so I need to get the...

• This reply was modified 4 years, 11 months ago by  bhavi. Reason: typed wrong name

I ran into another problem when I applied the Like conditions of few columns in the Query

Whats does the following warning mention about

"the query memory grant detected excessive grant which...

I re-created the NonClustered Index on PictureTime and DeviceId, the performance had increased drasctically and executes in 1 sec

CREATE NONCLUSTERED INDEX [PicureTime_NCI] 
ON [dbo].[CapturedList]([PictureTime] ASC)
INCLUDE([DeviceId]) WITH 
(PAD_INDEX...

• This reply was modified 4 years, 11 months ago by  bhavi. Reason: modified query format