Thanks so much for the reply . I really appreciate it and Sorry for the late reply .

I will try it in my production this week and see how...

Thanks mate ? I also came across that link but it’s not helpful unfortunately

Hi Guys ..

I have an issue with this error again in the different server … I guess this is SQL service Broker error but until now I have no idea...

Sounds good ..I also notice that all databases autogrowth option are 10% . Should I change all of them ?

I haven't changed the autogrow option yet , it is still in 10% growth position.

I am thinking to change it to 512 MB . What do you think ? Is...

Yayy you are right !

Now I get 99% free space . Thanks so much !!

Nothing stand out there ( after running EXEC sp_Who2 ACTIVE)

I also run OPEN TRAN to check if there is any open transaction

It said :

Transaction information for database 'XYZ'.

Replicated...

Hi ..

I have just talked to my team and it turns out that like is not necessary there so I can change it to = . Yayyyyy

Thanks for the advice...

Hi Grant

Thank you for the advice .

Unfortunately I got this error when I tried to create the Fulltext Index :

A full-text search key must be a unique,...

Hey Grant Fritchey,

Can you please review the attached execution plan please ?

Many thanks

Hi …

Here I attach the execution plans before and after adding index.

Before adding index , it uses clustered index scan and after adding index , it uses Index scan...

Thanks for the reply .

There has been a statistic in that column and yes I created index on that column as you can see below

CREATE NONCLUSTERED INDEX [IndexABC] ON...

I have just tested this query with some parameters

All of them cause long execution time ( around 8 until 12 secs per execution )

For example :

Before adding index

Duration...

I just checked database mirroring , in Principal server the status for each database is “Principal , Syncronized “ and in mirror server , each database is “ Mirror, Syncronized”

Does...

Actually there is 1 query which confuses me , so I added cover index (non clustered index ( key column is ABC.number with included columns – all columns in...