(Denny Cherry) If you’ve been a DBA for a while, you’ve heard people talking about PLE. PLE stands for Page Life Expectancy; most DBAs (and really anyone that works with SQL Server for more than 5 seconds) called it PLE.

(Pinal Dave) During the recent Comprehensive Database Performance Health Check, I noticed there were lots of aggregation going on with various data in the table. I suggested that the client can experiment with the columnstore indexes and it may help the performance.

(Chris Webb) While the documentation on how to import data from Azure Data Lake Gen2 Storage into Power BI is pretty detailed, the connector (which at the time of writing is in beta) that supports this functionality in the Power Query engine has some useful functionality that isn’t so obvious.

(Dinesh Asanka) Truncating a table is removing all the records in an entire table or a table partition. TRUNCATE table is functionally similar to DELETE table with no WHERE clause.

(Greg Robidoux) SQL Server Agent has a lot of great information stored in the system tables in the msdb database and the GUI provides a nice way of retrieving and viewing the data, but it does not always give you the data the way you would like it displayed.

(Pinal Dave) Today let see a quick question which I was recently asked by a customer of Comprehensive Database Performance Health Check about SQL Agent and Job starting whenever CPU Become Idle.

(Alejandro Cobar) At some point you are probably going to be asked how quickly your SQL Server database is growing. You could try to create a report based on auto growth’s that occurred, but if the data file was initially set large enough no auto growths would be triggered.

(Grant Fritchey) I consider myself to be the most responsible for making such a huge deal about the differences between what is labeled as an Estimated Plan and an Actual Plan.

(Kenneth Fisher) It’s that time again! Alex Yates (b/t) has asked us to discuss a time in tech when we’ve changed our mind. I decided in the end to go with something I’m in the process of changing.

(Pinal Dave) Just another day I got an email from a client who wanted to hire me urgently for their SQL Server Performance issue on the production server.