Tag Archives for " SQL 2016 "

Jan 12

SQL 2016 SP1 USE HINT

By Lori Brown | Intermediate , Performance Tuning , SQL Development , SQL Server , Trace Flags

–By Lori Brown   @SQLSupahStah After installing Service Pack 1 for SQL 2016, I ran across USE HINT and thought I would put out what I could find to document it. Here’s where you find info from Microsoft: https://msdn.microsoft.com/en-us/library/ms181714.aspx and here is a link for all of the bugs that are fixed in SP1: https://support.microsoft.com/en-us/kb/3182545 USE […]

Continue reading
Dec 09

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
>