Blog » Entries from 1/12/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

12

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

  1. Finding Index Scans due to Implicit Conversions

    It is fairly widely known that implicit conversions of data types can cause scans. However, you may not be able to control what goes in your database, you may have inherited an app and we just are not perfect.

    On top of that some can be tricky. For example, did ...

  2. SQL_VARIANT, does this have a place in SQL world?

     
    sql_variant allows to store data of other data types (except text, ntext, image, timestamp and sql_variant) in columns, parameters, variables and return values of user-defined functions.
     
    But is there a place for this data type in SQL Server and I wonder why would anyone needs to use this over a ...

  3. 70-453 Exam coming up…

    http://www.microsoft.com/learning/en/us/Exams/70-453.aspx

    So I’m writing my upgrade exam for my MCITP-DBA (missed cutoff date for the beta on this one) in a couple weeks and haven’t found much of anything in regards to Microsoft approved practice exams so I guess ...

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.