Tag Archives for " SQL 2016 "

Consistency Check an Analysis Services Database

By Lori Brown | Analysis Services , SQL Administration , SQL Server , Upgrade

— By Lori Brown @SQLSupahStah I am migrating a client to SQL 2016 and had to restore the SSAS databases and do what amounts to a DBCC CHECKDB against it. The command is done while connected to SSAS in Management Studio. You open an XMLA query (not MDX)… …and run the following: <DBCC xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine“> <Object> […]

Continue reading

Upcoming SQLRX Lunch and Learn

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

AlwaysOn 2016 – Maintenance

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

SQL Trace Flag 4199

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

SQL Server Statistics and Trace Flag 2371

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

AlwaysOn 2016 – New and Improved

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

My First SQL 2016 Management Studio Update

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 reading

List Index Columns

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

SQL 2016 Temporal Tables

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