At the start of Daylight Saving Time (DST), which is this weekend in the UK, the clocks will move forward by one hour at 1am. Apart from the fact that we all lose an hour of our night’s sleep, what effect will this have on your scheduled jobs in SQL Server?
Many countries follow the standard of Daylight Saving Time (DST), where twice each year, the clocks will move either forward or backwards by one hour to maximise the evening daylight in the spring, summer, and autumn months. For countries that follow this, there is a specific side-effect of this..
When you discover a poor, uncared for SQL Server instance that has been neglected for years, your immediate response is to get maintenance going and give it some love. Get it back to its former glory and running optimally.
But you need to approach this with caution.
On a new installation of a SQL Server instance, by default, SQL Agent will automatically manage the job history retention, however this may not work the way you expect it to. This post explains why, and how you should set this up for best results.
When DBAs are troubleshooting issues, solutions are sometimes applied in the heat of a critical incident which solve the problem, which are then walked away from because the issue has been “fixed”. With experience and a better understanding of the broader issue of long-term solutions, you realise..
When you have a database which has just been created and is in the FULL recovery model, or you have an existing database you are changing from SIMPLE to FULL, you need to take a full backup before you are able to take log backups, as there needs to be a starting point for the log chain. There is a..
The TempDB database is special in many ways, but an interesting aspect is that when its files automatically grow when they become full, this growth is not persisted and will be undone on the next restart of the SQL Server service. We can see how this works by looking at two system tables:..