sql-server-2008-r2 tutorials

How to retrieve only integer values from SQL Server [duplicate]

May 20, 2022

TSQL DateTime to DateKey Int

Sep 23, 2022

tsql sql-server-2008-r2 data-warehouse

ERROR - The specified data type is not valid. [ Data type (if known) = varchar ] [duplicate]

Oct 15, 2022

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

Select subset of rows using Row_Number()

Sep 24, 2022

sql database sql-server-2008-r2 row-number

How to drop all of the indexes except primary keys with single query

Jul 10, 2022

sql-server sql-server-2008-r2 indexing

Script to list the SQL Server Databases, Size and Utilisation by Specific Application or Service

Jun 17, 2019

sql database tsql sql-server-2008-r2

Passing a table expression to a table-parameterized function

Nov 16, 2022

sql-server sql-server-2008-r2

SQL Server 2008 R2 Periodically Does Not Accept Connections

Nov 05, 2022

sql-server-2008-r2

How can I run multiple versions of my application against the same database?

Jan 20, 2022

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

Spatial index slowing down query

Nov 21, 2022

sql-server-2008-r2 spatial-index sqlgeography

LINQ to Entities query takes long to compile, SQL runs fast

Mar 13, 2018

c# linq-to-entities sql-server-2008-r2

How to know the TimeZone StandardName or DayLightName from TimeZoneOffset in Sql Server

Jul 28, 2020

sql sql-server sql-server-2008-r2 timezone timezone-offset

Weird side effect of "SET STATISTICS TIME ON" in SQL Server 2008R2?

Sep 30, 2022

sql-server sql-server-2008-r2

SSIS and 64-bit Microsoft Access Database Engine

Aug 30, 2022

sql-server ssis sql-server-2008-r2 aceoledb

Database reads varying dramatically on a query with indexes

Oct 30, 2022

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

Change in query plan and execution time with TOP and ESCAPE

Oct 29, 2022

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

New posts in sql-server-2008-r2