Pulse » Popular Items from 4/9/2010

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.

April

  1. 1634
  2. 2560
  3. 3185
  4. 4231
  5. 5646
  6. 6385
  7. 7731
  8. 8759
  9. 9740
  10. 10391
  11. 11273
  12. 12791
  13. 13946
  14. 14772
  15. 15923
  16. 16712
  17. 17379
  18. 18393
  19. 19683
  20. 20931
  21. 212k
  22. 221k
  23. 23979
  24. 24613
  25. 25424
  26. 26860
  27. 27684
  28. 28613
  29. 29758
  30. 30693

9

  1. 12 A17
  2. 120
  3. 217
  4. 328
  5. 412
  6. 512
  7. 624
  8. 718
  9. 821
  10. 932
  11. 1017
  12. 1139
  13. 12 P35
  14. 145
  15. 246
  16. 341
  17. 456
  18. 561
  19. 663
Home

  1. SQL 2005 System Stored Procedures Poster

    Just over two years ago I helped put together the following poster that detailed some of the more useful system stored procedures found in SQL 2005: I have a handful of the posters laying around my cubical and my office at home. I suppose I should give them away whenever ...

  2. What We’re Reading This Week

    SQLServerPedia’s new Buzz feature makes it easier for me to find what people are reading. On the Popular page, I can just look at what people are upvoting. Here’s some of the ones readers voted up this week that looked good to me: Database Posts Teaching SQL Server to Play ...

  3. Thoughts on ORM

    I’ve posted before about issues I’m having either with behaviors of nHibernate, or behaviors of teams using nHibernate, but I don’t think I’ve made my thoughts on ORM too clear. Let me do that now.   I think some form of ORM is here to stay. There ...

  4. Convert Any Integer Type to a Hex String

    Here's a user-defined function to take any integer from a TINYINT to a BIGINT and return it as a hex number in a VARCHAR like '0x01033FA2': ----------------------------------------------------------------------------- -- Drop any existing function. ----------------------------------------------------------------------------- IF OBJECT_ID('dbo.Hexadecimal') IS NOT NULL BEGIN RAISERROR('

  5. Deleting User Objects in Master Database

    This script erases everything in the master database that is not Microsoft-shipped. Be careful: some user objects belong in the master database (database triggers, security objects, for example). Backing up the master database first would be a prudent step. -- Drops all user objects that have been accidentally created in ...

  6. (Practically) Fool-Proof Backups

    A script and batch file that practically anyone can run, no matter how non-technical. The batch file prompts you for backup path, server, and instance, and then calls the SQL script. : ----------------------------------------------------------------------------- : Prompts user for info and calls the SQL script to do the backup. : -----------------------------------------------------

  7. Adding a Clustered Index - Carefully

    This script is useful if you need to add a Primary Key / clustered index on a table, but cannot know if the table already has a clustered index on another column, or if the column you're trying to cluster already has a non-clustered index on it. ------------------------------------------------------------------------------- -- Constraint_Add_PK_Clustered.sql ...

Home

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