By Jeffry Schwartz | Expert , Miscellaneous , Performance Tuning , SQL Development , SQL Server
The following testing and resulting data is a direct result of a recent issue that was discovered at one of our client sites. After setting up SQL monitoring that does use a SQL trace to capture long running queries, suddenly certain processes would lock up and be unable to complete. Initially we thought it was […]
Continue readingBy Ginger Daniel | Beginner , Miscellaneous , SQL Administration , SQL Server
–by Ginger Keys AlwaysOn Availability Groups made its debut in SQL Server 2012 as a new feature that enhanced the existing technologies of database mirroring and failover clustering to provide an option for high availability and disaster recovery. AlwaysOn gives you the ability to scale out several secondary Servers (replicas) for high availability or […]
Continue readingBy SQLRx Admin | Beginner , Installation , SQL Administration , SQL Server
I opened my local SSMS today and found my first notification of an update to SQL 2016 Management Studio today. Here is what it looks like: When you click on update it takes you to MSDN to download the update. Apparently this one is a hotfix. Note that you do not have to download the […]
Continue readingBy Lori Brown | Offer , Performance Tuning , SQL Administration , SQL Server , SQLRX
SQLRx (@SQLRX) is proud to announce that two of our resident SQL Experts will be presenting sessions at SQL Saturday #515 in Baton Rouge, LA on August 6, 2016. If you have not signed up to attend, you are going to miss out!! http://www.sqlsaturday.com/515/eventhome.aspx Lori Brown (@SQLSupahStah) will give a lesson on how to be […]
Continue readingBy Ginger Daniel | Beginner , SQL Administration , SQL Server
–by Ginger Keys Recently I had a client who, after speaking with their software vendor, became overly fearful of their database log files growing too big and taking up all of the disk space on their server. The software vendor is apparently used to having clients that don’t have a DBA on staff, and made […]
Continue readingBy Lori Brown | Beginner , Miscellaneous , SQL Administration , SQL Development , SQL Server
— By Lori Brown @SQLSupahStah I was looking for a way to get info on the columns in indexes so that I could use the data to help enhance my index defrag routine. I found that my defrag logic did not figure out if an index has included columns that are LOBs and was failing […]
Continue readingBy Lori Brown | Intermediate , SQL Administration , SQL Development , SQL Server
— By Lori Brown @SQLSupahStah A temporal table is a table that holds old versions of rows from a base table. In other words it is a history table. By having temporal tables SQL Server can automatically manage moving old row versions to the temporal table every time a row in the base table is […]
Continue readingBy Lori Brown | Beginner , Performance Tuning , SQL Administration , SQL Development , SQL Server
–By Lori Brown @SQLSupahStah SQL Server 2016 has introduced a couple of new functions that can be very useful and save storage space to boot. COMPRESS and DECOMPRESS offers the benefit of compressing column data thereby saving storage space. COMPRESS uses the GZIP compression algorithm and actually compresses data before it is stored in a […]
Continue readingBy SQLRx Admin | Installation , SQL Administration , SQL Server
Now that SQL Server 2016 has been released (https://blog.sqlrx.com/2016/06/01/sql-server-2016-rtm-available/ ), DBA’s are going to notice that the Management Studio tools are not in the list of options to install. Starting in SQL 2016, SSMS is a separate download and install. You can find the download at: https://msdn.microsoft.com/library/mt238290.aspx The install notes say that it can be […]
Continue reading