Pulse » Recent Items from 5/2012

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.

2012

  1. J199
  2. F165
  3. M182
  4. A154
  5. M120
  6. J188
  7. J223
  8. A165
  9. S114
  10. O173
  11. N158
  12. D107

May

  1. 17
  2. 210
  3. 36
  4. 42
  5. 52
  6. 63
  7. 71
  8. 89
  9. 92
  10. 106
  11. 113
  12. 121
  13. 131
  14. 148
  15. 157
  16. 164
  17. 175
  18. 183
  19. 193
  20. 204
  21. 215
  22. 225
  23. 232
  24. 241
  25. 254
  26. 261
  27. 271
  28. 282
  29. 291
  30. 307
  31. 314
Home

  1. ALTER TRACE and developers

    Question: SQL Server Profile Trace ,during debugging and developing new applications is invaluable – I currently have a bug I’m analysing where I need to know exactly what SQL statement is executed but without the SQL profile analyser trace functionality I’m at a bit of a loss unless you ...

  2. Oracle Date issues with PowerPivot

    This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the below error when trying to import: OLE DB or ODBC error: Accessor is not a parameter accessor.. Out of line object Datasource referring to id …. Out of line object ...

  3. SQL Server – DDL vs. DML Triggers

    Although, DML and DDL triggers are used for different purposes, there are some similarities and differences between these. Similarities between DDL and DML triggers: 1. Both are created using similar T-SQL syntax 2. Both can run .NET code 3. You can create multiple DDL and/or DML triggers on an ...

  4. Who Can Get The DBA Fired Report

    So there you are, sitting at your desk, idly clicking in SSMS, admiring your little kingdom of SQL Servers. Everything looks good. Jobs are running correctly. No performance problems to be seen. Everything is humming along smoothly. It's tempting to relax a little and perhaps take some time to ...

  5. Predict ALTER INDEX REORGANIZE finish time

    Question: I’ve issued a ALTER INDEX REORGANIZE command on a CLUSTERED INDEX of approximately 300 million rows. How can I estimate the completion time? Answer: Using the SQL Server DMV sys.dm_exec_requests , assists in estimating the finish time. The percent_complete and estimated_completion columns are useful. I’ve included a ...

  6. New built-in functions in SQL Server 2012

    Introduction: Microsoft SQL Server 2012 Release Candidate 0 introduces 14 new built-in functions. These functions will make the migration path for information workers by equalling functionality that is found in the expression languages. In this article I will be covering common usage of these functions because they are very useful ...

  7. One Hour Server

    When I presented by 1 Hour Server session at SQL Saturday 142 in Waltham last weekend, one of the things I stressed to my audience is that this is insanely easy and that anybody can do this. New Server in an Hour View more presentations from Mike Hillwig There are ...

  8. SQL Server – Cannot resolve collation conflict

    A friend of mine contacted me through email today having a very common problem with a query he had written. He received an error, “cannot resolve collation conflict for equal to operator”. Early in my career I had experienced the same issue so I quickly searched my code snippets and ...

  9. SSD- What’s the difference between SLC and MLC?

    It’s time dissect the two main types of flash chips in order to understand why not all SSDs are created equal. What is after all the physical difference between SLC and MLC? SLC stands for Single Level Cell and just like the name suggests can store one bit per ...

  10. VMware 4.1 HA And DRS Deepdive – Free Kindle Edition

    For two days Duncan Epping (blog) and Frank Denneman (blog) are giving away the kindle edition of their book, VMware 4.1 HA and DRS Deepdive for free. Yes that’s right THE bible for VMware admins is free for two days! Head on over to Amazon to get your ...

Home

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