By Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah One of my clients has a rather large database with multiple filegroups and multiple database files in them. I happened to notice that a specific drive that is occupied by 2 specific files that are supposed to hold indexes is getting utilized at a much higher rate than any of […]
Continue readingBy Lori Brown | Lunch And Learn , SQL Server
Please join SQLRX’s Lori Brown and the SQLRX team at the Microsoft Campus in Irving, Texas this coming Wednesday November 16, 2016 for an informative take on reasons to upgrade to SQL Server 2016. Register Now! There are a lot of really good reasons to upgrade to SQL 2016. Even if you’re still on SQL 2008 […]
Continue readingBy Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
–By Lori Brown @SQLSupahStah The dynamic management view sys.dm_server_registry has been around since SQL 2008 R2 SP1 so it is not new but it’s relatively new to me. Since I have a ton of SQL Servers to monitor, it is always good to have some way of easily knowing if there are any start up […]
Continue readingBy Lori Brown | Expert , SQL Administration , SQL Maintenance , SQL Server
— by Lori Brown @SQLSupahStah Recently, I was checking on some of the servers that I manage and found that one had an 8GB msdb database. While that is not too bad it is kind of large so I figured that there must be something that needed to be cleaned up. I ran the Disk […]
Continue readingBy Ginger Daniel | Intermediate , SQL Administration , SQL Maintenance , SQL Server
— by Ginger Keys SQL Server AlwaysOn provides a fairly robust environment for disaster recovery; however you can never be too careful when it comes to technology and protecting your data. Regular maintenance routines (i.e. backups, etc.) need to be set up and performed on an ongoing basis, even when you have your databases in […]
Continue readingBy Lori Brown | Intermediate , SQL Administration , SQL Server , Trace Flags
— by Lori Brown @SQLSupahStah Once again, I find things about SQL Server that I had no idea were even available when I actually have time to do some in-depth reading and research. Most of the time, my regular duties keep me so busy that I don’t have time to play with new SQL functionality […]
Continue readingBy Lori Brown | Expert , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah Statistics are pretty important to SQL Server. Statistics are small objects that hold information of the distribution of data in a table. The SQL optimizer uses this information to create efficient ways to get data from the table. So, if statistics are not taken care of SQL may have a […]
Continue readingBy Lori Brown | Expert , Log Shipping , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah I have a few clients who have set up SQL instances to hold copies of databases from either vendors or other companies with whom they are actively sharing data with. In these cases, since the source databases are on servers that are part of another company’s domain, the best way […]
Continue readingBy Lori Brown | Beginner , Helpful Scripts , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah Periodically, all DBA’s are going to run into code that fails due to a deadlock. Deadlocks happen when two or more SPIDs\sessions try to access a resource that is locked by each other. In short, something has to give so one is usually chosen by SQL to be the victim […]
Continue reading