Thanks Gail for the quick responses.

So if we reduce the memory , say SQL is using 80 GB to 70 GB then what is the effect on stored...

Thank you for the replies.

It looks like after running slow for a day and users complaining, things became better and faster on day 2, Does it take a...

Also to mention the last minute issues from other team members who had the backup drive for 2 TB but did not have the data drive till the last minute.

Thanks Jeff for the responses. Since its a major project I wanted to get all the input and all doubts sorted out.
Finally on the big day, I just took...

Thanks Tom.
That table is used from legacy code.

I will ask them to update the column data type  with nvarchar(max).

Question is - will the import work...

Hi,

If you have a default instance , you can rename it to whatever following the steps above. ( Default instance means the instance name = hostname of the...