If you REALLY want to force the order, put

OPTION (FORCE ORDER)

at the end of your query. See:

http://msdn.microsoft.com/en-us/library/ms181714.aspx

Dave.

You need to grant (at least) read access to the shared drive to the user account the sql server instance is running under (default is Network Service), otherwise it won't...

ashish.kuriyal (8/17/2010)

---

Never love your company because you never know when the company will stop loving you.

Thats what I follow.

Being in one job for years is always no no for me....

You looking for a new job then Steve 🙂

Don't worry about it... chill!

Anyone here think QoD questions and answers should be checked independently before they are released?

... and so the majority of respondents have decided - no more 'typo' questions please.

Auditing is normally performed in triggers

1)...

A very good article to show how context_info works and how it can be applied.

If the 128 bytes of context_info is insufficient for the purpose, a CLR could be...

Absolutely right - my bad. I'm afraid my brain is wired to never ever use '=' or '<>' where either side can be null, even if I'm trying to make...

Another advantage of "create/alter" over "drop/create" is that the latter leaves the database without the object for a (usually short) amount of time.

Jim Russell-390299 (4/27/2010)

---

On the other hand...

One of the rules of extreme programming was "do the simplest thing that could possibly work."

There is some danger in adding code complexity to anticipate...

Exactly. Have to draw the line somewhere tho - you could build the house with extra strong foundations just in case you need to put an extra storey on top....

Absolutely. Flexibility comes at a price though, but in my view it's well worth it in the long term.

Very true. It's worth pointing out the proportion of time spent on meetings from time to time.

Anyone else here find themselves keeping the meeting on track, identifying milestones, tracking...