Does rebuilding an index make sql queries faster?Read More →
I had a situation where a 500 GB drive needed to be repurposed and the…oh 20GB worth of databases on it needed to be moved somewhere else. I found a blog post on sqlconcepts that indicates you can’t change default settings for the default trace. Luckily while that is true of the size or the number of files retained, it is a relatively simple matter to change the location.Read More →
Following on from the Birthday Present I made my daughters, I promised my sister some games for her boys Christmas presents. December turned into a pretty crazy month, but I got the last one finished on Christmas eve.Read More →
Sometimes it bother me how long it takes to throw a single switch which resolves a problem. This was one of those times.
Here’s the scenario. An availability group is set up and you want to log ship one of the databases to a designated DR server so you have both HA and DR at your disposal. Everything sets up just as it should, but when you run the backup no file appears in your backup directory. What’s going on?Read More →
This article was linked to from a recent Brent Ozar PLC newsletter. It contains a bunch of tips about how to be a programmer(Not how to program, but how to be a programmer – the distinction is important). I think it was absolutely brilliant and has huge areas of crossover to other technical roles…such as DBA’s.Read More →
I’ve recently had to look over a client server where a maintenance plan had been failing for some time. The inhouse DBA was unaware of the failures because he had no alerting on the jobs and the big red crosses weren’t big or red enough to have caught his attention. When I looked at the cause of the failures it was due to a native maintenance plan not being able to reogranise an index with page level locking disabled. As the plan stopped on the first failure it hit I needed to find out which other databases on the server this affected so put together these TSQl statements to find out.Read More →
Here’s a TSQL snippet that will give you the sizes of the indexes that the query optimiser isn’t using. Note that the NULL values are SINCE THE LAST RESTART. So if you just restarted your server then this is rather a waste of time.Read More →