THE SQL Server Blog Spot on the Web

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


You searched for the word(s):
Showing page 1 of 103 (1,028 total posts) < 1 second(s)
  • New Post: The Career Influence of Usenet Strangers (T-SQL Tuesday #096)

    Check out my new post on some of the people who helped shaped my career: The Career Influence of Usenet Strangers (T-SQL Tuesday #096) &nbsp;
    Posted to a.m. (Weblog) by a.m. on November 14, 2017
  • re: sp_whoisactive: The Big Fixes!

    @Gustavo The header files used by various DMVs are not always aligned. I know of a few such examples. sp_whoisactive will use different DMVs depending on options. If you want to see OLEDB, do: EXEC sp_whoisactive @get_task_info = 2 --Adam
    Posted to a.m. (Weblog) by a.m. on September 28, 2017
  • re: Pattern-based replacement UDF

    @Ken: Nope, not intentional - but if you read the prior comments you'll see the issue: These two things produce the same result: select patindex ('cd', 'cd') select patindex ('cd', 'cd ') Changing the function to use NVARCHAR fixes things: select patindex (N'cd', N'cd ') --Adam
    Posted to a.m. (Weblog) by a.m. on September 20, 2017
  • re: The SQL Hall of Shame

    @Paul In my opinion CLR modules (functions, mainly) are extremely useful in the database in a number of cases. I've personally used them on several projects, and I'm surprised to hear from a .NET developer who can't think of any use cases -- even just simple string splitting? Keep in mind that CLR integration is not just for end users, but also ...
    Posted to a.m. (Weblog) by a.m. on August 29, 2017
  • re: The SQL Hall of Shame

    @Don: I seem to recall doing something with DPVs on one project. Can't recall if we rolled it to production or not. But agreed, not much action there. @Craig: Before I took my first MCP exam someone gave me a hint: &quot;There's the right answer, the wrong answer, and the Microsoft answer.&quot; I passed my exam, first shot, without choosing many ...
    Posted to a.m. (Weblog) by a.m. on August 29, 2017
  • re: You REQUIRE a Numbers table!

    @Thomas LOL, I guess you didn't bother to read the code in the post above before commenting? --Adam
    Posted to a.m. (Weblog) by a.m. on August 29, 2017
  • re: sp_whoisactive: The Big Fixes!

    @BB How quickly are these statements running?&nbsp; I've definitely seen cases with very fast queries -- on the order of 1-10ms -- where the DMVs simply don't show them. It's easy to repro. Grab SQLQueryStress or your favorite load simulation tool, fire up 200 threads, each running ''SELECT TOP(1) * FROM sys.databases'' 20000 times, and watch ...
    Posted to a.m. (Weblog) by a.m. on August 28, 2017
  • re: Playing the Third-Party Recruiter Game (T-SQL Tuesday #093)

    @Diana: I would recommend not touching those kinds of jobs at all. When I get lots of calls for one gig in a short period, that tells me that the hiring company doesn't care at all about who represents it -- kind of the opposite problem of what I discussed here. If the company doesn't care about who is representing it to potential candidates, how ...
    Posted to a.m. (Weblog) by a.m. on August 17, 2017
  • re: sp_whoisactive and Azure SQL Database

    @Nauman: You have no master database on Azure SQL Database, so don't try to create it in master. You have to create it in your own database. BTW Azure SQL Database is technically PaaS, not IaaS :-) --Adam
    Posted to a.m. (Weblog) by a.m. on August 16, 2017
  • re: Re-Inventing the Recursive CTE

    @Dennis: unfortunately the implementation of T-SQL recursive CTE is in fact the problem itself. There is no way to both use it and remedy its behavior simultaneously--at least none I can think of. Do you have an actual implementation in mind? Some questions to ask when working on this problem: How will the data get into the C# if the CTE ...
    Posted to a.m. (Weblog) by a.m. on August 12, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement