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

10

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

  1. Using Joins instead of Sub Queries: a Case Study

    During a recent upgrade from SQL 2000 to SQL 2005 some poorly written code was exposed on a custom web application. Users and developers started reporting that their applications were timing out. One of the queries I posted in the Execution Plan Challenge. Another exposed query involved a sub query ...

  2. What Is Your Biggest Weakness

    It has been a while since I have been tagged in a chainpost but Brent Ozar tagged me the other day. As soon as I read the question my first response was “my biggest weakness is responding to these chainposts”. That’s when I realized my biggest weakness is that ...

  3. Using Joins instead of Sub Queries: a Case Study

    During a recent upgrade from SQL 2000 to SQL 2005 some poorly written code was exposed on a custom web application. Users and developers started reporting that their applications were timing out. One of the queries I posted in the Execution Plan Challenge. Another exposed query involved a sub query.

  4. Which Reports Aren't Inherting Permissions?

    Managing security settings in Reporting Services through the Report Manager website is usually pretty easy. However I've found that sometimes things go astray. Today I found a few reports which weren't inheriting permissions from their parent directory. Easy enough to fix, you jump into the security settings for ...

  5. New Bloggers Adam Haines and David Dye

    We’ve got two new syndicated bloggers at SQLServerPedia this week! Adam Haines Adam (Blog) is an MCP Database Administrator/Developer and a proud recipient of the MVP award. He’s been in databases since 2004, first in the banking industry as a database analyst. He transitioned into his current ...

  6. Find Deprecated SQL Code Using Profiler

    I stumbled across something really cool when I was reading through the BOL entry on sp_trace_setevent*, which gives a list of all events and columns available to trace.  This is, by the way, an extremely useful entry to have bookmarked. There are two events I hadn't really noticed before ...

  7. Transaction Log files are not safe to delete

    All to often I see people online saying that they detach a database then delete the log file to shrink it.  This is a very dangerous operation which can leave you with a corrupt database that you can’t do anything with. While you can normally attach a database without ...

Home

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