(Jack Vamvas) Question: I’d like to execute a batch sql statement through SQL Server management studio multiple times and avoid using a loop statement or other similar constructs .
Tag: sql server
(Mohammed Moinudheen) We have a requirement to failover the primary SQL Server log shipping database to the secondary server and setup log shipping in the reverse direction. After the change, the SQL Server log shipping status report is showing failures.
(blobeater) An amazing blog post by Microsoft describing the idea of hot patching the database engine in Azure SQL Database to allow for minimal downtime when applying patches to SQL Server.
(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.