New posts in sql-server-2008-r2

'Create VIEW' must be the only statement in the batch

sql-server sql-server-2008-r2

How do I add a "last updated" column in a SQL Server 2008 R2 table?

triggers sql-server-2008-r2

How to use a CTE statement in a table-valued function in SQL Server

sql-server sql-server-2008-r2 common-table-expression

SQL Server stops loading assembly

.net sql-server logging sql-server-2008-r2 sqlclr

How quickly will SQL Server release RAM when the OS signals a low memory condition?

sql-server memory-usage sql-server-2008-r2

Sql Server replication requires the actual server name to make a connection to the server

sql-server sql-server-2008-r2

How to automatically generate unique id in SQL like UID12345678?

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

SQL Server 2008 Spatial: find a point in polygon

sql-server sql-server-2008 sql-server-2008-r2 geospatial spatial

Create a view with ORDER BY clause

sql-server database tsql view sql-server-2008-r2

How to find out what is locking my tables?

sql sql-server sql-server-2008-r2 locking query-optimization

Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?

sql-server-2008 sql-server-2005 sql-server-2008-r2 backup-restoration

Unable to start sql service when TCP/IP is enabled under SSCM - SS Network Configuration

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

Ola Hallengren's SQL Backup to Network Location not working

scripting sql-server-2008-r2 database-backup

How to Split String by Character into Separate Columns in SQL Server

sql regex sql-server-2008-r2

Explicitly drop temp table or let SQL Server handle it

sql-server sql-server-2008-r2

Unique key vs. unique index on SQL Server 2008

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

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

stored-procedures sql-server-2008-r2 parameterized

Log Shipping to an Existing Database

sql-server sql-server-2008 sql-server-2008-r2 log-shipping

Error Invalid prefix or suffix characters in SQL Server Management Studio

sql-server sql-server-2008-r2 ssms

"This SqlTransaction has completed; it is no longer usable."... configuration error?

sql stored-procedures sql-server-2008-r2 server-error