I am posting here my questions again.. Thanks!

This is a 4 processor, NUMA based server, running both OLAP and OLTP databases (but no high volume transaction databases). I changed the...

Okay, sorry for the mixup. I used this query from Jonathan Kehayias' 'A Performance Troubleshooting Methodology for SQL Server': http://www.simple-talk.com/sql/performance/a-performance-troubleshooting-methodology-for-sql-server/

query:

SELECT TOP 10

...

I just thought the previous post was more about index tuning (initially), and now my problem has turned into a performance tuning issue, that's why I posted it separately. Less...

I was reading this post by Dave Pinal:

http://blog.sqlauthority.com/2011/02/06/sql-server-cxpacket-parallelism-usual-solution-wait-type-day-6-of-28/

But, if you read Jonathan's post, it depends on the hardware, if it's NUMA based or not. The query:

SELECT DISTINCT memory_node_id...

That's what I read - Microsoft recommends MaxDOP set to 2 for servers with 4-8 procs (ours has 4). The Cost Threshold set to 25 allows longer running queries only...

Update: I noticed I had another sp doing the exact same thing, running for 1 minute or up to 4 - 5 hours. While re-running the query one morning, the...

After adding/ modifying the indexes, changing the isNull to an Update, it ran for a record 5.8 hours last night. The changes seemed to have shaved off afew seconds when...

Yes, there is a massive row count difference between tableA and tableB. I don't know how to check on what it's waiting for, but I will try to figure out...

Maybe I'm not getting this, but tableB does not get updated.

The big question mark continues to be, with or without more indexes, how come the sp runs anywhere between...

thanks!

tableA:

[Other_Flag_50] [bit] NULL,

[lnhist_acct_nbr] [decimal](12, 0) NULL,

[lnhist_appl_code] [char](2) NULL,

tableB:

[acct_nbr] [decimal](12, 0) NULL,

[appl_code] [char](2) NULL,

[other_flag_50] [bit] NULL,

(the DDL should and is the same in both tables, they are both containing Loan data)....

Thanks for your reply. I need to talk to someone who understands the business logic, because I don't (just started here, a couple months ago). I will try out your...

Sorry for posting like that, I was only looking for some advice, direction, not a 100% solution. Both tables, A and B, have hundreds of columns. I cannot provide sample...

Thanks!!

Guys,

I thought the report was running, while it was actually just hung. I'm still having the same problem, I can run it from BIDS but not when scheduled under...