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

December

  1. 15
  2. 26
  3. 313
  4. 43
  5. 52
  6. 60
  7. 78
  8. 87
  9. 95
  10. 107
  11. 115
  12. 122
  13. 130
  14. 146
  15. 157
  16. 165
  17. 175
  18. 188
  19. 192
  20. 201
  21. 214
  22. 226
  23. 233
  24. 243
  25. 252
  26. 261
  27. 271
  28. 286
  29. 295
  30. 306
  31. 317

8

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

  1. Locking & Blocking

    On the gridiron, two opposing teams are contending for one very limited resource, the football. One team has it; the other team wants it. The team that has it, tries very hard to protect it by securing the football and blocking all others from getting to it. The same can ...

  2. Find Out What Your Log Is Waiting For

    Another tidbit from the PASS Summit that I am only now getting around to blogging about… Did you know that your transaction log file is circular in nature? That is, when your log has reached the end of the physical file it will go back to the very beginning and ...

  3. Disk usage monitoring with Data Collector

    Today, I am jumping into Adam Machanic T-SQL Tuesday challenge with the following post. Recently, I created a build request to have a new server to move SQL Server databases. I put together an estimate for the space needed for data, logs and backups and included this information in the ...

  4. SQL Server Date and Time fun from all around

    A few days ago Adam Machanic proposed a great idea about a T-SQL Tuesday. Every Tuesday there would be a topic bloggers all around would post about. Chosen as the first topic was the date and time stuff in SQL Server. Because there’s already all this great content out there ...

  5. Are trivial plans cached?

    It is sometimes said that trivial execution plans are not cached and queries that have such plans are compiled on every execution. So is that true? To effectively answer this question, we must first establish what a trivial plan is. A trivial plan is essentially a plan for a query ...

  6. SQL Server Master Data Services (Nov CTP)

    Last night I configured up SQL Server Master Data Services (MDS) on a test box. It looks good so far. I ran into a few issues with the box/setup that I had to tweak in order to get it working. I had to allow “handlers” and “modules” in the applicationHost ...

  7. T-SQL Tuesday #001 – Dates and Time

    Adam Machanic, who blogs at SQLBlog.com (lots of great sql bloggers over there) started a neat tradition: T-SQL Tuesday. Read his post here to see the rules and information but it’s basically a weekly (2nd Tuesday of each month) blog topic where we can all have a post about the ...

  8. T-SQL Tuesday #1: Date/Time Tricks

    I’m going to try out Adam Machanic’s idea for a blog party. The topic this month are Date/Time tricks. Instead of supplying a trick for Date/Time, I’m going to caution you about the tricks that you use. Let’s take a simple issue. You want ...

  9. Friday the 13th 2009: Cluster of Terror

    This blog entry is participating in the very first T-SQL Tuesday, hosted this month by Adam Machanic. You are invited to visit his blog to join this rollicking blog party and read more blogs participating in this month’s theme: Date/Time Tricks.Approximately 715,298 articles have been written ...

  10. Remix! Optimized: Query by Hour, Day, Week, or Month

    I originally posted this on 11/16/09. I repost here for the joy of TSQL Tuesday, and to add a very important change to the original solution. Here's the accompanying video - same material, different format. The video doesn't include the change, by the way. A solution is ...

Home

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