DEV Community: baris

Azure Application Insights - Summarize by part of timestamp

baris — Fri, 09 Feb 2024 15:45:49 +0000

Jun 6 '17 Comments: 1 Answers: 1

How can I summarize records by year, month,day and hour only?

Open Full Question

Answer: git remove file from stash, nice workaround

baris — Mon, 21 Aug 2023 07:09:54 +0000

Oct 4 '16

There is a workaround for this situation:

save your stash as a patch file:
```
$ git stash show -p > stash.patch
```
apply this patch, skipping the conflicts (you will be asked for resolution of conflicts, just skip missing files):
```
$ patch -p1 < stash.patch
```

Don't forget to clean up stash.patch…

Open Full Answer

Answer: VS 2022: High RAM and CPU issue with Roslyn Code Analysis

baris — Thu, 11 May 2023 14:46:25 +0000

Jul 13 '22

In Visual Studio 2022, I've resolved it by disabling these two checks:

after that, Visual Studio works well.

Open Full Answer

Answer: Git error on git pull (unable to update local ref)

baris — Mon, 08 May 2023 08:56:37 +0000

Lifesaver

Dec 3 '14

599

My team and I ran into this error, unable to update local ref, when doing a pull in SourceTree.

Update 2020: Per @edward Yang's answer below, @bryan's comment on this answer, and this question/answer you may need to run both git gc --prune=now and git remote prune origin…

Open Full Answer

Answer: MySQL LIMIT clause equivalent for SQL SERVER

baris — Tue, 17 Jan 2023 12:38:16 +0000

Jan 26 '12

In SQL Server 2012, there is support for the ANSI standard OFFSET / FETCH syntax. I blogged about this and here is the official doc (this is an extension to ORDER BY). Your syntax converted for SQL Server 2012 would be:

SELECT ID, Name, Price, Image 
  FROM Products 
  ORDER

…

Open Full Answer

Answer: Generate Unique hash for a field in SQL Server

baris — Tue, 17 Jan 2023 12:25:31 +0000

Jun 8 '12

If your question is just how to generate a hash value for userid, you can do it this way using a computed column (or generate this value as part of the insert process). It isn't clear to me whether you know about the HASHBYTES function or what other criteria you're…

Open Full Answer

Answer: SQL Error with Order By in Subquery

baris — Tue, 17 Jan 2023 12:17:58 +0000

May 19 '17

If you're working with SQL Server 2012 or later, this is now easy to fix. Add an offset 0 rows:

SELECT (
  SELECT
  COUNT(1) FROM Seanslar WHERE MONTH(tarihi) = 4
  GROUP BY refKlinik_id
  ORDER BY refKlinik_id OFFSET 0 ROWS
) as dorduncuay

Open Full Answer

Answer: Real life example, when to use OUTER / CROSS APPLY in SQL

baris — Wed, 29 Dec 2021 16:28:25 +0000

answer re: Real life example, when to use OUTER / CROSS APPLY in SQL

Feb 14 '12

199

Some uses for APPLY are...

1) Top N per group queries (can be more efficient for some cardinalities)

SELECT pr.name,
       pa.name
FROM   sys.procedures pr
       OUTER APPLY (SELECT TOP 2 *
                    FROM   sys.parameters pa
                    WHERE  pa.object_id = pr.object_id
                    ORDER  BY pr.name) pa
ORDER  BY pr.name,
          pa.name

2) Calling a Table Valued…

Open Full Answer

Answer: How to create an Instance of an Object in StructureMap Dynamically?

baris — Fri, 01 Oct 2021 08:32:48 +0000

answer re: How to create an Instance of an Object in StructureMap Dynamically?

Jul 18 '17

I am sorry, but I disagree with the answers general assertion.

You shouldn't need to create concrete factories if you are using IoC...that is the whole point of dependency injection.

Consider this small example...

The UnitOfWork will be instantiated by StructureMap
The BankAccountApplication can & should also be instantiated by…

Open Full Answer

I need to read it more carefully

Is a JOIN faster than a WHERE?

baris — Mon, 13 Sep 2021 07:46:46 +0000

Is a JOIN faster than a WHERE?

Jul 15 '09 Comments: 4 Answers: 10

Suppose I have two tables that are linked (one has a foreign key to the other):

CREATE TABLE Document (
  Id INT PRIMARY KEY
  Name VARCHAR 255
)

CREATE TABLE DocumentStats (
  Id INT PRIMARY KEY,
  DocumentId INT, -- this is a foreign key to table Document
  NbViews INT
)

…

Open Full Question

Answer: What is the difference between Factory and Strategy patterns?

baris — Sat, 27 Feb 2021 15:42:21 +0000

answer re: What is the difference between Factory and Strategy patterns?

Mar 5 '09

244

A factory pattern is a creational pattern. A strategy pattern is an operational pattern. Put another way, a factory pattern is used to create objects of a specific type. A strategy pattern is use to perform an operation (or set of operations) in a particular manner. In the classic example…

Open Full Answer

Strategy vs Factory design pattern

baris — Sat, 27 Feb 2021 15:30:14 +0000

Good answer to differentiate them

https://softwareengineering.stackexchange.com/a/405690/349813