Are both databases on same server?

If so then simple it should be straight forward to look for new rows and insert them. To guess at the impact we need to...

can you clarify when you say merge db2 data to db1.

Do you want to:

1) clear the data in db1 and copy all the data from db2

2) add to...

To check if any scripting is incompatible you could script out the database objects, create a blank database not running 2000 compatibility mode and see if the script execute and...

How many tables ?

Do all tables have a primary key or some logic to match and compare ?

Redgate SQL Data compare does a pretty good job. Don't work for them...

What do you see as the problem with your query ?

The way I've done it in the past is much the same...

SELECT ProductID, MAX(SalesPerson), MIN(SalesPerson)

FROM Table

GROUP BY ProductID

HAVING MAX(SalesPerson) <>...

Some folks do it but I'd recommend not installing SSRS on a cluster. It's not cluster aware so you have to manually move enable/disable services and technically Microsoft dont support...

Opps, missed Doug. Sorry Doug. Select from users and left outer join to other tables required...

SELECT

u.UserName,

SUM(CASE WHEN ModuleName = 'Sales' THEN 1 ELSE 0 END) AS [Sales],

SUM(CASE WHEN ModuleName...

select

u.UserName,

SUM(CASE WHEN ModuleName = 'Sales' THEN 1 ELSE 0 END) AS [Sales],

SUM(CASE WHEN ModuleName = 'Production' THEN 1 ELSE 0 END) AS [Production],

SUM(CASE WHEN ModuleName = 'Marketing' THEN 1...

As per previous post, This test reduces reads to 3 Logical reads.....

DROP TABLE TEST

GO

CREATE TABLE TEST (ID INT IDENTITY(1,1), IPFROM VARCHAR(120), IPTO VARCHAR(120))

GO

INSERT INTO TEST(IPFROM) VALUES (1)

GO -- Add...

Here is an alternative to the between approach but it depends on what the data looks like in GepIPBlock.

If GepIPBlock.IpFrom and IPTo represent range of ip's or subnets like 123.123.123.1...

This is by design. DMV data is dropped when SQL Server is restarted. If you want to keep them you need to do some data collection into permanent tables either...

You will need to do the backup/restore and then create the additional filegoups and migrate tables / indexes into the appropriate filegroups by rebuilding the indexes. https://msdn.microsoft.com/en-us/library/ms175905.aspx

You can...

Not tried this but could you use a linked server and use the user mapping feature within the linked server to translate a local username to a remote username with...

It would be good to post the table and current index creation scripts.

This may not be the final solution but consider working on the query in two parts.

SELECT...

Depending on the business you are in, compliance can be a driver for using source control. In financial services you must be able to show a solid change management environment...