sql-server-2014 tutorials

Using an IIF statement in a where clause

May 15, 2022

sql sql-server-2014 where-clause

Can we restore SQL Server 2008R2 backup on SQL Server 2014?

Aug 17, 2022

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

Select values between two columns range

Oct 21, 2017

sql sql-server sql-server-2014

Repeat value between two values in a column

Jun 16, 2022

sql sql-server sql-server-2014 recursive-cte

Could not load file or assembly Microsoft.SqlServer.TransactSql

Mar 30, 2022

sql-server azure azure-sql-database sql-server-data-tools sql-server-2014

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

New posts in sql-server-2014