By 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 readingBy SQLRx Admin | Advice , Installation , Miscellaneous , SQL Server , Upgrade
In case you live under a rock or were at the dentist, Microsoft announced that SQL Server 2016 has been made generally available today June 1, 2016. See: https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ Pricing is as follows: A handy feature comparison of previous versions of SQL can be located here: https://www.microsoft.com/en-us/server-cloud/products/sql-server/comparison.aspx SQL 2016 feature comparison between editions can be […]
Continue readingBy Jeffry Schwartz | Expert , SQL Development , SQL Server
— by Jeffry Schwartz Some functions in SQL are a little difficult to use and understand. I was recently using the LAG function to shed some light on a performance issue, so I thought I would show how I used it and the results it produced in a way that is easy to understand. At […]
Continue readingBy Ginger Daniel | Intermediate , Perfmon , Performance Tuning , SQL Server , SQLRX
–by Ginger Keys Have you ever watched performance metrics in Performance Monitor (Perfmon) and wondered which SQL Server activities were causing those spikes? SQLRx offers a Microsoft Partner-of-the-Year award-winning service that will correlate all performance metrics on your server with very little overhead, and will pinpoint with precision, right down to a line of code […]
Continue reading