sql-server-2008-r2 tutorials

Is there a way around the 8k row length limit in SQL Server?

Sep 09, 2019

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

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

New posts in sql-server-2008-r2