sql-server tutorials and guides

When to use SqlConnection.ClearAllPools() in c#

Mar 26, 2019

c# sql-server

SQL Server for testing on the web

Sep 23, 2022

sql sql-server database tsql

How to get selected fields from sp_spaceused query in mssql

Aug 23, 2022

sql-server

SQL Server 2012: Add a linked server to PostgreSQL

Nov 08, 2022

sql sql-server postgresql sql-server-2012 linked-server

Shrinking a SQL Server database not working

Dec 24, 2020

sql-server sql-server-2008-r2

Does use of COALESCE slows down the query performance

Apr 12, 2018

sql-server

How do I change a column from null to not null when an index depends on that column without recreating the index?

Sep 07, 2022

sql-server database azure-sql-database database-indexes alter-column

Remove Rows That Sum Zero For A Given Key

Oct 30, 2022

sql sql-server

What is SQL equivalent to LINQ .All()

Oct 18, 2022

sql sql-server linq sql-server-2012

Entity Framework 1to1 relationship via association table not working in EDMX

Sep 07, 2022

c# sql-server entity-framework entity-framework-6 edmx

Entity Framework Not Generating Classes for Tables or Procedures

Oct 23, 2022

c# sql-server entity-framework ado.net-entity-data-model

SET IDENTITY_INSERT ON/OFF needed on application server, but ALTER permission seems dangerous. Suggestion?

Jan 19, 2022

sql-server database-design web-applications sql-server-2012

Entity Framework Deadlocks and Concurrency

Sep 19, 2022

.net sql-server vb.net entity-framework

Why WHEN MATCHED' cannot appear more than once in a 'UPDATE' clause of a MERGE statement?

Oct 14, 2022

sql sql-server merge

Update multiple second Id's to match the first Id's of a series

Jul 25, 2018

sql sql-server sql-server-2008 tsql

Left outer join with only first row

May 02, 2022

sql sql-server greatest-n-per-group

RODBC and Microsoft SQL Server: Truncating Long Character Strings

Oct 20, 2022

sql-server r truncate rhel rodbc

Is recursion good in SQL Server?

Nov 02, 2022

sql-server recursion

How can I change a field in a SQL server database that's set to "Read Only Cell"?

Oct 14, 2019

sql-server ssms

Error converting data type varchar

Jun 05, 2022

sql sql-server tsql

New posts in sql-server