Thank you Travis.  I am doing Index, Stats and DBCC using Ola Hallengreen's scripts. 
I have also come up with a few projects on my own. 
1. Security Auditing
2....

Thank you Grant. 

I have some of them implemented already.  But you have given me a handful list of projects to work on.

Thank you. Let me explore.

Thank you for the response. 

There are 13 tables that are enabled for change tracking in the database. The largest table has 1.8 million records. 
The cleanup...

Thanks for your time to answer my question Brandie,

Let me check with them.

I have made sure that other linked servers from the source server is connecting successfully.

And...

To be specific, this is the error I see

OLE DB provider "SQLNCLI11" for linked server "XXX" returned message "Unspecified error".

OLE DB provider "SQLNCLI11" for linked server "XXX" returned message...

Thanks Luis

Brilliant...

Thank you very much Microsoft Certified MASTER...!!

Hi Gail,

Yeah. Since the supplied range is higher than the highest range value, It should return the TierLevelId for the maximum range.

Thanks!

Sorry..pressed submit before completion...

Dear SQL experts,

Thanks for looking into my question.

I have a scenario for which I can only write a query (No stored procedure 🙁 )..I am not...

14 views and no reply..Seems this is a rare tool so no one has any suggestions..??

I tried to change the size to 100,000 here...but it won't accept..

I have reduced the size of the files in the GUI "Database Properties" from 150+GB to 100 GB and restarted the server (Please look at the attachment). But that did...

Hi, I have restarted the SQL Instance before and it grew up again.

Thanks!

Siva.

Thanks Kevin for your inputs. I will consider them while I am analyzing this issue.