Pulse » Recent Items from 6/1/2011

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.

June

  1. 19
  2. 217
  3. 310
  4. 41
  5. 512
  6. 615
  7. 718
  8. 827
  9. 942
  10. 1041
  11. 116
  12. 1213
  13. 1350
  14. 1451
  15. 1535
  16. 1643
  17. 1740
  18. 189
  19. 197
  20. 2064
  21. 2143
  22. 2236
  23. 2339
  24. 2441
  25. 2512
  26. 268
  27. 2739
  28. 2853
  29. 2938
  30. 3064

1

  1. 12 A0
  2. 10
  3. 20
  4. 30
  5. 40
  6. 50
  7. 60
  8. 70
  9. 80
  10. 90
  11. 100
  12. 110
  13. 12 P0
  14. 10
  15. 22
  16. 31
  17. 41
  18. 50
  19. 60
Home

  1. Finding an Expression Definition in a Graphic Execution Plan

    Today on Twitter #SqlHelp, someone asked how to find the definition of an expression in a graphic execution plan. I thought I’d pass along my answer in case it helps someone else. Consider a very simple query, which includes a scalar operator, such as a SUM(): SELECT ProductID , TotalQty ...

  2. Finding an Expression Definition in a Graphic Execution Plan

    Today on Twitter #SqlHelp, someone asked how to find the definition of an expression in a graphic execution plan. I thought I’d pass along my answer in case it helps someone else. Consider a very simple query, which includes a scalar operator, such as a SUM(): SELECT ProductID       , TotalQty ...

  3. Analysis Services 2008 R2 Operations Guide published

    Thomas Kejser has just announced the Analysis Services 2008 R2 Operations Guide has just been published, and you can get it here: http://msdn.microsoft.com/en-us/library/hh226085.aspx This is a must-read for anyone working with SSAS.

  4. Using Built-in system functions – @@IDENTITY, SCOPE_IDENTITY()

    @@IDENTITY is a system function that can be used to retrieve last inserted identity value. @@IDENTITY is not limited to scope. for example, I have a Table which contains an identity column as below: – © 2011 – Vishal (http://SqlAndMe.com)   USE [SqlAndMe]   CREATE TABLE [dbo].[Temp](       [IDNum]     INT ...

  5. A Round-up of Round-ups and other Meta Things

    This article is very meta. No, I’m not talking about the friendly Mehta family a few doors down. I’m talking about the prefix Meta. In particular I’ve noticed a few SQL Blog post aggregator sites and I wanted to aggregate the aggregators, review the reviews and round ...

  6. PerformancePoint wish list – change a datasource

    One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid.  There is no way to do this.  Instead you must create a new datasource and build the Analytic Charts/Grids from scratch using the new datasource.  Why would someone want to ...

  7. SQL Server Locking and You!

    Did you know that SQL Server’s locking has a name? It’s called two-phase locking. If we’re really getting specific about it, SQL Server uses what’s called strong strict two-phase locking or SS2PL. We’ll get there in a few minutes, right now we’re going to ...

Home

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