Pulse » Popular Items from 1/13/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.

January

  1. 1195
  2. 2192
  3. 3477
  4. 4590
  5. 5662
  6. 6764
  7. 7749
  8. 8350
  9. 9296
  10. 101k
  11. 11935
  12. 12886
  13. 13988
  14. 14795
  15. 15314
  16. 16253
  17. 17710
  18. 181k
  19. 193k
  20. 20847
  21. 21692
  22. 22320
  23. 23323
  24. 24830
  25. 25716
  26. 26672
  27. 27772
  28. 28699
  29. 29359
  30. 30300
  31. 31635

13

  1. 12 A19
  2. 130
  3. 218
  4. 37
  5. 413
  6. 526
  7. 618
  8. 713
  9. 827
  10. 918
  11. 1019
  12. 1131
  13. 12 P41
  14. 154
  15. 248
  16. 3100
  17. 474
  18. 566
Home

  1. Removing Time From A Datetime Value

    How much time would a DateTime have if a DateTime had no time? Ok, forgive the bad pun. But the point remains is a valid one. How can we efficiently strip off the time portion of a DateTime value in SQL Server? I’ve seen a several methods proffered on ...

  2. Identity Columns: Are You Nearing The Limits?

    I use identity columns frequently. After all, identity columns make great clustering keys. But it's important when using identity columns to check on the amount of values you have left before you reach the limit of your data type. An identity column has a fixed amount of values it ...

  3. Introducing MagicPASS - Orlando's New PASS Chapter

    After a year of planning I'm proud to announce that South Orlando has a new PASS chapter: MagicPASS! Our first meeting will take place Wednesday, Jan 19th. Details below, and please RSVP if you plan to come so that I have an idea of how much food we need ...

  4. SQL University: Spring 2011

    The new SQL University Logo Welcome back students! We’re very excited to start up a new semester and SQLU is back and better than ever! This semester we’re lucky to have 7 MVP’s and Microsoft Certified Master (MCM) in SQL Server presenting topics. In addition to our ...

  5. xp_sendmail: Procedure expects parameter @user, which was not supplied.

    On one of the Production instances a job which sends the details of blocking sessions was failing. This is the same instance which was rebuilt on Tuesday. On checking the job history, it was found that the job was failing while trying to send the email. Server: Msg 17985, Level ...

  6. Video: Interview – Part 3 Cross-Platform Issues

    Heather Eichman interviews Kevin Kline, the former President of PASS and systems specialist for the SQL Server Business Unit at Quest Software. Posted January 31, 2008.

  7. A Technical Plan for 2011

    The Last Ten Years My career has been particularly interesting. I’ve been very fortunate to work with a variety of different languages, platforms, databases, frameworks, and people. I started off working with Perl on HP-UX. As I started automating more of my job, I added ASP.NET to the ...

  8. What are your opinions on using an iSCSI NAS for SQL Server storage?

    You’ve really got two questions here.  The first is if I like iSCSI for SQL, and the second is if I like NAS for SQL.  NAS doesn’t support iSCSI as iSCSI is a SAN technology. iSCSI is just fine for SQL Server as long as the server and ...

  9. 31 Days of SSIS – Create XML Document (13/31)

    31 Days of SSIS Day thirteen and we are trucking along with the 31 Days of SSIS blog series.  The last couple posts discussed methods that could be used to unpivot (1, 2) data to populate data into an entity-attribute-value (EAV) architecture. Package Requirements Sometimes, though, it isn’t necessary ...

Home

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