Monthly Archives: Gen 2015

SQL Saturday 367 in Italy (Pordenone)

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 […]

SQL Server 2012 SP1 Cumulative Update 14 Released!

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 […]

New release!!! my PowerPivot workbook for investigate the index status

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 […]

CTRL + SHIFT + Q in SSMS

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.    

The most common problems of sql server index with PowerPivot (Release 1.0)

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 2015 book available!

 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!

Switch to our mobile site