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

March

  1. 1768
  2. 2742
  3. 3684
  4. 4657
  5. 5322
  6. 6169
  7. 718
  8. 816
  9. 98
  10. 106
  11. 115
  12. 121
  13. 134
  14. 1412
  15. 1513
  16. 1614
  17. 1710
  18. 187
  19. 195
  20. 204
  21. 219
  22. 2215
  23. 239
  24. 2411
  25. 259
  26. 263
  27. 275
  28. 2814
  29. 2914
  30. 3010
  31. 317

22

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

  1. #SQLSat 70 — It was great! Read this if you attended my SSIS session.

    Ugh!  I screwed up.   I’m going to tell you guys about it and beg your forgiveness. What I did:  I gave out some bad info in my session on SSIS in Columbia, SC this past weekend. What I said:  I said that when an SSIS package is executed using ...

  2. DMV/DMF Info Just A Couple Clicks Away

    If you’re not reading Kendra Little’s blog, then you’re really missing out. It’s full of terrific technical information, but it’s her artwork and sense of humor that really make it special.This morning, Kendra wrote a really cool post called Dynamic Management Quickie: Exploring SQL ...

  3. I’m Presenting at SQL Saturday 67

    No, this isn’t a re-run! I’ll be presenting about Refacatoring SQL at SQL Saturday 67 in Chicago this coming Saturday. I’m really excited about this opportunity. I had a blast presenting in Chicago last year and I’m looking forward to doing it again this year. There ...

  4. Cannot open MSI file | Windows cannot access the specified file error

    In order to try out the features of Microsoft SQL Server Database Publishing Wizard as explained in this post, I had downloaded the installer (an .msi file) on my laptop. Since I had the SQL Server running on a Virtual Machine, I copied this installer from my laptop to the ...

  5. Statistics, row estimations and the ascending date column

    SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they do a reasonably good job However there’s one place where the statistics’ auto-update fails often and badly. That’s on the large table with an ascending column where ...

  6. Innovation and Invention: Whose Method Is Best?

    My Favorite Magazine There are a lot of reasons why I love The Economist magazine and pay over $100 per year for a subscription.  First of all, it summarizes all of its news articles, big and small, in the first 4-5 pages of the magazine.  Don’t have time to ...

  7. March Madness – SQL Server System Tables – sysobjects

    Today we will be talking about the sysobjects system table. This system table is scoped at the database level (not the instance level), so take note of that when you are building scripts. You always need to be mindful about the scope of the system tables otherwise it will lead ...

  8. Why Don’t We Have Federated Databases?

    Federated databases are a dream that have not materialized. The SQL/MED extension to the ANSI/ISO SQL specification is a step in the right direction. In addition, both SQL Server and Oracle have proprietary extensions that make it possible to query external data sources. If all of this technology ...

  9. SQL Resource

    By now, I am sure that you are well aware of the Resource Database.  Starting with SQL Server 2005, a new system database was made available – the Resource Database.  In SQL 2005 you could move the Resource Database – but in 2008 and beyond you cannot.  If you plan ...

  10. Why can’t I just use RAID 10 for everything?

    In a perfect work, you would use RAID 10 for everything.  However we don’t work in the perfect world, we have budgets to deal with.  And these budgets mean that we have to make sacrifices at times so we don’t get what we want. RAID 10 is very ...

Home

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