Search Results

select EditId, count(distinct RevisionGUID) as Invalidations from RelatedPosts Left Outer Join PostHistory on RelatedPost = PostId and CreationDate between DateAdd(mm, -6, EditDa …

I have never used it before but I think what you are looking for is CHARINDEX I found a StackOverflow Answer that has several upvotes and no downvotes using it like this WHERE CHARINDEX('</code></pre …

If you write the query where you first order by rank and then by age, you will get a better result, and you should be able to get rid of part of the where statement, which I would think would make the …

I would change some things. This: inner join Votes bo on q.Id = bo.PostId and q.PostTypeId = 1 -- Questions and bo.VoteTypeId = 8 -- BountyOpen kind of s …

First of all, when you are selecting and want to perform mathematics on it you should directly specify what you want done instead of Voters.Upvotes * 8 as [EstimatedAddedRep], it should be (Vo …

I will look at this again in a couple of days or maybe even later today, but here is something I saw right at the end of the question WebSocketReceiveResult response; while …

The one thing that jumped out at me was WHERE Q.Id = A.ParentId You could JOIN the tables on that link instead. Formatting wise, (and you probably already know this, most people find it a bit te …

Common Table Expressions are for all, intents and purposes, a Table and should be named accordingly, WITH cte_downvoted_posts AS Should be WITH DownvotedPosts AS Drop the Hungarian Naming st …

Removing some of the code where this would refresh, I forgot to alter the @match's and this made it kind of tricky to do a review (I changed the timer to 20 seconds) I needed to remove the wildcard f …

I noticed that you put Comma first in your select statements, something that I also do is to put the conjunctions first in my where conditions, it has similar advantages AND ( Posts.Title LIKE …

You should always have an Alt attribute in your img tags <img src="https://i.sstatic.net/bGZ1m.png" width="80" height="43"> <img src="https://i.sstatic.net/bGZ1m.png" width="80" height="43" …