How to check whether file stream is enabled on the SQL Server Instance via T-SQL.

Problem: How to check whether file stream is enabled on the SQL Server Instance via T-SQL. Solution: sys.configurations Under server- wide configuration catalog views, there is a system object view which stores a row for result for server wide configuration option value in system. This kind of helps when you what state each configuration...

Read More

How to force a query to use index hints with in a query to boost the performance.

Problem: How to force a query to use index hints with in a query to boost the performance. Solution: Table Hint , Starting SQL Server 2008 or higher. In some cases, you want to override the SQL server query optimizer plans to choose...

Read More

How to make use of a data mining model.

Problem: How to make use of a data mining model. Solution: Data Mining Model Viewers After the data mining structure, has been created, you can explore the model to look for interesting trends. Because the results of mining models are complex...

Read More

How to create a SSAS data mining structure based on an algorithm model.

Problem: How to create a SSAS data mining structure based on an algorithm model. Solution: Data mining Models After collecting all the data in a SSAS Cube, based on this data we can create a data mining model based on an algorithm...

Read More

How to predict and analyze data using SSAS.

Problem: How to predict and analyze data using SSAS. Solution: Data mining After collecting all the data in a SSAS Cube, based on this data we can create a data mining model based on an algorithm to predict future data. SQL Server Data...

Read More

How to access cube data inside Microsoft excel without connecting to server.

Problem: How to access cube data inside Microsoft excel without connecting to server. Solution: To browse cube data from excel, please go through this article. browse cube from excel In some cases, you might want to hop on a flight...

Read More

How to build SSRS reports from SSAS cube data using MDX.

Problem: How to build SSRS reports from SSAS cube data using MDX. Solution: After building a cube in SSAS, the next thing to do is create reports of the analysis services cube data. SSRS is the Microsoft business intelligence reporting...

Read More