Does rebuilding an index make sql queries faster?
Read More →Category: SQL Server
How to change the location of the Default Trace Files?
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 →Why log shipping backups fail in an Always On Availability Group – Resolved
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 →How to be a programmer………
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 →How to Find Which Databases Have Indexes With Page Level Locking Disabled
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 →TSQL – get sizes of unused indexes
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 →Error while enabling windows feature: netfx3. – resolved
Something I have run into a few times now which is an annoying timewaster is the following error: You’ll get it on windows 2012 installations when installing SQL 2012(And probably lower versions) and it’s caused by dotnet 3.5not being enabled on the windows installation. It’s frustrating because it happens during the actual installation and is […]
Read More →