sql-server-2008-r2 tutorials

Redeploying SSIS packages - Cache?

May 10, 2019

ssis sql-server-2008-r2

TSQL Group by Column with Multiple Values

Aug 26, 2022

sql-server tsql sql-server-2008-r2

Why only some users get the error: "Connection is busy with results for another command"

Jun 28, 2019

sql-server delphi database-connection sql-server-2008-r2

Am I running a 32-bit or 64 bit Sql Server

Nov 02, 2022

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

SSIS - OLE DB Destination - Table or Views load vs. Fast-load

Apr 09, 2022

ssis sql-server-2008-r2 data-warehouse

what is Enlist=false means in connection string for sql server?

Oct 31, 2022

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

How do I find the current version of a SQL Server data-tier application?

Aug 08, 2021

sql-server-2008-r2 data-tier-applications

Where clause on subquery statement in select

Apr 09, 2020

sql sql-server-2008-r2

SQL reverse LIKE

Aug 17, 2022

sql linq sql-server-2008-r2

SQL Transaction uncommittable while using try..catch.. Why?

Jul 16, 2017

sql sql-server transactions sql-server-2008-r2 try-catch

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'

Oct 03, 2017

sql-server-2008 visual-studio-2008 sql-server-2008-r2

CROSS JOIN with one empty table sql server

Jul 18, 2018

sql-server sql-server-2008-r2

How to pass string parameter with `IN` operator in stored procedure SQL Server 2008

Oct 16, 2022

stored-procedures sql-server-2008-r2 parameterized

ALTER INDEX failed because of QUOTED_IDENTIFIER when running from sp_msForEachTable

Apr 01, 2022

sql-server sql-server-2008-r2 reindex sp-msforeachtable

How could I force the data type of a computed column to a bit field that don't allow nulls?

Mar 06, 2022

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

cross apply xml query performs exponentially worse as xml document grows

Sep 21, 2022

sql-server performance sql-server-2008-r2 sqlxml cross-apply

How to get the list of active triggers on a database?

Sep 21, 2022

sql-server triggers sql-server-2008-r2

Trigger Error: The current transaction cannot be committed and cannot support operations that write to the log file

Sep 21, 2022

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

Programmatically copy indexes from one table to another in SQL Server

Apr 21, 2019

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

CTE (Common Table Expression) vs Temp tables or Table variables, which is faster?

Feb 16, 2019

performance sql-server-2008-r2 common-table-expression temp-tables table-variable

New posts in sql-server-2008-r2