sql-server-2008-r2 tutorials

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

Return empty or null fields as <element /> from SQL Server 2008 R2 with FOR XML

May 21, 2022

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

Pagination and INNER JOIN

Oct 30, 2022

sql-server tsql sql-server-2008-r2 inner-join

create virtual index - just for the plan

Feb 11, 2022

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

Select and assign to variable in one statement?

May 12, 2022

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

How to assign an XML Schema doc to a SQL Server's table's column with an XML data type

Dec 28, 2019

sql-server xml sql-server-2008 xsd sql-server-2008-r2

Determine which SQL data types require value to be quoted?

Aug 28, 2022

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

Difference between different ways of writing IF Exists?

Oct 15, 2022

sql performance sql-server-2008-r2

String or binary data would be truncated, field find

Sep 07, 2022

sql sql-server sql-server-2008-r2

Display Summary Result in SQL Server

Mar 07, 2022

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

invalid column name when passing variable mssql

Jun 05, 2021

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

Xml Parsing Issue in sql job

Jul 03, 2020

sql-server xml sql-server-2008-r2 xml-parsing

Showing information about databases in ado.net

Nov 01, 2022

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

In SQL, how can I convert a VARCHAR to a STRING?

Jul 04, 2022

sql sql-server-2008-r2

How to ALTER INDEX for every Table in my DataBase

Mar 20, 2022

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

New posts in sql-server-2008-r2