SpeedySQL/HealthCheck https://t.co/cMNmm5bmSO

@AaronBertrand Looks like I am losing parallelism in 2014. The query in 2014 CE runs in 37 secs and 2 in 2012 CE.

SQL Server System Views Schema Diagrams:

Got sql error 3283 causing an issue with restore a DB that was encrypted. Had 2 drop DB encryption key prior to backup after encrypt scan

1.8 TB log file....that’s a first

Why is there no 64bit SSMS for 2016? #sql

@AngryPets thanks I will look into this. They are nested to but if I change compatibility to 2012 or 2008 queries run as expected

Checking out SQL Server R Service on SQL 2016 #sqlsatoc #SQLSaturday

@mobileck if I change the compatibility to 2012 or 2008 the queries return as expected.

@speedysql #sqlhelp Arguably, views can promote horribly performing code. Try figuring out which are most exp: https://t.co/wXWzZFy6cx

@speedysql the nested views themselves - NOT the 2014 cardinality estimator. I'd recommend testing to find biggest issues/problems and...

@speedysql I've found a number of nested views performing poorly on 2014 - because of new estimator. Importantly: that's a problem with ...

@SQLHammer thanks Derik

Any data professionals have advice/guidance on possibly switching from a MSSQL DBA to MySQL DBA? Lessons learned? Recommended? #sqlhelp

@SQLHammer company I am working for is slowly phasing out SQL. And yes minimizing their expenses. Position might be open on MySQL

@mobileck plans are a mess but no obvious high costs. Changing compatibility to'12 corrects the issue. hoping for better solution

@speedysql looking at using QUERYTRACEON( 9481) for any queries you can't quickly/easily tune. Details here: https://t.co/uWfVZX16Fe

@speedysql More details here too: https://t.co/guNjsI0MyX To be clear: that's a bit of a hack - but helps til u can tune nested views.

@MidnightDBA Email definitely