sql-server-2008-r2 tutorials

Alternatives to snapshot functionality, SQL Server Standard

Oct 30, 2022

How to convert SQL Server 2008 R2 database to SQL Server 2012?

Feb 03, 2022

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

Using OUTPUT after INSERT to get value of identity column into a (non-table value) variable

Nov 19, 2022

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

Inner joining to a select statement where the inner select statement's where clause references the outer select?

Jan 05, 2019

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

replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)

Nov 07, 2022

sql-server aggregate-functions sql-server-2008-r2 analytic-functions

Select parent if all children meet criteria

Apr 11, 2022

sql sql-server-2008-r2

Convert from DateTime to INT

Nov 02, 2022

sql-server ssis sql-server-2008-r2

unusual sql server query result

Nov 11, 2022

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

ado.net transaction.commit throws semaphorefullexception

Mar 11, 2019

c# ado.net transactions sql-server-2008-r2

Performance effect of Synonyms over a linked server in SQL Server

May 06, 2019

sql-server performance sql-server-2008-r2 linked-server synonym

Visual Studio 2015 - Sql Server Project Database Diagram

Apr 03, 2022

sql-server-2008-r2

Specifying Port With SqlConnectionStringBuilder?

Dec 20, 2017

c# sql-server sql-server-2008-r2 database-connection connection-string

Automatically generate a user defined table type that matches an existing table

Sep 07, 2022

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

How to call UDF with Dapper?

Feb 19, 2022

sql-server orm sql-server-2008-r2 user-defined-functions dapper

Why are the performances of these 2 queries so different?

Sep 14, 2022

sql-server performance sql-server-2008-r2 sql-execution-plan

NVARCHAR(?) for Email addresses in SQL Server

Nov 02, 2022

sql sql-server email sql-server-2008-r2 nvarchar

How to backup a filestream database?

Jan 09, 2016

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

Give a title to each sql query output

Aug 29, 2022

sql sql-server sql-server-2008-r2

Rollback transaction from trigger

Jun 26, 2019

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

How to SET IDENTITY_INSERT ON in SQL Server 2008 for multiple tables at once

Oct 17, 2022

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

New posts in sql-server-2008-r2