Pulse » Recent Items from 5/16/2011

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.

May

  1. 11
  2. 227
  3. 39
  4. 412
  5. 510
  6. 610
  7. 71
  8. 82
  9. 912
  10. 1015
  11. 117
  12. 124
  13. 138
  14. 142
  15. 151
  16. 1612
  17. 1714
  18. 1812
  19. 193
  20. 209
  21. 213
  22. 223
  23. 2311
  24. 2411
  25. 2510
  26. 269
  27. 2710
  28. 282
  29. 291
  30. 306
  31. 318

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. 111
  13. 12 P0
  14. 11
  15. 22
  16. 33
  17. 40
  18. 52
  19. 60
Home

  1. Auto memory management in Cluster

    I was musing into a problem. We currently have our production server in a two node cluster that has 128GB of RAM each. 1st node contains 4 instances of SQL Server running, and the 2nd node contains 1 instance of SQL Server running. These are active/active clusters, meaning that ...

  2. Tracking Database Growth and Trends over Time

    I was looking for a solution where database sizes and growth (and autogrowth) can be tracked over a time period so that I can estimate the size requirements, see when the growth happened, and trace it down to an event, job, or regular operations. Autogrowth can be tracked via querying ...

  3. Alternative to Deprecated System Tables for Finding Text in SQL Server Objects

    Overview:  Usage of an Information Schema view to find text within a SQL Server 2008 R2 stored procedure, function, table, or view. Level:  101 Deprecated System Tables So, you’re used to querying SysObjects, SysColumns, SysComments?  Me too!  Bad news is the System Tables are deprecated & not supported in the ...

  4. What Are You Waiting For?

    I know what I am waiting for. I know exactly what every SQL Server instance in my care is waiting for. Why? Because it’s my job to make SQL Server go faster. Identifying what your SQL Server Instance is waiting on will show you exactly where to look in ...

  5. PASS Summit Sessions–Vote for Me!

    I’m not usually one of those people who blog about the sessions they’ve submitted at conferences, or the feedback they get afterwards (why would you be interested in that?), but since this year PASS are letting prospective attendees vote on which sessions they’d like to appear at ...

  6. #msteched “Juneau” preview

    Sitting in the Database Dev session at Tech Ed, taking a look at “Juneau”, the new development suite for SQL Server. I can’t wait to see if this thing slices and dices data like a Ronco food processor. Again, live blogging, so please excuse the scattered thoughts, poor spelling ...

  7. Can’t Troubleshoot? Don’t Apply!

    If you can’t troubleshoot, you can’t work with me (if I can control it anyway). When I am interviewing you I am judging your troubleshooting skills as much as your SQL Server knowledge – if not more depending on the role. I’ve blogged a bit about troubleshooting (Methodology ...

  8. What topics would you like covered at our first excursion?

    As we want to make sure that our attendees get the most possible out of the classroom part of our excursions, we want to collect feedback from the community as to what would be the most useful topics to cover. … Continue reading →

  9. How to get First and Last day of a month – TSQL

    Following queries can be used to get the first/last days of a month. To get first day of a month use: – © 2011 – Vishal (http://SqlAndMe.com)   – First Day Previous/Current/Next Months SELECT      DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0),             'First Day of Previous Month' UNION ALL SELECT ...

  10. SQLRally wrap-up

    I’ve uploaded my slide deck on AppFabric Cache and SQL Server 2008 as well as my demo-code that I used in my session. Slide Deck Demo Code I had a really great time at SQLRally and hope to be a part of more to come. I’ve got my ...

Home

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