All good advice above.  Some other things to be aware of:

(1) You can't downgrade from Enterprise to Standard.  You'd need to uninstall and then reinstall.  If you have the SQL...

If you tried that on your data, you'd see that it won;t work.  It'll only select dates in the start month because you use "=" instead of ">".  Also, it...

Use DATEFROMPARTS to build the date from the given year and month.  For the end date, you'll want to add 1 to the month so that you include the whole...

That's not something I've ever had to do before, or even wondered how to do if I did. If you use SSMS to script out the database, then the ALTER...

Assuming that for each order line you have either an order date or an order date and a ship date (and no other rows), something like this should work.  If...

I can't reproduce that.  I created SAMPLETABLE from your script, and, since you didn't provide any sample data (only expected results), I inserted the values 1, 1, NULL, 1, 1. ...

With no DDL or sample data for TABLEX and TEST, we can but speculate.  My strong suspicion is that the TYPE_OF_ORDER column in TEST is int or some other numeric...

Unless I've missed something, this should work:

SELECT
tb1.table1id,
tb2.table2id,
tb2.name,
tb2.department,
tb2.city,
tb2.modifieddate,
tb2.linkingID
FROM #table2 tb2
INNER JOIN #table1 tb1
ON tb2.linkingID = tb1.linkingID
OR (tb1.city = tb2.city and tb1.department = tb2.department and tb1.name = tb2.name)

John

The easiest way to find out is to try it.  You won't break the database by attempting to restore a backup from the wrong place in the chain - it'll...

Try this.

John

They should automatically be granted access at installation, as NT SERVICE\MSSQLSERVER and NT SERVICE\SQLSERVERAGENT, certainly for modern versions (say 2012 and above).  Check that they exist on yours - if...

There's a column in backupset called description or backup_description or something like that.  Many third party utilities will write their name in there.

John

Jon

What are they interested in - the size it's going to take up on disk, or the size of the actual data in it?  Just add up the sizes of...

And so,Is there any way that I can fetch both at the same time(so that it can be completed in 6 mins only).

So did you look at my suggestion...

That's a "how long is a...