Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
When I try to rebuild an index on a table: ALTER INDEX ALL ON [dbo].[Allocations] REBUILD that works fine. …
sql-server sql-server-2008-r2 reindex sp-msforeachtableI am trying to put an with(NOLOCK) on an update query: UPDATE pth_patchLookup with(nolock) SET ScanDateTime = Getdate() …
sql sql-server-2008-r2 nolockWho can explain list of xp_Delete_file parameters in sql server. I don't find msdn document for this stored …
sql-server sql-server-2008-r2 sql-server-2012 sql-server-2014I have huge table with 2 columns: Id and Title. Id is bigint and I'm free to choose type of Title …
sql sql-server full-text-search query-optimization sql-server-2008-r2Been playing around with the Code First feature of Entity Framework 4.1 using an ASP.NET MVC 3 project. However the database (…
visual-studio-2010 entity-framework asp.net-mvc-3 ef-code-first sql-server-2008-r2When I tried upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise, it passed all tests and then …
sql-server windows sql-server-2008-r2 upgrade sql-server-2008r2-expressBackground I'm creating some SQL to assist with security auditing; this will take security info from various systems databases and …
tsql active-directory sql-server-2008-r2 adsi ldap-queryWe'd like to move our Confluence system to a SQL Server 2008 R2. Now, since Confluence uses UTF-8 encoding, I'd need …
utf-8 sql-server-2008-r2 collation ucs2In my SQL Server agent, I did not set any notifications, then why this error is coming? I run pakg …
sql-server sql-server-2008-r2 sql-server-agentI have a table called countries and I define the country_name column to be unique by creating a “Index/…
sql sql-server sql-server-2008 tsql sql-server-2008-r2