Or, since we're dealing with JOINs:

What is the difference between INNER JOIN and LEFT OUTER JOIN?

What is the difference between LEFT OUTER JOIN and RIGHT OUTER JOIN?

What is a FULL...

Yep, exactly. It sounds like some type of certification q too, where because MS mentions "restricted" in BOL or some other help, you're supposed to remember it exactly and...

Is that really necessary? Do you re-index all tables or just those that really need it? Hopefully you don't...

If the incoming data is sorted in clustering key order, you can add an:

ORDER ( { column [ ASC | DESC ] } [ ,... n ] )

clause to the...

Add another temp table to hold the Project & Packages you want to list. Then run the SELECT below.

Btw, you should add a clustering key to the #DateHr table...

Not sure which ClientId column is in Temp_Client, so change if needed:

SELECT [AssigneeID]

FROM [dbo].Assignee

LEFT OUTER JOIN Temp_Client ON Clientid = Client_ID

WHERE @clientid = 'ALL' OR Temp_Client.Clientid IS NOT...

CREATE TRIGGER %%

ON ALL SERVER

WITH EXECUTE AS 'sa'

AFTER

CREATE_TABLE,ALTER_TABLE,DROP_TABLE,CREATE_VIEW, ALTER_VIEW, DROP_VIEW

, CREATE_FUNCTION, ALTER_FUNCTION, DROP_FUNCTION

, CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE

AS

SET ANSI_PADDING ON;

SET ANSI_WARNINGS ON;

SET ARITHABORT ON;

SET CONCAT_NULL_YIELDS_NULL ON;

SET NOCOUNT ON;

SET NUMERIC_ROUNDABORT...

DesNorton (4/6/2016)

Hi Scott

This is certainly fast, with similar I/O to the other solutions, but very low CPU numbers. However, I am unable to wrap my head around the math...

Rather than using a gui, use a SQL RESTORE command to do the restore. Then the new files can be specified using the "WITH" clause.

And here's a function I...

I think you can use the (old) view "sysusers", "WHERE isaliased = 1" to find any aliases.

Another possibility is to leave the main table alone, and create a separate table to hold the partial partids to match on. Use a trigger on the main table...

MS provides tablediff.exe for free. It works ... but it is a command-line tool and, like bcp, takes a bit of time/work to get used to and get it...

No, a stop / start of SQL Server will not cause an identity value to go down. Your code must be resetting it for that to happen.

Yes, creating a non-clustered index on the clus index column(s) can indeed help performance for certain queries. It's a valid thing to do when that situation exists.

You could also consider using an A/B table approach. That is, the nightly load goes into a different table name. When the load process is complete, either the...