sql-server-2014 tutorials

Could not load file or assembly Microsoft.SqlServer.TransactSql

Mar 30, 2022

SQL to select consecutive records with the same value

Nov 11, 2022

sql sql-server-2014 gaps-and-islands

What does "Use windows fibers (lightweight pooling)" setting do in SQL Server 2014 server properties?

Oct 29, 2019

sql-server sql-server-2014

What's this column [Bmk1002] in the table scan operator of my execution plan?

Oct 28, 2022

sql-server tsql sql-server-2014 sql-execution-plan

Is the sort-order of table-valued-parameters guaranteed to remain the same?

Nov 02, 2022

c# sql-server ado.net sql-server-2014 table-valued-parameters

How to use INSERT INTO OPENROWSET to export to Excel without being an admin on the target server

Aug 19, 2022

sql-server windows sql-server-2014 file-permissions

How to Handle DATEDIFF(MINUTE, '00:00', '24:20') Like scenario?

Sep 07, 2022

sql sql-server sql-server-2014

Rank records based on 1 column's changing value

Nov 05, 2022

sql sql-server tsql sql-server-2014

Checking variable for NULL kills performance

Aug 04, 2018

sql-server sql-server-2014 sql-execution-plan sqlperformance

Is it possible to restrict a sql table to only have a single row at the design stage

Feb 04, 2022

sql sql-server sql-server-2014

Distributed database transaction vs cross database transaction

Feb 14, 2017

sql-server database sql-server-2008 sql-server-2012 sql-server-2014

Odd SQL Server (TSQL) query results with NEWID() in the "WHERE" clause

Apr 14, 2022

sql sql-server sql-server-2012 sql-server-2008-r2 sql-server-2014

Can I get "BULK INSERT"-like speeds when inserting from Java into SQL Server?

Nov 04, 2022

java sql-server performance sql-server-2014 bulkinsert

Best possible ways to disable index before insert operation and enable back Index after insert

Aug 21, 2022

sql-server indexing sql-server-2014 columnstore

Comparing two variables in SQL

Apr 24, 2022

sql tsql sql-server-2014

How to use LIKE and NOT LIKE together in a SQL Server query

Jan 03, 2020

sql sql-server database sql-server-2014

Unable to pass empty string into non-null database field

Sep 05, 2022

sql-server delphi sql-server-2014 ado delphi-10-seattle

New posts in sql-server-2014