64
votes
12
answers
1.8K
views
Remove a file from a Git repository without deleting it from the local filesystem
My initial commit contained some log files. I've added *log to my .gitignore, and now I want to remove th
63
votes
3
answers
1.3K
views
Identity Server 4/nativescript Hangs
I have the following client: new Client { ClientId = "nativeapptest", ClientName = "Native App Test",
54
votes
17
answers
1K
views
Entity Framework: There is already an open DataReader associated with this Command
I am using Entity Framework and occasionally i will get this error. EntityCommandExecutionException {"There
66
votes
4
answers
2.7K
views
What is Kestrel (vs IIS / Express)
What is the kestrel web server and how does it relate to IIS / IIS Express? I come from developing apps on II
53
votes
3
answers
1.4K
views
Loadbalancing web sockets
I have a question about how to load balance web sockets. I have a server which supports web sockets. Browsers
63
votes
12
answers
1.4K
views
Send message to specific client with socket.io and node.js
I'm working with socket.io and node.js and until now it seems pretty good, but I don't know how to s
51
votes
6
answers
1.7K
views
WebSockets vs. Server-Sent events/EventSource
Both WebSockets and Server-Sent Events are capable of pushing data to browsers. To me they seem to be competin
60
votes
11
answers
2.9K
views
Node.js Best Practice Exception Handling
I just started trying out node.js a few days ago. I've realized that the Node is terminated whenever I ha
60
votes
30
answers
1.2K
views
Using Node.js as a simple web server
I want to run a very simple HTTP server. Every GET request to example.com should get index.html served to it b
61
votes
16
answers
2.1K
views
DateTime2 vs DateTime in SQL Server
Which one: datetime datetime2 is the recommended way to store date and time in SQL Server 2008+? I'm a
57
votes
22
answers
2.5K
views
How can I get column names from a table in SQL Server?
I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I a
55
votes
27
answers
2.1K
views
How can I list all foreign keys referencing a given table in SQL Server?
I need to remove a highly referenced table in a SQL Server database. How can I get a list of all the foreign
51
votes
11
answers
2.8K
views
How to Join to first row
I'll use a concrete, but hypothetical, example. Each Order normally has only one line item: Orders: Or
56
votes
14
answers
2.5K
views
Should I use != or <> for not equal in T-SQL?
I have seen SQL that uses both != and <> for not equal. What is the preferred syntax and why? I like !=
57
votes
30
answers
965
views
Exclude a column using SELECT * [except columnA] FROM tableA?
We all know that to select all columns from a table, we can use SELECT * FROM tableA Is there a way to excl
55
votes
21
answers
1.8K
views
Function vs. Stored Procedure in SQL Server
I've been learning Functions and Stored Procedure for quite a while but I don't know why and when I
63
votes
24
answers
2.6K
views
Search text in stored procedure in SQL Server
I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.
63
votes
15
answers
1.4K
views
When should I use CROSS APPLY over INNER JOIN?
What is the main purpose of using CROSS APPLY? I have read (vaguely, through posts on the Internet) that cros
61
votes
25
answers
3K
views
SQL update from one Table to another based on a ID match
I have a database with account numbers and card numbers. I match these to a file to update any card numbers to
58
votes
30
answers
2.5K
views
Parameterize an SQL IN clause
How do I parameterize a query containing an IN clause with a variable number of arguments, like this one? SEL
