Monthly Archives: Gen 2015
The scheduling of SQL Saturday Pordenone is online , my session ( in Italian ) will talk about how the xVelocity engine works . Do not miss it! This event will be held February 28 2015 at Consorzio Universitario di Pordenone Via Prasecco, 3/a I-33170 Pordenone, ITALY. Admittance to this event is free, all costs […]
view this link: http://support.microsoft.com/kb/3023636/en-us summary: SQL service35409343023629 FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL Server 2012 Analysis Services38579312840657 FIX: High CPU usage after you use DTExec utility to process SSAS 2012 data mining models Data Quality Services (DQS)38333613023634 FIX: Performance decreases when you stage many records in MDS for SQL […]
I have update a PowerPivot workbook that will allow you to investigate the index status on your server instance . The report contains the new four worksheets respect of the previous workbook index inefficient: indexes are not efficient and should be updated. index unused: are indexes that are never used. index big clustered: get index usage information in SQL Server about size and type […]
Highlight the T-SQL command in the SSMS query window and then “Ctrl + Shift + Q” as shown in the following screen shot. The Query Designer window will pop up. Just copy the new Select statement from the Query Designer window.
I have created a PowerPivot workbook That will allow you to investigate the index status on your server instance . The report contains four worksheets index more used-maintenance: It can also be useful to identify the indexes ( between those used ) more expensive in terms of changes made to the underlying tables . This cost has […]
DAX Patterns is a collection of ready-to-use data models and formulas in DAX, which is the programming language of PowerPivot. Create your Excel data model faster by using a DAX pattern!