THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |

Search

You searched for the word(s):
Showing page 1 of 165 (1,647 total posts) < 1 second(s)
  • re: The SQL Hall of Shame

    @Jason A: Haha, been there a few times ... @DoM: Yes, agreed, some do need it.
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 22, 2017
  • re: The SQL Hall of Shame

    @DoM: Half a million transactions a second is certainly impressive. But how many database instances, worldwide, really need to handle that kind of load? So sure, it's useful, but again, quite limited in its scope at least today. Perhaps IoT and similar will change things over the next few years. But I don't think we're there quite yet. @Svetlana: ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 22, 2017
  • re: The SQL Hall of Shame

    @Dragan: There are certainly lots of opportunities for better scalability with in-memory features. But it's still a somewhat limited area in my opinion. @Kalen: As far as I can tell -- I just did a Google search on both -- they're interchangeable, but &quot;native compilation&quot; is certainly a lot more commonly used. So yeah, that's what I ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 20, 2017
  • re: The SQL Hall of Shame

    @Nick: Interesting, thanks for the feedback on that. @Tibor: Anything cool from those days? I played with 6.5 for all of a week, at the very beginning of my career, so I don't have any solid memories. @Prithiviraj: Good thing no one mentioned RG, since it's quite useful :-) ... Replication? Well I think it has plenty of use cases but needs a ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 20, 2017
  • re: sp_whoisactive: The Big Fixes!

    @Krish I assume you're seeing request_id &gt; 0 for those? I'm guessing you have MARS enabled on the connection string, which should not be necessary for EF (and probably not necessary for much else -- it's a feature used by almost no one). Assuming that my assumption-based guess is correct, the solution is to simply change the connection string ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 20, 2017
  • re: The SQL Hall of Shame

    @SAinCA: Interesting. What kind of workload is this, and what kind of PLE numbers do you see? It sounds like you're hitting a large amount of memory churn and I can understand why it helps in that case, but I wonder if such behavior is a sign of a less-than-ideal data access design? I'm generally not a fan of &quot;just throw hardware at it&quot; ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 19, 2017
  • re: The SQL Hall of Shame

    @Bob: Wow, quite the list! Agreed, sp_makewebtask was a joke. That email thing actually sounds really cool in a useless sort of way :-) There are use cases for visiting rows you've already seen in some bin packing algorithms and similar but ... should you really be doing any of that in SQL Server? sp_bind* has been deprecated since 2005 ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 19, 2017
  • re: The SQL Hall of Shame

    @NateTheDBA: Nice one! @JohnnyDBA: Yeah, I hear you on the disk space for large flattened reporting tables, but now the architect in me needs to question why you have large flattened reporting tables and whether they couldn't be re-designed? See, there's no way out here :-) Thanks for the mirrored backup feedback! Good to know.
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 19, 2017
  • re: The SQL Hall of Shame

    @Peter: As I said, I'd like both! In the meantime, beginning-of-month is still quite easy to implement using the tried-and-true truncation method: DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) @Wes: That's a lot of switching! How much better did things get after turning on the feature? I guess if you have tiny OLTP queries and nothing else ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 19, 2017
  • re: The SQL Hall of Shame

    @Michael: While I agree that StreamInsight was improperly packaged and badly managed from a product perspective, I'm on the fence about whether or not that makes it ''useless'' per this list. I guess if we're strict about saying ''most useless feature of SQL Server'' then it could apply. But it seems like a very useful thing in and of ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 19, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement