sql-server-2008-r2 tutorials

How to convince sql server 2008r2 to use clr v4.0 instead of v2.0?

Aug 30, 2022

'insert into' with array

Oct 19, 2022

sql tsql sql-server-2008-r2

Determine table referenced in a view in SQL Server

Nov 09, 2022

sql sql-server sql-server-2008-r2

.Skip().Take() on Entity Framework Navigation Properties is executing SELECT * on my SQL Server

May 18, 2022

c# .net entity-framework sql-server-2008-r2 navigation-properties

Database default value is not inserted while create record by entity framework

May 11, 2022

c# asp.net-mvc entity-framework sql-server-2008-r2

SQL Server why must I refresh views after table changes

Jun 30, 2019

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

Can I create SSRS Reports in VS 2015 using SQL Server 2008 R2?

Nov 12, 2022

reporting-services visual-studio-2015 sql-server-2008-r2 ssrs-2008-r2

Joining Two Same-Sized Resultsets by Row Number

Oct 03, 2019

sql sql-server sql-server-2008-r2

Create user that can only SEE one database, and only select from it?

Jan 12, 2020

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

The Messenger service has not been started - NetSend notifications will not be sent

Dec 03, 2021

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

How do UPDATE locks prevent a common form of deadlock?

Sep 05, 2022

sql-server sql-server-2008-r2

SSRS sum max by group

Nov 05, 2022

reporting-services sql-server-2008-r2

Why does SQL Server thinks a Temp Table already exists when it doesn't?

Oct 26, 2022

sql-server tsql sql-server-2008-r2

Execution plan over query with temp tables

Mar 21, 2022

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

Soft Delete - Use IsDeleted flag or separate joiner table?

Jun 04, 2018

indexing sql-server-2008-r2 soft-delete

Simple dynamic TSQL query syntax

Oct 28, 2022

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

SQL Server create Triggers on INSERT and Update

Mar 31, 2022

sql-server sql-server-2008-r2

Generate script for triggers only using script wizard

Aug 17, 2022

sql-server sql-server-2008-r2

How to allow temporary tables to accept null values

Nov 02, 2017

sql null sql-server-2008-r2 temp-tables

Strange Error XML parsing: line 1, character 2038, illegal xml character

Mar 11, 2018

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

New posts in sql-server-2008-r2