sql-server-2008-r2 tutorials

Performance effect of Synonyms over a linked server in SQL Server

May 06, 2019

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

How to concatenate strings from multiple rows in one column + inner join in one query

Dec 24, 2020

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

SQL Server conversion issue with datetime

Nov 10, 2022

sql sql-server datetime casting sql-server-2008-r2

How should I return an int from a stored procedure in entity framework 4.1?

Jun 28, 2018

c# stored-procedures entity-framework-4.1 sql-server-2008-r2

How do I add the description property to the table designer view in SSMS?

Apr 20, 2022

sql-server sql-server-2008-r2

How to set identity column to created table in SQL server

Oct 17, 2022

sql-server sql-server-2008-r2

Pass A User-Defined Table to a Stored Procedure

Oct 14, 2022

sql-server stored-procedures sql-server-2008-r2 user-defined-types

How to get SQLCMD to output errors and warnings only

Oct 24, 2022

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

How to find list of tables having no records in SQL server

Mar 22, 2018

database sql-server-2008-r2

Which tables are using Change tracking

Mar 14, 2022

sql-server-2008-r2

New posts in sql-server-2008-r2