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

2011

  1. J22k
  2. F18k
  3. M4k
  4. A228
  5. M245
  6. J883
  7. J1k
  8. A982
  9. S374
  10. O232
  11. N108
  12. D172

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
Home

  1. How to use the WITH MOVE when you don’t know the logical database file names.

    When doing a database restore and you want to move the physical database files from one disk to another, or from one folder to another you need to know the logical file names.  But if you can’t restore the database how do you get these logical file names?  By ...

  2. If you have 12 disks to hold DB Data files and decide to use RAID10, would you create 1 RAID 10 group or 2 RAID 10 groups made of 6 disks each for best read/write performance?

    I would probably make 2 RAID 10 RAID groups one for the data files, and one for the transaction log.  Without knowing what percentage of data access will be read and what will be write I’m just guessing here.  Depending on the load RAID 5 may work just fine ...

  3. They Don’t Always Know Best Part 3

    I've written before about some of the bad SQL programming practices I've discovered in various programs. I've found yet another example that has been causing me grief for a couple of weeks. We've got a scheduled job that runs nightly and does some archiving - moving records ...

  4. Optimizer Timeouts with XQuery

    I was looking at performance of a database and I noticed a few of the plans were very large and timing out in the optimizer. This made me wonder, just how many of them were timing out? This sounds like a job for XQuery! There’s really nothing to it ...

  5. SQLskills has signed up as our next amazing sponsor

    I am so happy to be able to announce that SQLskills has signed up to be a sponsor for our Napa SQL Excursion. SQLskills is the premier SQL Server consulting company, powered by Paul Randal (blog | twitter) and Kimberly … Continue reading →

  6. Sorting Data in Master Data Services

    Overview:  Techniques for sorting data within SQL Server 2008 R2 Master Data Services (MDS).  The examples below use the Chart of Accounts sample model included when you install MDS at:  <drive>:\Program Files\Microsoft SQL Server\Master Data Services\Samples\Packages. Level:  101 Sorting in Explicit Hierarchies One of the ...

  7. Accidentally Dropped the Distribution Database

    Have you made the mistake of dropping your distribution database like this? If so, remember not to do this ever again. Disabling publishing and distribution involves more than just dropping the distribution database. The distribution database in SQL Server requires special attention and dropping it in this fashion can wreak ...

  8. Using Built-in system function – IDENTITY()

    IDENTITY() function can be used to create a new Identity column for a table, You can only use this function in a SELECT statement with INTO clause. Syntax: IDENTITY ( data type, seed, increment ) AS Column Name for example, I have the following table with two columns – Department ...

  9. SQL University Troubleshooting Week: Having a Plan for Every Situation

    Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals may encounter in the course of our day. We will start off by looking at why we need to have a plan for every situation, and then we will ...

Home

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