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

August

  1. 133
  2. 239
  3. 333
  4. 439
  5. 543
  6. 69
  7. 710
  8. 846
  9. 951
  10. 1050
  11. 1138
  12. 1251
  13. 139
  14. 1421
  15. 1532
  16. 1639
  17. 1757
  18. 1849
  19. 1937
  20. 2010
  21. 2119
  22. 2234
  23. 2333
  24. 2436
  25. 2511
  26. 266
  27. 271
  28. 283
  29. 2948
  30. 3042
  31. 3153

10

  1. 12 A2
  2. 12
  3. 20
  4. 33
  5. 40
  6. 52
  7. 60
  8. 71
  9. 81
  10. 90
  11. 100
  12. 116
  13. 12 P5
  14. 12
  15. 22
  16. 33
  17. 45
  18. 53
  19. 62
Home

  3. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Advanced Aggregates with the Over Clause – Day 11 of 35

    Answer simple quiz at the end of the blog post and - Every day one winner from India will get Joes 2 Pros Volume 2. Every day one winner from United States will get Joes 2 Pros Volume 2. Partitioning with the Over Clause (Part 2) Yesterday we learned how ...

  4. SQL MCM Training – Day 3

    Nothing to say about today, Jonathan did really a great job describing Extended Events and Baselining/Benchmarking to us, and his boss – Paul – did a quick really great overview of Resource Governor. I've done a lot in these areas in the past, so that was a more easy one ...

  5. SQL MCM Training – Day 3

    Nothing to say about today, Jonathan did really a great job describing Extended Events and Baselining/Benchmarking to us, and his boss – Paul – did a quick really great overview of Resource Governor. I've done a lot in these areas in the past, so that was a more easy one ...

  6. SQL Server – Finding currently running queries

    You can use sys.dm_exec_requests DMV to list all requests. This view also contains a hash map of the SQL text – sql_handle, which can be passed to DMF sys.dm_exec_sql_text to get the query text: SELECT      REQUEST.session_id, REQUEST.start_time, QUERY.text FROM        sys.dm_exec_requests REQUEST CROSS APPLY             sys.dm_exec_sql_text ...

  7. T-SQL Tuesday on Wednesday

    This month’s T-SQL Tuesday has been moved to Wednesday.  The topic this month is “crap code”. This is a great topic to showcase what not to do and see some actual bad code.  After all we tend to learn best from our mistakes.  However, I’m not going to ...

  8. SQL Server Login State 16

    The sql server error log, starting with sql 2005 +, began giving us some very descriptive reasons for the login failure. This detailed reason was not always returned to the client for security reasons, but the SQL DBA could look in the error log and get more information on the ...

  9. ACID Properties By Example (And Counterexample) Part Three: Isolation

    ACID Properties By (Counter) Example Part Zero: ACID Properties Part One: Atomic Part Two: Consistent Part Three: Isolation Part Four: Durable So the third ACID property of database transactions is I for Isolation. This is the only ACID property that deals with behaviour of a transaction with respect to other ...

  10. ACID Properties By Example (And Counterexample) Part Three: Isolation

    ACID Properties By (Counter) Example Part Zero: ACID Properties Part One: Atomic Part Two: Consistent Part Three: Isolation Part Four: Durable So the third ACID property of database transactions is I for Isolation. This is the only ACID property that deals with behaviour of a transaction with respect to other ...

Home

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