There's even a cumulative update 6 now 🙂 I've tried it out and haven't yet seen any ill effects but I'm not using the full gamut of SQL Server...

And, in a really busy environment, your No Lock query could say there's table corruption when there really isn't. I cannot remember the exact cause but it's to do...

Some examples of the data in tables A, B & C would help in the understanding...

You could do something like

select

coalesce(A.TarrifCode, C.TarrifCode) as TarrifCode,

A.Actual_Unit,

C.Est_Unit

from...

You should be fine. However, you could try moving the table to see if it helps? Alternatively, a middle ground could be to create a SYNONYM which may...

One important thing (which is documented in BOL) is that the "WITH" keyword for table and index hints is NOT optional in mode 90. The script generated by Enterprise...

You could still combine them into a single query using a UNION and a where clause that checks for the parameter being null or not null as appropriate.

You'll want to...

There's no "right" answer. It's always "it's depends" 😀

In your system it may make more sense to have a deleted bit flag in your (for example) orders table rather...

Is this homework? 😀

I recommend you look up some sort of SQL Tutorial in Google, or get a "Teach yourself SQL in 24 hours/30 days" style of book. You'd...

select into is a shorthand convenience to both create and populate a table at once without having to explicitly do a CREATE TABLE statement.

It even allows you to, on the...

What are you trying to accomplish? Why does it need the GO statement separator?

If you need the GO statement separator then you could do two exec calls rather than...

It could be done in MS SQL but I'd very strongly recommend you do it in the application. Just return the three datasets (you can even order them if...

I'm not quite sure I follow, but it seems from reading the other comments that you have log shipping set up to keep a warm server ready for reporting... ...

Could you look on your server to see which users have the rights to do so?

There are a few solutions. I would check the execution plan on each of them and pick your favourite.

Both assume that there is a logon always followed by a...

I was going to leave a nice message about what a wonderful article this was and then instead spent a LONG time reading all of the posts! WOW 😀

Anyhow, I...