Quick question, are the environments identical and with the same settings (maxdop, maxmem etc.)?

Have you tried to run the query on dev with OPTION (RECOMPILE)?

😎

GSquared (4/11/2016)

---

I just ran into this in a query. Can anyone come up with a good explanation for why anyone would do this?

SELECT

ISNULL(MyTable.MyColumn, NULL)...

Are there any tables or views outside the Reporting schema directly or indirectly referenced in the query that's failing? The error message referred to one Stats schema.

😎

Quick questions, which objects in db CmsTestDB schema Stats are used? what are the permissions the user has? Are all references schema qualified? What is the user's default schema...

jalpaparikh (4/11/2016)

---

Hello,

Last week we changed Compatibility Mode (100 to 110) in our SQL Server 2012. After changed compatibility mode , we have noticed that our backup speed is start deceasing...

Have you checked the installation log file? It can be found in "%programfiles%\Microsoft SQL Server\130\Setup Bootstrap\Log\"

😎

Further on this, have you checked the installation log file? It can be found in "%programfiles%\Microsoft SQL Server\130\Setup Bootstrap\Log\"

😎

Is there enough free space on the hard drive? 2014 requires aprox. 6Gb

😎

richarddunnebsc (4/11/2016)

---

I installed installed MSSQL on Windows 10, but in the list of applications and features, Microsoft SQL Server 2014 is listed as unavailable. No idea why? Any...

Very useful reference Luis, thank you!

😎

Further on Lynn's reply, any Partition-Order-Covering (POC) indices on those tables?

😎

Lynn, you should recognise this by now, not the third time this happens.

😎

SQLRNNR (4/5/2016)

---

Grant Fritchey (4/5/2016)

---

SQLRNNR (4/5/2016)

---

Grant Fritchey (4/5/2016)

---

Oh god...

"The delete works...

Sean Lange (4/5/2016)

---

Luis Cazares (4/5/2016)

---

I constantly avoid that person's threads....

Further on John's replay, hardly worth zipping the compressed backups unless one is applying encryption in the process.

😎

7zip works as well as any other compression software.