Pulse » Recent Items from 9/25/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.

September

  1. 17
  2. 29
  3. 37
  4. 45
  5. 52
  6. 63
  7. 73
  8. 815
  9. 914
  10. 1039
  11. 1112
  12. 123
  13. 134
  14. 1412
  15. 1517
  16. 1610
  17. 1715
  18. 1814
  19. 191
  20. 202
  21. 2112
  22. 2212
  23. 2318
  24. 2412
  25. 2512
  26. 265
  27. 278
  28. 2816
  29. 2924
  30. 3032

25

  1. 12 A1
  2. 11
  3. 20
  4. 30
  5. 40
  6. 50
  7. 61
  8. 70
  9. 80
  10. 90
  11. 100
  12. 111
  13. 12 P1
  14. 11
  15. 21
  16. 32
  17. 40
  18. 51
  19. 61
Home

  1. Down For The COUNT(*)

    I was playing around with the COUNT() aggregate the other day and found some very interesting behaviors.As you may know, COUNT(*) will count all rows; whereas, COUNT(Expression) will count all rows in which Expression is not NULL.Consider the following 3 queries: select count(*) from northwind.dbo.customers ...

  2. Health Data Rights

    There was a time when health information was merely a collection of facts about you. You visited a doctor on the 17th because of a sore throat.  You had your appendix removed when you were a grade-schooler. Now, in the 21st century, information is increasingly used to drive business value ...

  3. Blog syndication – does it really work for bloggers?

    Ask Colin Stasiuk, aka @BenchmarkIT on Twitter: Part 1 Part 2 That’s great news!  It’s not all due to SQLServerPedia, though – Colin’s been writing great blog posts at his blog, BenchmarkITConsulting.com. You can read more about syndicating your blog at SQLServerPedia.

  4. Coming to PASS Summit 2009: Twitter BINGO!

    So, last year at PASS Summit, I had my first real experience with a heavily-twittered event.  What was interesting was that I met a lot of people in real-life that I had just recently begun following on Twitter; I had made the comment (in passing) to someone that we ...

  5. CHAR: What is it Good For?

    Takeaway: … Absolutely nothing (say it again).What’s the difference between the CHAR datatype and the VARCHAR datatype? At the time of this writing Google gives thousands of web pages that are willing to explain the difference. Or if not explaining the difference at least explaining which is better and ...

  6. Fizzbuzz

    I recall reading Brent Ozar’s post on questions to ask DBAs in an interview. Unable to sleep last night, I was trying to solve the Fizzbuzz problem in my head. I knew it could be done with T-SQL, but I hadn’t given it too much thought. I’m ...

  7. Heard it from a friend who… heard it from a friend who…

    Background music while you read this post Have  I mentioned how much I love the SQL community…. Hey… have you heard that Jonathan Kehayis wrote a blog post about some uses for DBINFO and the dbi_version and dbi_createVersion values? Yeah but did you hear that Paul Randal wrote a blog ...

  8. Testify! (my back, you must pat it)

    To quote Dave Barry, I swear I'm not making this up.  We just got a lovely email from - dare I say it? A fan! Just a note to say "thank you" for creating your midnightdba website, chock full of awesome SSIS videos!  I work heavily with T-SQL programming and ...

  9. Backup Agents: Good, Bad, or Ugly?

    Do you use database backup agents to back up your database or do you write your backups to disk and use a file system backup agent for sending them to long-term storage? I’ve seen this spark religious debates between DBAs and network administrators. As a network administrator, I like ...

  10. Using sysdepends the old fashioned way

    SQL Server gives us a pretty good GUI for most things. Every once in a while, though, it’s pretty rewarding to dig into the system tables to get this information the old fashioned way. I was working on a problem with a stored procedure on a SQL 2000 instance ...

Home

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