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

2009

  1. J112
  2. F198
  3. M123
  4. A221
  5. M162
  6. J170
  7. J132
  8. A151
  9. S345
  10. O228
  11. N179
  12. D141

January

  1. 12
  2. 23
  3. 30
  4. 41
  5. 53
  6. 65
  7. 73
  8. 82
  9. 96
  10. 102
  11. 117
  12. 122
  13. 133
  14. 145
  15. 154
  16. 162
  17. 174
  18. 181
  19. 193
  20. 202
  21. 213
  22. 222
  23. 234
  24. 243
  25. 252
  26. 265
  27. 279
  28. 284
  29. 2910
  30. 308
  31. 312
Home

  1. The Death of JOIN

    The core of a relational database is normalization. The reduction of data duplication is what it is all about. Less data means less IO. SDS removes database design from the equation. This is why sparse columns and filtered indexes where implemented in SQL Server 2008. Here are a few posts ...

  2. Shrinking is a popular topic...

    A while back I posted about not touching the shrink button. I am still finding it fun to see what search queries bring traffic to my blog so I look at the search query log every once in awhile. That shrink post is coming up the most in searches which ...

  3. The day Google “died” and I used Live search for an hour

    On Saturday 31st January 2009 at around 14:40 UTC something “historical” happened. Google virtually stopped working. It might as well died. Every single search result was marked with “This site may harm your computer.”. And it redirected you to a warning page. Of course this was probably because of ...

  4. Upcoming PASS Chapter Meetings

    I just added an Upcoming Events tab on BrentOzar.com to list my upcoming sessions at PASS Chapter meetings. February 12 - Columbus SQL Server User Group - Columbus, OH Perfmon and Profiler 101 These two tools are the key to successful performance tuning.  Brent will show how to get started ...

  5. Capt. Varchar(MAX) and the Pagelatch Posse Vol. 18

    The Senior DBA I am astounded by how often I see a problem that I know nothing about but fix it after finding the answer in a search. I get more high fives for being a good search engine user than a good DBA. On the flipside, I learned this ...

  6. SQL Queries That Identify Unused Indexes – Finders Keepers!

    I’ve always found indexing, and performance tuning in general, extremely interesting. Trying to understand how it all works…and works so well…has been a great part of the journey. That whole “Is it an art or is it a science” thing… Well…I think I may have had ...

  7. More SQLServerPedia syndicated bloggers

    We’ve added two more bloggers to our syndicated SQLServerPedia blogroll: Jason Massie of StatisticsIO.com Known as StatisticsIO on Twitter, Jason not only blogs, but produces the Captain Varchar(MAX) and the Pagelatch Posse comic: Great Moments in DBA Interview History - my title for his interview comic. DMV query ...

  8. Links for the Week of 2009-01-30

    SQL Server Set based random numbers George Mastros points out that generating a random number using RAND() in a set-based operation will always return the same value for every row in the result set. What’s a DBA to do? Luckily, George also covers a great way to get around ...

  9. Formula Caching and Query Scope

    The Analysis Services formula engine's ability to cache the results of calculated members can be crucial to the overall performance of your cube, but it's all too easy to turn off this caching. I've blogged already about the impact that subselects have on this and today I ...

  10. Using xp_logininfo to Determine Membership in Active Directory Group

    The preferred method of securing Microsoft SQL Server in the environments I support is via usage of Active Directory Groups.  We do this for numerous reasons, but when it comes right down to it we do so because it removes the Database Administrators from the ad nauseum grind of adding ...

Home

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