Pulse » Recent Items from 8/17/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.

August

  1. 133
  2. 239
  3. 333
  4. 439
  5. 543
  6. 69
  7. 710
  8. 846
  9. 951
  10. 1050
  11. 1138
  12. 1251
  13. 139
  14. 1421
  15. 1532
  16. 1639
  17. 1757
  18. 1849
  19. 1937
  20. 2010
  21. 2119
  22. 2234
  23. 2333
  24. 2436
  25. 2511
  26. 266
  27. 271
  28. 283
  29. 2948
  30. 3042
  31. 3153

17

  1. 12 A0
  2. 13
  3. 20
  4. 30
  5. 40
  6. 52
  7. 60
  8. 72
  9. 82
  10. 91
  11. 100
  12. 113
  13. 12 P4
  14. 16
  15. 213
  16. 310
  17. 41
  18. 54
  19. 60
Home

  1. An Ode to a Pre-Con– John Welch is Completely Awesome.

    I am honored to be part of the team which is bringing SQL Saturday 89 — Atlanta, GA to the community on September 17th. As an extra special treat, we are also bringing two Pre-Cons on the Friday before the Pre-Con for only $99. Troubleshooting and Performance Tuning with Kevin ...

  2. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Geography Data Type – Calculating Distance Between Two Points on the Earth – Day 18 of 35

    Answer simple quiz at the end of the blog post and - Every day one winner from India will get Joes 2 Pros Volume 3. Every day one winner from United States will get Joes 2 Pros Volume 3. Geography Data Type New to SQL Server 2008 are the spatial ...

  3. short PASS update aka coming out of hibernation

    Its been too long since I updated this place…. I should apologize or make excuses but, I wont waste your time or mine thinking of them This week is a busy week for 2011 Summit planning. Some things need direct community participation and Id like to draw your attention to ...

  4. SQL Server – "Denali" – OVER ( … ROWS / RANGE … )

    ROWS/RANGE allows you to change the frame size within a partition. Valid arguments for ROWS are: UNBOUNDED PRECEDING Starts the window at first row of the partition UNBOUNDED FOLLOWING Ends the window at last row of the partition CURRENT ROW Starts or Ends the window at current row N ...

  5. SQL Server – "Denali" – OVER ( … ROWS / RANGE … )

    ROWS/RANGE allows you to change the frame size within a partition. Valid arguments for ROWS are:   UNBOUNDED PRECEDING Starts the window at first row of the partition UNBOUNDED FOLLOWING Ends the window at last row of the partition CURRENT ROW Starts or Ends the window at current row N ...

  6. RAID server configuration and disk amounts

    Choosing the optimal amount of disks for a RAID server configuration and block sizes can be a challenge. Typical questions from the SAN\Storage guy to the DBA are: “How many disks in a RAID configuration?” “What is the optimal block size?” “What MB\sec  throughput?” etc  Here’s a ...

  7. Adding an Index to Save Space

    Sounds weird right, but that is exactly what has happened with a VLDB I inherited. A third party database that I support contains 23 columns per table and 16 of those columns have a non clustered index. That’s it, that is all there is to the table? Each month ...

  8. Adding an Index to Save Space

    Sounds weird right, but that is exactly what has happened with a VLDB I inherited.  A third party database that I support contains 23 columns per table and 16 of those columns have a non clustered index.  That’s it, that is all there is to the table? Each month ...

  9. PASSMN Presentation – The Creepy DBA

    Last night I spoke at the PASSMN August user group meeting.  The topic was The Creepy DBA and how you can use the tools within SQL Server to be ”more” creepy. If you were there and have opinions on the session, please leave a comment below.  I’m always looking ...

  10. Upcoming SQLSaturday Events in Omaha and Atlanta!

    I’ve had enough time off from traveling after my surgery to finally travel again. First on the circuit , set for August 27th, is Omaha, Nebraska and SQL Saturday #91. As a former Crimson Tide alum, I was stoked about going to the University of Nebraska, our once and future ...

Home

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