Blog » Entries from 1/24/2009

January

  1. 12
  2. 23
  3. 30
  4. 41
  5. 53
  6. 65
  7. 73
  8. 81
  9. 96
  10. 102
  11. 112
  12. 122
  13. 133
  14. 145
  15. 154
  16. 162
  17. 174
  18. 181
  19. 193
  20. 202
  21. 213
  22. 222
  23. 234
  24. 243
  25. 252
  26. 265
  27. 279
  28. 284
  29. 292
  30. 308
  31. 312

24

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

  1. Creating a 60 GB Index

    Recently, I needed to create an index on a 1.5 billion row table. I’ve created some large indexes before, but this was the largest, so I thought I’d share my experience in case anyone was interested.

    The plan was to create the following index:

    CREATE NONCLUSTERED INDEX ...

  2. All of my SQL RSS Feeds

    To follow Rob Boek’s lead, I have publically shared all of my google reader SQL subscriptions(RSS) in addition to my shared items(RSS).

    Here are the SQL feeds I currently read. Post your RSS link if I am missing out!

Home

Get Syndicated on SQLServerPedia

Have you been blogging for six months or more? Want to see your own posts here on SQLServerPedia too? Follow these easy steps to increase your visibility in the community and attract more visitors to your blog.

  1. Create a Blog Category for Syndicated Posts

    Using your blogging software, create a new category for posts that should be syndicated on SQLServerPedia and add a few posts to it. (This allows you to keep off-topic posts from being syndicated.)

  2. Find the URL to Your Syndicated Posts Feed

    Most major blogging platforms will create a RSS or Atom feed for each category you create. On WordPress blogs, the feed can be accessed by appending /feed/ to the category page URL. On Blogger blogs, the feed for a label is at http://<yourname>.blogspot.com/feeds/posts/default/-/<categoryname>.

  3. Email Us with Your Feed URL, a Picture, and a Bio

    Once you're ready to set up syndication, send us an email introducing yourself. Include the URL to your feed, a headshot of yourself, and a short professional bio.