If you need to compare the 2, you will either need to do it manually (bleh) or with a tool.  Most tools that manage this are of the paid variety. ...

Fun thing - it makes no difference if you use UNION or UNION ALL.  Changes the result set for sure, but the estimated execution plan remains the same.  Performance with...

Happy to help.

There are advantages and disadvantages to all of the approaches.  linked servers can help reduce data duplication.  SSIS can allow you to transform the data as you go. ...

What error do you get and what is your expression for the visibility on the column?

I think you are going to be using the IIF and OR functions for the...

Fun thing you can look into - windowing functions.

For example, if you wanted to SUM Time1 ONLY by the EmpNo (as in your first query) and not by department, job,...

Rather than having us jump through the blogs and guess on the syntax for your UPDATE statement (and the probable typo), could you post the TSQL you used to do...

That error "SSL Security Error" is the problem for sure.  Best guess - the old driver is using a weaker encryption method than the new one so SQL is refusing...

My first thought - what error are you getting in the application and in your logs (SQL and Windows)?

My guess, without seeing your system and setup, is that it is...

That part is easy then -   Run the script.

The script is just plain TSQL used for re-creating the object.  It can be opened in SSMS or SQLCMD and run against...

If you want the data as well as the table, that method won't work.  If you ONLY want the table schema and don't care about the data, that will work...

There are multiple ways, but I like the "don't reinvent the wheel" approach.

Get a SQL Monitoring solution in place.  It will tell you about blocking, deadlocks, long running queries, etc...

I think it is one of those "it depends" questions.  Is it going to be used ONLY for development purposes only (ie no production data, no UAT, etc)?  Then there...

SQL Server only captures the data you give it.  So if you have no method of checking when data was inserted (modified date column for example), then you would need...

Glad I could help!

Adding clustered indexes is never a bad idea (you can have 1 per table), as long as your clustered index is on the correct column(s).  The ideal...

I just noticed my "UNICODE" examples got screwed up.

As for SheilaMajors's response about "LONG TEXT" and "MEMO", those are not valid SQL Server data types that I am aware of. ...