This query could possibly be tuned if you would provide the DDL (CREATE TABLE statement(s)) for the table(s), sample data (as a series of INSERT INTO statements) for the table(s),...

If your database is using either BULK_LOGGED or FULL recovery models, you need to set up transaction log backups to manage the growth of the transaction log. If you...

In your case, you need to remove the commas from the string. I'd also recommend using the date/time style, especially if you know the the dates are all formated...

tosscrosby-60625 (1/15/2010)

---

Gail, you know the answer, give the users the ability to kill the offending SPID! Clean and simple solution to keep things quiet while the OP searches madly for...

What would help is if you would post the table definition(s) (CREATE TABLE statement(s)), some sample data (series of INSERT INTO statements for the table(s)), and the expected results of...

Why and how do you feel that an experienced DBA tried to embarrass you during an interview?

Specific examples would be benifical.

Have to agree, who better to evaluate the skills/knowledge of DBA but an experienced DBA? Would you rather a developer (read that as programmer) do the evaluation, or maybe...

It also depends on wether or not you plan on using the view in other procedures. If so, creating the view would make reuse of the select statment easier.

You say your database isn't using transactions. Are you running INSERT, UPDATE, and DELETE statements in the database? If so, you are using transactions. You may not...

The WHERE clause would filter the result set returned from the JOIN of the two tables. Any filtering done on the transaction table would in effect turn the left...

bwillsie-842793 (1/14/2010)

---

Lynn Pettis (1/14/2010)

---

Now you are talking card punches. Used one in high school as well as in the Air Force. Actually ran a Burroughs B3500 for 4...

Nice catch, Gail. My mind is still on my linked server problem and didn't see that.

select

mbd.Trade_ID,

ISNULL(SUM(t.amount), 0) AS Purch

from

...

SUGAR

Give this a try:

select

t.Buyer,

ISNULL(SUM(t.amount), 0) AS Purch

from

dbo.Member_Base_Data mbd

left outer join dbo.Transactions t

...

bwillsie-842793 (1/14/2010)

---

Oh yeah, you...