sql-server-2008-r2 tutorials

SQL Unique key insertions

Aug 17, 2022

How can I prevent date overlaps in SQL?

Nov 13, 2022

sql tsql sql-server-2008-r2

Is this the correct way to use UNION ALL in a stored procedure?

May 12, 2022

sql sql-server stored-procedures sql-server-2008-r2 union

update a database table field with comma separated list from join

Oct 26, 2018

sql sql-server sql-server-2008-r2 sql-update

Stop trigger changing scope_identity

Sep 25, 2022

sql sql-server triggers sql-server-2008-r2

Is there a way around the 8k row length limit in SQL Server?

Sep 09, 2019

sql sql-server tsql sql-server-2008-r2

how to perform sorting and filtering in stored procedure with performance optimization?

Jul 23, 2022

sql sql-server select stored-procedures sql-server-2008-r2

Get substring between second and fourth slash

Apr 26, 2018

sql sql-server sql-server-2008-r2

How to add xmlns in the root in XML in SQL Server 2014

Nov 11, 2022

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

Is it feasible to improve performance of SQL server with caching?

Sep 12, 2022

c# .net sql sql-server-2008-r2 redis

SQL Studio Management - How to run queries across multiple servers

Nov 23, 2017

sql-server-2008-r2 ssms sql-server-2008

How to resolve SQL Server deadlocks - once changing order and shortening queries is exhausted?

Aug 31, 2018

sql-server sql-server-2008-r2 database-deadlocks

How do I insert a default value as part of a SQL Server View definition?

May 23, 2022

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

How to update a SQL Server table using the latest record

Dec 25, 2019

sql-server sql-server-2008-r2

Operand type clash: nvarchar is incompatible with Type_WP_Days

Oct 05, 2019

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

What is faster: SUM over NULL or over 0?

Sep 11, 2022

sql-server sql-server-2008-r2 sql-server-2012 query-performance

How to check who is holding a lock that I would like to grant?

Oct 29, 2022

sql sql-server tsql sql-server-2008-r2

how to get SSRS 2008 R2 to export/render in Excel 2007 format?

Oct 16, 2022

reporting-services sql-server-2008-r2

Optimizing massive insert performance...?

Dec 07, 2019

performance sql-server-2008-r2

Find Column dependency

Sep 07, 2022

sql-server tsql sql-server-2008 sql-server-2008-r2

New posts in sql-server-2008-r2