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

September

  1. 17
  2. 29
  3. 37
  4. 45
  5. 52
  6. 63
  7. 73
  8. 815
  9. 914
  10. 1039
  11. 1112
  12. 123
  13. 134
  14. 1412
  15. 1517
  16. 1610
  17. 1715
  18. 1814
  19. 191
  20. 202
  21. 2112
  22. 2212
  23. 2318
  24. 2412
  25. 2512
  26. 265
  27. 278
  28. 2816
  29. 2924
  30. 3032

24

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

  1. SQL SERVER – Outer Join in Indexed View – Question to Readers

    Today I have question for you. Just a day ago I was reading whitepaper Improving Performance with SQL Server 2008 Indexed Views. Following is question and answer I read in the white paper. Q. Why can’t I use OUTER JOIN in an indexed view? A. Rows can logically disappear ...

  2. Converting a vertical table to horizontal table

    Last week I received a request to convert a vertical table from a vendor application into a horizontal table.  There was one catch, the vertical table included text columns that needed to be pivoted horizontally.  The following was my plan for tackling this request. You must figure out how many ...

  3. What’s the best practice for starting SQL services?

    An incident that occurred to us this morning causes me to rethink how I have SQL services set to start when the server is started or rebooted. Early this morning we had a power failure at one of our data centers. It caused one SQL server to be rebooted and ...

  4. SSMS "Connect to Database Engine" Prompt Behavior When Dragging And Dropping Files

    A minor annoyance of mine for a long time has been how SSMS will sometimes prompt you to connect to a server and sometimes just connect automatically when a file (or files) gets dragged into the window. Thanks to an "aha!" moment with a coworker I've finally figured out ...

  5. Development Cycle and Second Grade English

    My coworker Steve just sent this to our entire team, along with a picture of his adorable 7 year old daughter holding her whiteboard: The below is a true story, and is why we need to follow process. Tonight my 7 year old daughter had an assignment to put her ...

  6. An Ounce of Prevention

    Having worked in some large IT organizations, coming into a small shop can be maddening at times. When a drive goes bad in a server, we call IBM and they overnight us a new drive. A few months ago, I had a drive go bad, and the server was no ...

  7. Good information is easy to find

    Serious technologist and part-time enthusiasts alike know that the Internet is awash in information. Much of the information is good. Some of it is, well, not so good. And unfortunately, some of it is just plain wrong. It can misleading at best and downright damaging at an extreme. Applying what ...

  8. PASS Virtual Chapters

    Back in January we decided that we wanted to change they way people viewed the PASS Special Interest Groups (SIGs). There were a handful of motivations for this; the creation of semi-autonomous websites, aligning the SIGs with PASS Chapters, and reducing the need for any PASS member to ask “What ...

  9. Why is CheckDB rolling back transactions?

    I saw this one on a forum recently and it’s a fun question to look into. When running CheckDB on an in-use database, sometimes messages like the following will appear in the SQL error log 1 transactions rolled back in database ‘Testing’ (8). This is an informational message only. No ...

  10. (nolock)

    A few years ago, I was working on a big project doing some report writing. This particular client had a rule that every report have an underlying stored procedure. That was one of those things that sounds great in theory, but the practical applications are less impressive. Most of the ...

Home

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