Grumpy DBA (2/26/2016)

---

For some unknown reason a terrible song has been stuck in my head each morning this week... Sheena Easton's Morning Train. It's equivalent to slow, painful torture....

pwalter83 (2/26/2016)

---

Hi,

In the report I have created, there is an option for the user to enter optional free text for searching. The problem is the report displays matching rows for...

Probably the best event you can choose. Lots of sessions going on at the same time, (almost) all from high quality speakers. Covers a broad...

I realize that this is technically not an answer to your question, but that's because I think Service Broker is not the right tool for your problem.

If inserting data into...

Hi Bantrim,

Thanks for posting the simplified table structure - details like that can be invaluable in understanding a problem.

In this case, we may need more details - more on that...

Jeff Moden (2/19/2016)

---

In that same vein, I also won't work for a company that requires you to pass an "intelligence test" or "personality test". They should automatically know that...

In this...

Hi Loner,

I do see that the recompile hint worked. The estimated rowcount for the cnsmr_accnt_ar_log table has gone down to 56,827...

When it's an insert datetime, I think that this guess would be right...

How can you possibly determine that this should be a good clustering key based on seeing only one single query that uses...

And here is another great resource for free learning: http://www.sqlsaturday.com/%5B/url%5D

It's definitely not the best approach.

If you must do this, then use the system tables (sys.tables, sys.columns, etc) to generate CREATE TABLE scripts...

GilaMonster (2/19/2016)

---

The cause is detailed in the error message.

"An explicit value for identity column in table dbo.N8_SPEC_STAT_DELETED can only be specified when a column list is used and IDENTITY_INSERT is...

If the columns required change when the data changes, then you need what is called a "dynamic crosstab". Google for it. Personally, I hate them - they require dynamic SQL...

Thanks for posting the execution plans, table, and query. That makes it a lot easier.

However, I must unfortunately nag you a bit more - the plans you posted are estimated...