sql-server-2008-r2 tutorials

SQL Server deprecation announcement of use of RC4 on login, when i'm not using it

Jul 08, 2022

sql-server-2008-r2 deprecated

Get schema of the result returned by select query

Nov 07, 2022

sql-server database sql-server-2008-r2 relational-database

How to create a indexed view with tables from 2 different databases using Schemabinding

Apr 13, 2022

sql sql-server sql-server-2008-r2

How to identify a transaction table?

Oct 25, 2022

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

WTH (NOLOCK) syntax fo subquery

Oct 29, 2022

sql-server sql-server-2008-r2 nolock

Embed SQL Server Credentials in Excel 2016 (O365) to Refresh Data On-Demand

Nov 12, 2022

sql sql-server-2008-r2 excel-2016

SQL Unique key insertions

Aug 17, 2022

c# .net entity-framework exception-handling sql-server-2008-r2

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

Find Column dependency

Sep 07, 2022

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

New posts in sql-server-2008-r2