Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
I am running Windows 7 32 bit and I have IIS, Visual Studio 2008, 2010 installed. I am haunted by this error in SQL …
sql sql-server database sql-server-express sql-server-2008-r2Everything is based on the assumption that with(nolock) is entirely appropriate for the situtation. There are already plenty of …
sql sql-server select sql-server-2008-r2 nolockI am using SQL Server 2008 R2, I have a script to update the DB, that script is approx 50 MB in …
sql-server-2008 sql-server-2008-r2When I try to edit table data in SQL Server Management Studio 2008 R2 (right click in table object, Edit Top 200 …
sql-server sql-server-2008-r2 ssmsI have recently encountered an error while working with bcp. Here is the error. SQLState = 22001, NativeError = 0 Error = [Microsoft][SQL Server …
sql-server-2008 sql-server-2008-r2 bcpDoes Anyone knows the solution to this problem m not being able to run the SQL Server Services.
sql-server-2008-r2Is there a benefit to using CTE's (common table expressions) instead of using temp tables. I went through performance testing …
sql tsql sql-server-2008-r2 common-table-expression temp-tablesI am new to SQL Server, and I am sorry if there is an obvious solution to my question but …
reporting-services ssrs-2008 sql-server-2008-r2 datasourceI have the following table: Example: create table test ( col1 varchar(10), col2 varchar(20), col3 varchar(30) ); Now I want to insert …
sql sql-server sql-server-2008-r2 sql-insertWhenever I try to access SSRS 2008 R2 through a URL (i.e. after being published on the net), it always …
authentication reporting-services sql-server-2008-r2 ssrs-2008-r2