The optimizer can and often does (in my experience) introduce a SORT into the query plan on a small table to facilitate a merge join against a larger table.

Anyway...

ScottPletcher (8/31/2016)

---

TheSQLGuru (8/31/2016)

---

ScottPletcher (8/31/2016)

---

TheSQLGuru (8/31/2016)

---

ScottPletcher (8/31/2016)

---

Tarun Jaggi (8/29/2016)

---

Hi All,

I have a table which has million rows and database is set under RCSI. The table has a clustered primary key on...

ScottPletcher (8/31/2016)

---

TheSQLGuru (8/31/2016)

---

ScottPletcher (8/31/2016)

---

Tarun Jaggi (8/29/2016)

---

Hi All,

I have a table which has million rows and database is set under RCSI. The table has a clustered primary key on Column1 and...

Tarun Jaggi (8/30/2016)

---

Thanks Kevin.

Can you please tell me how to have multiple disks in AWS RDS. We are using SSD based storage. AFAIK in RDS we don't provide access to...

ScottPletcher (8/31/2016)

---

Tarun Jaggi (8/29/2016)

---

Hi All,

I have a table which has million rows and database is set under RCSI. The table has a clustered primary key on Column1 and a non-clustered...

Can't you just bulk load or bcp the files directly?

Grant Fritchey (8/29/2016)

---

TheSQLGuru (8/29/2016)

---

Possible causes:

3) Parameter sniffing issue. Crack open the actual execution plan xml and check the parametercompilevalue and see how that compares to the actual execution value for...

IIRC AWS allows you to have multiple "disks" working together to improve IO performance. You can also move to SSD-based storage and also get dedicated IO.

You are just another...

Can you please provide the FULL code involved here, including the trigger you mentioned?

Check for tempdb IO stalls. RCSI will copy data to tempdb. I have seen this multiple times at clients, sometimes to the point where they had to disable the feature...

Possible causes:

1) SQL Server bug, as mentioned by others. VERY unlikely

2) bug in your code. possible issues:

a) you hold a value over from prior execution

b) you insert multiple rows...

Possible causes:

1) Blocking. Use sp_whoisactive to check for this.

2) Review Estimated and Actual rows from the production run. Something is likely causing very low estimates and you are getting index...

You say OPTION (RECOMPILE) doesn't help. Exactly what form of code/parameter sniffing is going on? Given that you are on SQL Server 2008 I wonder if it isn't the old...

search Glenn Berry SQL Server Diagnostic Scripts

Given that this is a free forum, I don't know that you will find anyone that will take the time to set up imports from a 5+MB excel spreadsheet into...