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

July

  1. 15
  2. 22
  3. 33
  4. 42
  5. 51
  6. 65
  7. 710
  8. 86
  9. 95
  10. 104
  11. 112
  12. 120
  13. 136
  14. 144
  15. 157
  16. 165
  17. 174
  18. 180
  19. 192
  20. 209
  21. 216
  22. 228
  23. 235
  24. 245
  25. 250
  26. 261
  27. 272
  28. 2810
  29. 294
  30. 303
  31. 316

8

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

  1. Object Naming Standards

    Having a look through the new features of SQL2008, I was intrigued to find the new Declarative Management Framework. In short, it's a way to enforce various policies on your environments. Without going too far into it (in this post), it made me think about what kinds of policies ...

  2. Quick Tip: TempDB on a multi-core SQL Server box

    Just learned this today from one of the Microsoft support reps reviewing our SQL Server 2008 box for performance optimizations: if you are running SQL Server on a multi-core box, you should set up tempdb to have as many data files as there are physical CPU’s (up to a ...

  3. It's the Natural Order of Things... NOT!

    In moving from the Visual FoxPro (VFP) world to the SQL Server world, the biggest thing that I had to un-learn was the concept of a “natural order” of a table. In VFP, when you add rows to a table, they ALWAYS get appended to the end of the table ...

  4. MidnightDBA on Twitter

    For you Twitter "twits": tune into IT tweeting, too.  Follow us at http://www.twitter.com/MidnightDBA  We swear, we won't talk about what we're listening to on the radio 10x a day. You're welcome.

  5. SQL Bacon Nugget of Excellence Award @SQLAgentMan

    So this is not going to be a daily, weekly, or monthly thing but every now and then I come across something that just deserves to get a *BUMP* back to the top of the RSS feeds out there.  If you’re wondering how the whole “bacon nugget of excellence ...

  6. 5 Common Mistakes with Tempdb

    One of the things I get to do pretty often is to visit with clients and discuss how they’ve implemented their SQL Server environment.  And if the title of this post is any indication of the contents there are a number of issues that I tend to be able ...

  7. Counting Children with CTEs

    Have you ever wanted to get a running total of all of the descendants of each tree node? This sort of thing is useful, especially if you don’t want to pull back an entire object graph just to compute the count of a child collection. IF OBJECT_ID('tempdb..#categories ...

  8. Heigh-Ho! Heigh-Ho! With NTILE We Will Go!

    It's not commonly known that the Seven Dwarfs use SQL Server to keep track of the precious gems that they find in the mine. They catalog and record each stone, and, believe it or not, they have a "Finders Keepers" policy. Whoever uncovers a gem with his pickaxe gets ...

Home

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