sql-server tutorials and guides

Efficient way to compare for a NULL or value for a column in SQL

Apr 21, 2018

How many connections are available in the ADO.NET connection pool

Oct 21, 2019

.net sql-server ado.net connection-pooling

Is there a tool to convert T-SQL Stored Procedures to C#? [closed]

Nov 12, 2019

c# sql-server tsql stored-procedures

Difference between .NET, OLEDB, and Native Providers in SSIS

Nov 05, 2022

sql-server sql-server-2008 ssis

Performance effect of Synonyms over a linked server in SQL Server

May 06, 2019

sql-server performance sql-server-2008-r2 linked-server synonym

CROSS APPLY with table valued function restriction performance

Nov 08, 2022

sql-server performance restriction cross-apply

Insert or Update SQL Table with DataTable

Oct 18, 2022

c# asp.net sql-server

Why does LINQ to SQL translate GroupBy into multiple queries

Nov 11, 2022

c# sql-server linq linq-to-sql

Non-optimal execution plan using sp_executesql

Dec 15, 2020

sql-server reporting-services sp-executesql

Universal SELECT query for testing connectivity

Sep 13, 2022

mysql sql sql-server oracle

Curious slowness of EF vs SQL

Sep 27, 2022

c# sql-server multithreading entity-framework ado.net

C# SMO Database do not log creation

Jan 16, 2020

c# sql-server nunit smo nunit-console

EF: Passing a table valued parameter to a user-defined function from C#

Oct 22, 2022

c# sql-server entity-framework entity-framework-6 table-valued-parameters

MERGE vs. UPSERT

Nov 06, 2022

sql sql-server sql-server-2008 tsql sql-merge

How to find source of 'No Join Predicate'

Aug 16, 2022

sql-server tsql sql-server-2008

CONCAT(column) OVER(PARTITION BY...)? Group-concatentating rows without grouping the result itself

Nov 14, 2022

sql sql-server sql-server-2008 tsql string-aggregation

A smarter Entity Framework Codefirst fluent API

Apr 24, 2016

c# sql-server entity-framework ef-code-first

DTS_E_OLEDBERROR. Error code: 0x80004005.Difference between SQl Native client and oledb provider for sql server

Jan 20, 2020

sql-server oledb ssis dts

Table Per Concrete Type (TPC) Inheritance in Entity Framework 6 (EF6)

Oct 27, 2022

c# asp.net sql-server entity-framework inheritance

Smarter way to use SQLCMD with dynamic calling

Aug 17, 2019

sql sql-server sqlcmd

New posts in sql-server