Robin35 (11/22/2016)

---

Hello,

We have migrated SQL standard edition from 2008R2 to SQL 2014. After the migration we are seeing huge amount of blocking and overall SQL instance is very slow.

Major wait...

They always come in threes don't they, we have rodiots (road idiots), phoniots (idiots with phones) and now planiots (execution plan idiots)

😎

polytropic2310 (11/22/2016)

---

Eirikur Eiriksson (11/22/2016)

---

The difference is in the cardinality, UAT has less than 1000 rows where PROD has 1.3 million rows, obviously there will be a big difference in the...

adonetok (11/22/2016)

---

In SQL manage studio result panel, right click the result, select "Save results as...", I can save result as csv file.

How to generate SQL statement from there to create...

The difference is in the cardinality, UAT has less than 1000 rows where PROD has 1.3 million rows, obviously there will be a big difference in the logical (and probably...

Quick advice, very carefully assess the output of...

Have you tried adding KEEPNULLS?

😎

Thom A (11/21/2016)

---

What do you mean "The company will not allow it"?

If you're not allowed to export tables contents to a CSV, why are you trying if it's against company...

Quick suggestion, add the column names to the CTE

😎

SELECT BUSINESS_NAME,CONTRACT_CATEGORY,[RX],[PRODUCT]

FROM (

SELECT

BUSINESS_NAME ,

CONTRACT_CATEGORY ,

VALUE,

NAME

FROM PRODUCT_CAT)UP (BUSINESS_NAME,CONTRACT_CATEGORY,[RX],[PRODUCT])

pivot (SUM(VALUE) FOR NAME IN (['RX'],['PRODUCT']))AS S

Ed Wagner (11/21/2016)

---

Isn't that what they say when they put someone in front of a firing...

No, this is incorrect, the code will result in three separate scans, using the variable will only do one scan.

😎

Contrary to what...

Steve Jones - SSC Editor (11/21/2016)

---

Out for a few days, but I'm back.

WRT the PoSh instead of the Command Prompt, I'm not sure there's a big issue here. Most everything...

Either the spid is waiting for the client to consume the data or...

Budd (11/21/2016)

---

Eirikur Eiriksson (11/20/2016)

---

Quick questions, can you use Table Variable Parameter? How wide are the largest values passed? How many values...

marc.corbeel (11/21/2016)

---

I have a stored procedure that updates a few 1000 records in a table.

When I run the SP from within the Studio Manager it takes less than a second...