SQL Server Analysis Services References

SQL Server Analysis Services References

Leave a Comment / By Antoine Victor / January 29, 2020 February 10, 2020

Detailed Descriptions of each of the built in Data Mining Algorithmshttps://docs.microsoft.com/en-us/analysis-services/data-mining/data-mining-algorithms-analysis-services-data-mining Creating and Managing SubCubesSubCubes only exist for the duration of a session/connection so use for context not securityhttps://docs.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/building-subcubes-in-mdx-mdx Cube Securityhttps://www.mssqltips.com/sqlservertip/2776/configuring-permissions-for-sql-server-analysis-services/Measure and Dimension Security (14:30) https://www.youtube.com/watch?v=NlNw3wYbh8E

SQL Formatting Trick

Leave a Comment / By Antoine Victor / October 17, 2011 February 13, 2019

I learned a very useful T-SQL script formatting trick today. I often talk about formatting and commenting for the “person from mars” which is usually “you” coming back to look at your code 3 years from now having forgotten everything you ever knew about this project and learned better ways to do everything that was …

SQL Formatting Trick Read More »

What is SQL Server

Leave a Comment / By Antoine Victor / September 27, 2011 May 17, 2018

If you are reading this post you have of course heard the term DataBase… Depending who you are and what you do for a living that term may or may not mean anything to you. If you are a DBA (DataBase Administrator) look away! This post is not for you. lol This post is intended …

What is SQL Server Read More »

SQL Server Bulk Updates and Locking

Leave a Comment / By Antoine Victor / September 15, 2011 May 17, 2018

When doing a large update of a table in a SQL Server database you may gain some performance by locking at the Table level instead of allowing SQL Server to do Page or Row level locking. This can be accomplished using Table Hints. Table hints override the query optimizer default plan for the executed query. …

SQL Server Bulk Updates and Locking Read More »

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

Leave a Comment / By Antoine Victor / September 13, 2011 May 20, 2018

This is an error that you get when you try to view the built-in reports in SQL Server 2008 when the database compatibility is set to anything less than 2005(90). To fix this and make the built-in reports work: Right click on the database Select properties On the options tab change the compatibility level to …

Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Read More »

SQL Server