here's my best guess for you: in this case,note how i provided a CREATE TABLE and sample data via INSERT INTO?

if you can do the same in future posts, you'll...

I think you will need to update the table against a version of itself featuring row_number().

within the same order of magnitude or so, doesn't have...

yes that is correct; find the underlying tables of those views, and update stats on them;

you could also use something like this to blindly update all stats for all...

thre you go Donnie;

actual rows 3, but the estimated rows is almost a quarter million.

run this for the three tables involved in this query:

UPDATE STATISTICS [dbo].[VW_DirectReports] WITH FULLSCAN ;

UPDATE...

you DID NOT post readily consumable sample data.

your sample headers had five columns, but the data only appears in three.

how is anyone supposed to be able to use that?

i ran...

both the estimated execution plan and the actual execution...

ok, it sounds like a single service broker would work, but that you would call it 100 times, once for each table, for example.

if we can help with the details,...

agreeing with Steve, here; All SELECT queries take out Shared Locks for the period of time it takes to get the data; those shared locks might delay an update/insert/delete, but...

it really depends on what you are doing to give you a solid answer.

service broker calls run asynchronously; (sending mail via sp_send_dbmail is one common example) so you'd need to...

The index you created above would be used if you had a statement like this:

SELECT contactId

FROM campaignContacts

WHERE campaignId ...

EamonSQL (8/1/2013)

---

Thanks for this.

The reason I know is that this is an old app which the vendor isn't supporting anymore.

Sometimes a data issue occurs and we've been told that a...

dzoll (8/1/2013)

---

Here is the message I get when I manually run the SP:

Msg 14624, Level 16, State 1, Procedure sp_send_dbmail, Line 260

At least one of the following parameters must be...

prakashr.r7 (8/1/2013)

---

Hi Lowell,

The Texas A& M is superb. This site has an option of Batch processing. It just made me curious, how many addresses...

Ed Wagner (7/31/2013)

---

Lowell - Thank you! Having address validation is a very good tool to have. I can't tell you how many times we do it and the...