We need sample data and your SP to troubleshoot more on this case. Actually recompile what I understand every time execution will create a new query plan. It can better...

Good Question. Learned something new.

Thanks for the easy question. It seems like you are very specialist in views.

Cheers !!!!!.

Nice !!!. Good to learn knew stuff !!!!.

Thank you very much !!!!!.

Thanks for the reply.

job 1. Runs every two minutes.

begin transaction

-- adds a record with specific date the records were moved from

-- ABI_ACCOUNTS to ABI_ACCOUNTS_DS_TRACK

insert into ABI_ACCOUNTS_DS_TRACK.dbo.HISTORY_DATES_PROCESSED(PROCESSED, HISTORY_DATE)

values(0, @starttime)

insert...

Shrinking is not a good practice. Even it is for a transaction log also. You have to plan to add more space.

Just I need to understand what circumstances you want to shrink the log file. Do you have transaction log backup going on? Are you in need of space released to...

Hi Gail,

Thanks for the clarification.

Hi Bit Bucket,

Thanks for the easy question.

--- Babu

Good Question.....

High availability always comes with business nature and the budget.

SQLserver have many ways of high availability. Using cluster, replication, mirroring.

You have to choose what your business needs suits....

Why this question has to appear on high availability?

Hi Steve,

Question on SQL 2012. I guessed and guessed it wrong.

Good. to knew about contained databases.

--Babu

Hi Bit bucket,

Thanks for the question. I would expect to attach any external reference to the question. Thought it is easier question for experienced person, it will help for...