By 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 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 reading