Sorry mixed up the columns.Let me put it exactly what i am looking for.

Table A
Column A
1 
2 
3 
Column B
1
1
1

Table...

Thanks sue. Do you know 2008 R2 SP3 is the latest service pack right? There is no SQL Server 2008 R2 SP4 right?

Thanks  and appreciate Sue! However, the SQL server i am planing to upgrade does not have any important databases. This server is mainly used to host SSIS Packages, Jobs scheduling...

Thank you. Ok, I would like to try leave everything as is on the server and then upgrade without uninstall option. If i do the upgrade this will not cause...

I am looking to upgrade from SQL Server 2008 SP1 to SQL Server 2008 R2. So you mean there is no way to do inplace upgrade?

I see the blocking every 10- 15 mins and the blocking won't last more than 30 secs - 1 min.It blocks the FT CRAWL MON SPID and which seems to...

Do you have any monitoring tools?

I see that particular database log_reuse_wait_desc value is XTP_CHECKPOINT. Do you think this might be the problem for the log growth?

Thanks for everyone for the replies. The log growth is happened during index maintenance plan. However, trying to find what particular index is causing the log growth. I load the...

The SQL Server version is 2014. Its on same SAN before and After. Moved to new server with same configuration.

I have monitoring tool which is monitoring the server. However, how can i really measure past vs current. There are chances that lot of activity was going before and less...

Thanks for replying.

Actually we Just moved to new hardware i.e NEW SAN. Server configuration is same. Just wondering after moving to New SAN has made any improvements on the server...

I am running on 2008 SQL Server enterprise. Below is what i am getting

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type int.