CirquedeSQLeil (10/15/2010)

---

GSquared (10/15/2010)

---

Yesterday, whilst commuting, I was actually thinking about setting up a video camera on my dashboard, and blogging the "good parts".

Then I realized it would contain at least...

A server-side trace (that's what it's called) sounds like it'll do what you need. Definitely filter it, and manage the disk space in it.

There's a function, fn_trace_gettable, that will...

That'll make a difference! Glad you worked it out.

Tim Parker (10/15/2010)

---

That hits the nail on the head. I agree with you 100%.

I personally feel that I get discriminated against because of my time in grade as a...

GilaMonster (10/15/2010)

---

That's...

First, a query is a query is a query. SQL Server will store execution plans for queries that use views just as readily as it will store the ones...

homebrew01 (10/14/2010)

---

Sorry, I haven't used OUTPUT so I don't quite follow how that would help. (reading up on it now)

I should clarify, that TableA that data is being selected from...

Break the problem down into component parts.

Try the query without the Group By.

Try the query without the For XML.

And so on.

Pull execution plans in SSMS for each version, including the...

Or do the really simple thing and create a calendar table with all your rules built in, and just select counts from that. It's fast, easy, and gets the...

Then I've seen that behavior before. The computer with Access on it is probably losing its domain credentials for whatever reason. Possibly a network issue, possibly something with...

Yesterday, whilst commuting, I was actually thinking about setting up a video camera on my dashboard, and blogging the "good parts".

Then I realized it would contain at least as much...

Change it to:

OR p.perf_no in (6352,6353)

AND exists

(select 1

from t_sub_lineitem s2

join t_lineitem l2 on s2.li_seq_no=l2.li_seq_no

join t_order o2 on l2.order_no=o2.order_no

join t_perf p2 on l2.perf_no = p2.perf_no

where o2.customer_no = o.customer_no

and...

Honestly, if I really needed to audit what a DBA does, I'd probably set up some sort of 3rd party auditing tool outside the scope of the database/RDBMS. DBAs...

Depending on the pattern of the When...Then statements, you might be able to use some basic string manipulation on it to turn it into an insert statement. But it...

Sounds like a good interview technique. I prefer a hands-on approach to technical interviews over a "can he regurgitate BOL" technique.

And no, I'm not at all surprised about your...