Before and after backup log, can you run this command and post the result here?

dbcc sqlperf(logspace)

this command could return the physical and logical size of actual log. Sometime, the physical...

Eirikur Eiriksson (11/6/2014)

---

Quick thoughts, first is that the non-clustered index is not a covering index and will require an additional key lookup to satisfy the query output. Therefore the server...

Sorry guys, tied up on other stuffs yesterday, here is the schema of table:

CREATE TABLE [dbo].[Testing_table](

[id] [int] IDENTITY(1,1) NOT NULL,

[message] [nvarchar](max) NULL,

[message_text] [text] NULL,

[name] [varchar](10) NULL,

[created_date] [datetime] NOT NULL,

CONSTRAINT...

o... thanks a lot !!!

exec 2 query separately is a good idea, thanks to knock me up !!!