Pulse » Recent Items from 9/6/2009

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.

September

  1. 17
  2. 29
  3. 37
  4. 45
  5. 52
  6. 63
  7. 73
  8. 815
  9. 914
  10. 1039
  11. 1112
  12. 123
  13. 134
  14. 1412
  15. 1517
  16. 1610
  17. 1715
  18. 1814
  19. 191
  20. 202
  21. 2112
  22. 2212
  23. 2318
  24. 2412
  25. 2512
  26. 265
  27. 278
  28. 2816
  29. 2924
  30. 3032

6

  1. 12 A0
  2. 11
  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. 20
  16. 30
  17. 40
  18. 52
  19. 60
Home

  1. Output Clause – A Great Alternative To Scope_Identity()

    In SQL Server 2005, a new clause was introduced that allows your query access to the inserted and deleted pseudo tables, without the use of a trigger.  In prior versions of SQL Server, the primary way to get a newly inserted identity value is to either use @@IDENTITY or Scope_Identity ...

  2. Fun With Percentiles, Part 1

    Let’s say you have 100,000 rows in a table that has a Dollars column. If you perform the following… select *, GroupValue=ntile(100) over (order by Dollars) from MyTable … it will split the rows into 100 equal sized subsets (of 1000 rows each) by sorting the rows by ...

Home

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