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

June

  1. 14
  2. 25
  3. 310
  4. 48
  5. 59
  6. 62
  7. 70
  8. 82
  9. 99
  10. 103
  11. 1111
  12. 126
  13. 132
  14. 142
  15. 158
  16. 1620
  17. 176
  18. 184
  19. 195
  20. 200
  21. 210
  22. 224
  23. 233
  24. 2420
  25. 251
  26. 269
  27. 273
  28. 280
  29. 296
  30. 308

3

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

  1. Get Your Learn on in June!

    There is, once again, a lot of great content coming out of PASS this month. The best part is: it’s free!. Check out what’s coming up: Introduction to SSIS with Ryan Fonnett Tuesday June 9th 12:00pm EST SSIS is a high performance Microsoft ETL tool that is ...

  2. SQL SERVER – What is Interim Table – Simple Definition of Interim Table

    Sometimes a simple question like “What is interim table?” can initiate a never-ending discussion between developers. I experienced this recently while I was on phone helping my friends working in Los Angeles. In a conference call, one of the developers kept on talking about “first interim table” and “second interim ...

  3. SQLServerPedia --> Do you use it?

    I was going about my own business today when I got an e-mail from Brent Ozar (twitter, blog) who is the editor-in-chief of SQLServerPedia. Apparently a wiki article that was made from my blog posts on shrinking has received the honor of being the first to receive the "Wiki of ...

  4. Update from MSFT: Sort Warnings while updating Statistics

    Quick post on the update from MSFT. I created a connect item to either fix the issue of generating Sort Warnings while updating statistics or add documentation on why it requires a top 100 percent with order by inside a sub-query. Yavor, a senior program manager, identified this as an ...

  5. SQL Server Central Track at Connections

    This year at SQL Connections, there will be a new track, the SQL Server Central track (scroll down). I’ve been honored to be selected to present two different sessions on that track, MUQt or More Unecessary Query tuning (pronounced MUCK) and Scouting Out Execution Plans. I’m on a ...

  6. July PASSMN Meeting Date Changed

    At the last meeting of the PASSMN board, the date for the July meeting was changed from July 21 to July 14.  This was changed because of a conflict with some of the people invited to speak on the Ask the Experts panel. Speaking of which, we are still looking ...

  7. Wiki Article of the Month Winner: Mike Walsh

    As the SQLServerPedia Editor-in-Chief, I talk to a lot of bloggers and writers, and I like to ask about their motivation.  Why do they do it?  Why do they spend their spare time writing?  Some people are doing it to give back to the community, some people are doing it ...

  8. Does Repair_Allow_Data_Loss cause data loss?

    Short answer: Yes. That’s why the option has that name. Long answer: When CheckDB finds corruption it will, as part of the output, include the minimum level of repair that will fix the errors that it found. In SQL 2005 and higher, it will look something like the following ...

  9. SQL Server 2005 Edition Upgrade

    As most of my posts are inspired by stuff I’ve been working on or have worked on recently this is no different. A request came in to upgrade a SQL Server 2005 Standard Edition Instance to a SQL Server 2005 Enterprise Edition Instance.  Funny thing is that I’ve ...

  10. ORDER BY Speed

    I answered a question on SSC with the comment that while an INT would perform better than a DATETIME in an ORDER BY query, assuming each has a viable index, that the difference wouldn’t be all that terribly substantial. Then I realized, maybe that’s not true. So I ...

Home

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