Thanks for the suggestion sir

Dear Jeff,

In that case, how to find unused indexes.

Good morning Gila Shaw Madam,

Actually, when the app team reports slowness in fetching data from application, we see Blocking due to access_methods_scan_range_generator and Latch_Ex. This may be co-incidence or may...

Good morning Gail Shaw Madam and Everyone,

To confirm that an index is unused, should the values for seeks,scans,lookups and updates be zero. That is, only if

seeks=0 and scans=0 and...

Dear Jeff,

Both are non-clustered indexes. I will try setting fill factor=80 or 70. Thanks sir

Dear Jeff sir,

I did not rebuild ALL indexes in the database with fillfactor=90. Only on some tables, index fragmentation was greater than 95%. For these indexes, i rebuilt with fillfactor=90...

Good morning Gail Madam and everyone,

I reduced the fill factor value, set it to 90 and then rebuilded the indexes. It worked for majority of indexes. However, for some indexes...

Dear Lowell,

Thats the catch. The login cannot be removed from db_owner. They have some reasons for it.

Dear Jonas

We want our app login(prduser) to have ONLY execute permission to procedures.It must NOT be able to ALTER or DROP stored procedure. It is allowed to do everything else....

Sir is a respectful term of address. I am an entry level while you all are already in the dba field for years. Hence, as a token of courtesy, I...

Dear Chris sir,

Openquery can tune/improve performance but the architect told not to replace linked server with openquery. This is because we are migrating to cloud and architect said that it...

sir,

I informed to colleague. He will run and check.

Ken sir,

Thanks for your response

Dear Chris sir,

There is remote join in the query you posted. I came across an article that says Remote join doesn’t work well on SQL server 2005. Ours is 2005.

https://www.mssqltips.com/sqlservertip/2765/revisit-your-use-of-the-sql-server-remote-join-hint/

The login had db_owner permission to the database. Will the trigger override the db_owner permission previlige?