sql-server-2014 tutorials

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

Oct 28, 2022

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

Perform a Case insensitive Like query in a case sensitive SQL Server database

Aug 28, 2019

sql-server sql-server-2014 sql-like collation case-insensitive

HAVING clause: at least one of the ungrouped values is X

Oct 26, 2022

sql sql-server tsql sql-server-2014

Get list of columns in a temp table in SQL Server

Sep 28, 2019

sql sql-server tsql sql-server-2014

Custom code similar to DATEDIFF_BIG in SQL Server 2014

Oct 22, 2022

sql sql-server sql-server-2014

IsNumeric failing with "A severe error occurred on the current command." SQL Server 2014 CTE

Sep 14, 2022

sql-server common-table-expression sql-server-2014 isnumeric

New posts in sql-server-2014