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 162 (1,616 total posts) < 1 second(s)
  • re: The Guru (T-SQL Tuesday #089)

    @Andrej LOL! No, not him at all! I wish I would have had him to work with instead of the real guy. Would have been an entirely different experience. --Adam
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 31, 2017
  • re: Released: Who is Active v11.11

    @Antony See: http://sqlblog.com/blogs/adam_machanic/archive/2011/04/25/capturing-the-output-a-month-of-activity-monitoring-part-25-of-30.aspx
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 23, 2017
  • re: The Guru (T-SQL Tuesday #089)

    @Kevin ''Jonathan'' is an incredibly smooth talker. Very skilled at selling himself. There is a LOT to be learned from him... just not technology :-) A friend of mine read this post over the weekend and knew right away who I was talking about. He emailed me and told me that he worked with Jonathan a bit more recently and had a similar situation. ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 20, 2017
  • re: The Guru (T-SQL Tuesday #089)

    @Paul Good question. From both a communication and confidence perspective I am today much better equipped to handle such difficult customers than I was when this situation took place. As for actually doing the work? I'm not sure. Getting that thing into shape would have been a truly massive undertaking. Basically a complete re-write, and I ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 17, 2017
  • re: The Guru (T-SQL Tuesday #089)

    @Prakash If only I knew a trace flag to fix such a crazy design, I would make a lot of money applying it for customers :-)
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 14, 2017
  • re: Released: Who is Active v11.11

    @Rocky That's a shared schema stability lock. All queries take them. Your insert has an X lock for some reason, and you need to figure out why. That should not be the case for something using a table variable. There is simply no way to get around an X schema lock. --Adam
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 14, 2017
  • re: Released: Who is Active v11.11

    @Rocky What question are you trying to answer? No, there is no other option in sp_whoisactive for that info, and you can't get it any other faster way either. The issue is that the DMV from which this data is sourced is simply very big and very slow. And it's really not useful all that often, which is why Microsoft hasn't bothered improving ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 14, 2017
  • The Guru (T-SQL Tuesday #089)

    I became a consultant a bit earlier in my career than was probably wise. The going was rough at first, with periods of feast and periods of famine. Although I had several clients, I didnt understand how to sell services or schedule my workload, and so Id wind up either doing huge amounts of work for a few weeks, or absolutely nothing some other ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 14, 2017
  • re: Released: Who is Active v11.11

    @Rocky, sp_whoisactive should not get blocked except by an exclusive schema lock. That should only occur for a moment in the case of a temp table insert. Are you sure it's actually ''blocked'' and not just ''very slow?'' The @get_lock_info mode is known to be a major resource hog, and I do not recommend using it except for occasional targeted ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on March 14, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement