Pulse » Popular Items from 3/31/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.

March

  1. 11
  2. 24
  3. 34
  4. 45
  5. 55
  6. 65
  7. 71
  8. 81
  9. 93
  10. 108
  11. 114
  12. 125
  13. 133
  14. 142
  15. 150
  16. 164
  17. 173
  18. 181
  19. 197
  20. 207
  21. 213
  22. 223
  23. 234
  24. 247
  25. 255
  26. 265
  27. 271
  28. 288
  29. 292
  30. 305
  31. 317

31

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

  1. SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column

    Some time ago I was helping one of my Junior Developers who presented me with an interesting situation. He had a table with Identity Column. Because of some reasons he was compelled to delete few rows from the table. On inserting new rows in the table he noticed that the ...

  2. Adding Reliability to Your Infrastructure

    I’ll never fly in a single-engine plane.  Never.  Not gonna happen.  Carve that one in stone. Call me chicken, call me scaredy-cat, but I’m not going to get into an airplane that will kill me if an engine fails.  The next step up is a twin-engine plane - but ...

  3. Registered Servers in SSMS

    In my last blog post, I discussed changing the color of the status bar in SSMS 2008. I received a couple of comments and even an e-mail discussing how this doesn’t seem to always work. After playing with it for a little bit, I’ve found that the status ...

  4. SQL Solutions OLAP Heartbeat and OLAP Performance Advisor

    Hmm, you wait for years for commercial tools for monitoring Analysis Services (the only one I’d ever seen before was Companion for Analysis Services from SQLMinds) and then two come out at once. One of these tools I’ll be blogging about towards the end of this week, hopefully ...

  5. Mixed Workloads Part 3

    In part 1, I talk about what I consider feeble attempts at implementing a reporting server through log shipping, mirroring\snapshots and, to a lesser extent, replication. Unless you invest in a real ETL solution, I argued that it is better to run a mixed workload. I talked about the ...

  6. EXISTING AND NONEMPTY

    Here’s an interesting MDX nugget. The other day I was working on something similar to the following query, that finds the count of the number of customers who bought something in the current month as well as the previous month: WITHMEMBER MEASURES.TEST ASCOUNT(NONEMPTY(NONEMPTY(EXISTING ...

Home

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