Pulse » Recent Items from 12/17/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.

December

  1. 15
  2. 26
  3. 313
  4. 43
  5. 52
  6. 60
  7. 78
  8. 87
  9. 95
  10. 107
  11. 115
  12. 122
  13. 130
  14. 146
  15. 157
  16. 165
  17. 175
  18. 188
  19. 192
  20. 201
  21. 214
  22. 226
  23. 233
  24. 243
  25. 252
  26. 261
  27. 271
  28. 286
  29. 295
  30. 306
  31. 317

17

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

  1. Reporting Services Licensing

    Licensing models can sometimes make database modeling seem trivial. Per processor or per seat? Single core, dual-core, multi-core processors? Multiple instances on one server? Virtualizing servers on a single server? It can get very confusing, very quickly. I’m regularly asked by a former students, clients, and people in the Forums ...

  2. Sequels for SQL: Dec 17, 2009

    In the Sequels for SQL series, I point you to sites where you can go beyond the nose-to-the-grindstone resources that we see every day as SQL Server professionals. (My favorite resource for pan-SQL Server pointers is Steve Jone’s Database Weekly email newsletter.) These are the story that comes after and ...

  3. Find Missing SQL Dependencies

    A short post today. I use the following script to find (broken) stored procedures or views that refer to sprocs or tables that no longer exist… or that don’t exist yet. This is a quick sanity check that can help identify broken or obsolete stored procedures. -- 2008 only SELECT ...

  4. Brief Intro to Indexes and INCLUDE

    Content rating: Beginner   This is a companion blog to "Get Index Included Column Info". What are indexes for? We need to talk indexes first, before we get to INCLUDE.  When you index, you're creating a reference that your query can look at to find the WHERE and JOIN terms ...

  5. Get Index Included Column Info

    Content rating: Beginner, tip One of my pet peeves with SQL is that there isn't a quick and easy way to get all the information about indexes. Sure, you have sp_help tablename or sp_helpindex tablename to get the index name and keys for a table, but that's not ...

  6. CXPacket isn’t the cause, it is a symptom

    All to often when people deal with parallel queries they see that some threads of the query have a wait type of CXPacket so they assume that the parallel execution plan is causing a problem, but it probably isn’t. What is causing the problem is the threads which don ...

Home

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