Pulse » Popular Items from 7/16/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.

July

  1. 15
  2. 22
  3. 33
  4. 42
  5. 51
  6. 65
  7. 710
  8. 86
  9. 95
  10. 104
  11. 112
  12. 120
  13. 136
  14. 144
  15. 157
  16. 165
  17. 174
  18. 180
  19. 192
  20. 209
  21. 216
  22. 228
  23. 235
  24. 245
  25. 250
  26. 261
  27. 272
  28. 2810
  29. 294
  30. 303
  31. 316

16

  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. 20
  16. 30
  17. 40
  18. 51
  19. 60
Home

  1. Professional Courtesy Is Not Full of Suck

    K. Brian Kelley recently blogged on SQL Server Central about what may be the worst display of unprofessionalism I’ve seen in my years as a software professional.  Note that I did not say SQL Professional, as I think what he spoke to transends development platforms.  I’ll not detail ...

  2. SQL SERVER – Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database

    There are two different methods of retrieving the list of Primary Keys and Foreign Keys from database. Method 1: INFORMATION_SCHEMA SELECT DISTINCTConstraint_Name AS [Constraint],Table_Schema AS [Schema],Table_Name AS [TableName]FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE GO Method 2: sys.objects SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,SCHEMA_NAME(schema_id) AS SchemaName,OBJECT_NAME(parent_object_id ...

  3. You May Be Interested In The Following Products…

    In my last blog entry, we came up with an inline table-valued function in AdventureWorks (AW) that accepts a ProductID and CustomerID and will return 3 “suggested” ProductID’s. The idea was that a Customer would go to AW’s website and look at a Product, and the 3 suggested ...

  4. How to check when was SQL Server installed with a T-SQL query

    Today on twitter Lori Edwards (@loriedwards) asked how can you check when was SQL Server installed with a T-SQL query. Otherwise this is pretty simple by looking at the creation time of master database (provided you never had to restore it). But i wanted to find a nice way of ...

  5. Office 2010: Excel 2010 – New Buttons on Ribbon for Pivot Tables – Custom Named Sets!

    Just this week I blogged about adding Named Sets in VBA. Well lo and behold, in Excel 2010, there is a button “Fields, Items, & Sets” that lets you define your own Named Sets. Either with MDX or based on rows/columns you have on your pivot table Works pretty slick! ...

Home

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