No cooler? No sparkling water?? No bubbly wine??? No waiter???? No sommelier?????

😎

Hugo Kornelis (11/24/2016)

---

polytropic2310 (11/23/2016)

---

Hello Hugo,

Hugo Kornelis (11/23/2016)

---

Well, I can tell with 100% certainty that there are at least two differences:

1. The statistics on the data in UAT are different from...

Gazareth (11/24/2016)

---

BWFC (11/24/2016)

---

ThomasRushton (11/24/2016)

---

BLOB EATER (11/24/2016)

---

GilaMonster (11/24/2016)

---

The office kitchen also caters to stranger tastes, with 3 types of tea (two black tea...

And what value are you passing for the @shift variable?

😎

Nomvula (11/24/2016)

---

hi

I've created this query for my ssrs report but i''m getting the error:

Invalid length parameter passed to the LEFT or SUBSTRING function

I want to be able to select multiple...

Can you post the DDL for the table DataXYZ.dbo.DataXYZ_GeoLoc_Input?

😎

The main problem is the data conversion method used in the views.

, CAST('' AS xml ).value('sql:column("x") cast as xs:decimal ?', 'decimal(24,12)')...

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

---

robert.sterbal 56890 (11/23/2016)

---

What is on your menu for Thanksgiving?

Can you share any recipes?

Our family will be having Thanksgiving at my wife's parents with turkey, gravy,...

sgmunson (11/23/2016)

---

Just curious if there's any chance that the clock on the problem server is not within a minute or two of the SQL Server clock. If there's...

polytropic2310 (11/22/2016)

---

Hello,

What parameters can have an impact on "number of logical reads" ?

UAT and PROD environments are supposed to be the same but "number of logical reads" is huge for...

Hugo Kornelis (11/22/2016)

---

Hmmm, that is a very...

Are your drivers up do date?

😎

Jeff Moden (11/20/2016)

---

Eirikur Eiriksson (11/20/2016)

---

I'm strictly for the full most practical normalisation with one exception, carrying forward a very carefully selected keys such as Invoice-->InvoiceLine-->InvoiceLineDetail(InvoiceID) where, at the cost of...

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...