If it's a simple data load then SSIS is probably overkill anyway.  The Import/Export Wizard is good for one-off loads (and you can save it as well, but then we're...

In a relational database, you model many-to-many relationships with junction tables, each one with a foreign key relationship to each of the tables it joins.

-- Main...

Yes please, and expected results based on the sample data that you post.  Seriously, though, if it's that urgent, you ought to pay for someone to come in and help...

Depends whether you're interested in how long a single execution of a query takes, or in its total load on the processor over time.  What's worse, the report that takes...

See this.  You'll want to order by total_worker_time.

John

Brilliant.  Sample data and update query as well, please.

Thanks
John

If more than one OrderID is updated at once, your trigger will only capture one of them.  Indeed, I think it would return an error.  Please will you provide table...

Yes, a DENY will always override a GRANT, unless the grantee happens to be a sysadmin or (I think) db_owner.

John

Two options:
(1) Do all DML with stored procedures.  Then you don't need to provide permissions on tables or db_datareader/writer access - only EXECUTE on the stored procedures.
(2) Get...

Yes, although if you have a script to generate your log restore statements that won't be too much of an issue unless you have a fairly large and highly transactional...

Yes, I agree with you, although I will say that if your databases are of a size that allows a full backup every night, then I would go for that...

In my opinion, no, it isn't a good solution.  But the answer for you will depend on why you are considering this and what your environment looks like.  Have you...

My guess is that you have a case-sensitive database or server.  You need to type the name of the DMV in lower case.

John

Yes, and if you want to compare queries before and after, you can look at logical reads as well as elapsed time.

John