sql-server-2014 tutorials

Using OFFSET-FETCH, how to default number of rows to "all rows"?

Dec 07, 2019

Response data truncation when running SP through job

Aug 23, 2022

sql-server stored-procedures sql-server-2014

difference between view and indexed view or materialized view

Oct 19, 2022

sql sql-server sql-server-2014

Execute SSIS package from stored procedure as proxy user without xp_cmdshell

May 12, 2022

sql-server stored-procedures ssis impersonation sql-server-2014

Convert XML data into tsql record for any XML response

Aug 24, 2022

c# sql-server xml tsql sql-server-2014

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

New posts in sql-server-2014