Stevestedman.com Website Review

important to get the log chain in the right order, or it won’t work.  To restore a full backup, then log backups, the chain of logs could be hard to sort out if you have dozens or hundreds of log backups to restore.  Your sure don’t want to be hand coding these. At my SUMMIT 2017 presentation on Backup and Restore I presented a script that will build your restore script for you when you have lots of log files. In case you need it I have included the updated script here. restore script at the time you run your backup, rather than having to build it out at the time you need it. enjoy is the performance tuning work. This usually involves initial contact with a new client who is having performance problems. From then a proposed contract to go and fix the performance issue. Once a contract is in place we dive in to fix the problem. The performance projects are usually 7 to 14 days long with initial results being shown in 24 to 48 hours after the start of the project. It starts out with in in-depth review of a SQL Server with specific focus on a performance issue. We figure out where the problems are, is it an issue with disk speed, is there enough CPU available, enough RAM, are there missing indexes, issues with the plans as*ociated, you get the picture. We check over 80 configuration settings and study the system to figure out why it is slow. The WHY is perhaps the most important question to ask, once we understand WHY, we than then focus on fixing it. Here is what some clients have had to say after working with them on performance related issues. > We were at the point where we were getting 10 unexpected, > inconsistent, errors and lockups. We needed to reboot our service > right away. Steve came in and stopped that on day one. Within the > first couple days, he had a well thought out, well organized > presentation, explaining all of the potential flaws we had in our > settings and setup, and a plan to fix every one of them. On the