THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 18 (177 total posts) < 1 second(s)
  • re: GUID, fragmentation and performance: the eternal flame.

    @Thomas: the result set was always an empty set...for a very simple SELECT statement as the one used in the test, it should be the same of discarding results (in term of performance), isn't it? @Greg you're right. I'll do the test you both suggest as soon as I can work again on the test machine.
    Posted to Davide Mauri (Weblog) by Davide Mauri on April 7, 2014
  • GUID, fragmentation and performance: the eternal flame.

    In the last months a lot of discussion has been done around the topic of GUIDs and their usage as Clustered Keys. We had a very hot discussion on that several years in Italy, and looking on the web you can see that this kind of question surface gain periodically. Recently I discussed it also with my friend Thomas. Discussion that gave me some ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on April 6, 2014
  • Data Warehouse Advanced Modeling Techniques

    Im yet again pleased to announce that on the next month (19th February 2014) Ill deliver the Advanced version of our Data Warehouse Workshop with my friend Thomas Kejser. The venue will be Stockholm again (really a lovely city) but this time well be at the World Trade Center Klarabergsviadukten 70 107 24 Stockholm, Sweden This is ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on January 20, 2014
  • PowerQuery, ExpandTableColumn and the parent data

    Ive been playing with PowerQuery in the last days and Ive come across the need of accessing parent object data when using the ExpandTableColumn function. The solution is more tricky then one could imagine and I have to say a BIG THANK YOU to Miguel Llopis for showing it me. Now, lets say you have a bunch of files in a directory. All files ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on December 4, 2013
  • re: SQL Rally Nordic & Amsterdam slides & demos

    @Alejandra: sent :)
    Posted to Davide Mauri (Weblog) by Davide Mauri on November 13, 2013
  • SQL Rally Nordic & Amsterdam slides & demos

    Last week I had the pleasure to speak at two GREAT conferences (as you can see from the wordcloud Ive posted, here for Stockholm and here for Amsterdam. I used two different filtering techniques to produce the wordcloud, thats why they look different. Im playing a lot with R in these daysso I like to experiment different stuff). The workshop ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on November 11, 2013
  • SQL Rally Pre-Con: Data Warehouse Modeling – Making the Right Choices

    As you may have already learned from my old post or Adams or Kalens posts, there will be two SQL Rally in North Europe. In the Stockholm SQL Rally, with my friend Thomas Kejser, Ill be delivering a pre-con on Data Warehouse Modeling: Data warehouses play a central role in any BI solution. It's the back end upon which everything in years to ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on October 9, 2013
  • When To Break Down Complex Queries

    &#160; Some days ago my SolidQ colleague Luca&#160; pointed me to the followin SQLCAT article When To Break Down Complex Queries that, as part of the reorganization of SQL CAt website, has emerged again from the depth of Internet. The article is very ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on September 19, 2013
  • Conferences in the next months

    Next months look full of interesting conferences and Ill be speaking in several of those. Ill be speaking at the following ones: SQL DAYS 17 18 September 2013, Germany SQL Saturday 260 Milano 8 October 2013, Italy SQL PASS Nordic 4 6 November 2013, ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on August 29, 2013
  • SQL Saturday 260 in Milan with Fabian Pascal

    Im really happy to be able to announce that were going to have a SQL Saturday in Milano! Were going to have a great list of speaker and exceptional content, as you can see from the list of proposed sessions: we had proposals from Klaus Aschenbrenner, Silvano Coriani and many other high-level ...
    Posted to Davide Mauri (Weblog) by Davide Mauri on August 27, 2013
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement