Pulse » Popular Items from 6/2012

Welcome!

Pulse has a simple goal: to give you a quick view of what's happening in the SQL Server community.

  • Browse

    Finding interesting content on Pulse is easy – you can drill down to a specific time period (by clicking on the bars of the chart), toggle different types of content on and off, and sort the results by popularity or recency.

  • Vote

    Discovered an informative blog post or a hilarious tweet? Tell the rest of the community about it by voting it up or down. Behind the scenes, our popularity algorithm will make sure it rises to the top of the list.

  • Comment

    When a simple up-or-down vote isn't enough, voice your opinions in a comment. Or check out what others are saying about something you posted or tweeted.

2012

  1. J199
  2. F165
  3. M182
  4. A154
  5. M120
  6. J188
  7. J223
  8. A165
  9. S114
  10. O173
  11. N158
  12. D107

June

  1. 16
  2. 23
  3. 31
  4. 410
  5. 52
  6. 66
  7. 75
  8. 85
  9. 94
  10. 104
  11. 117
  12. 128
  13. 135
  14. 143
  15. 155
  16. 163
  17. 176
  18. 1811
  19. 195
  20. 206
  21. 213
  22. 224
  23. 232
  24. 243
  25. 2510
  26. 264
  27. 278
  28. 283
  29. 2945
  30. 301
Home

  1. The Side Effect of NOLOCK

    Have you ever been told that you should use NOLOCK? I have, and its usually been with OLTP systems where the person making the recommendation wants to “improve” the performance of the data platform by reducing and removing, the locks that are held for SELECT queries. Those that know better ...

  2. MSTechEd Follow Up References on Data Visualisation and Business Intelligence

    Here are some follow-up references from my MSTechEd session this week: BIWisdomEvery Friday at 1pm EST - that's 6pm for us here in the UK - Howard Dresner ( blog | twitter ) and the BIWisdom team use Twitter in order to chair a discussion on business intelligence topics.If you ...

  3. Determine Index Fragmentation in a SQL Server Database

    Index fragmentation can adversely affect query response time. When accessing data through an index, SQL Server must read each page in the specified range to retrieve the indexed values. If the index is highly fragmented, SQL Server may have to search many more pages, and possibly levels, to get this ...

  4. Rebuild indexes based on fragmentation – sp_RebuildIndex

    In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server databases indexes using dynamic management view function sys.dm_db_index_physical_stats. In this post, I’m sharing my stored procedure which I’ve created a while ago to rebuild fragmented indexes based on the fragmentation level ...

  5. PowerView and PowerPoint Interaction is not available offline

    During my session at TechEd Europe, I was asked if Power View would still be interactive in PowerPoint, if the PowerPoint couldn't connect to the Sharepoint source.Unfortunately, this is not possible. We can look at the code inside the PowerPoint file by right-clicking on the Power View image ...

  6. Installing sql server 2012 step by step BI edition

    In blog post is just my experience of installing SQL Server 2012 BI edition.

  7. MDX Order by Date

    In this blog post I add additional example how to use MDX Order function this time it uses Date which is frequently used with MDX queries.

  8. SQL Server INTERSECT operator

    The question is: Return customers that bought something in both December 2007 and December 2006? In our case we deciced to use the simpliest method which is INTERSECT operator using SQL Server 2012.

  9. MDX Order

    In this blog post I explain how to use MDX Order function (SSAS/Cubes) and give several simple examples.

  10. SQL GROUP BY Clause

    When you analyze data you often want to group values together and in this step by step tutorial we show you how you can do that and show several examples.

Home

Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.