Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
Were there any changes in this area with SQL Server 2014? I’ve seen this post Is it possible to restore …
sql-server sql-server-2008 sql-server-2005 sql-server-2008-r2 sql-server-2014i have a SQL server job that runs a SSIS package. This job has 9 steps and in each step it …
sql-server-2008-r2How can I get the AVG of a column ignoring NULL and zero values? I have three columns to get …
sql sql-server tsql sql-server-2008-r2I wanted to use MOD function in SQL Server 2008R2 and followed this link but still got the message: 'MOD' …
sql sql-server-2008 tsql sql-server-2008-r2 moduloI am looking for a SQL query that outputs the function definitions for all of the user defined functions in …
sql-server sql-server-2008-r2I have database Test1 in SQL Server 2008 R2. On the live server I took backup from there and restore it …
sql-server sql-server-2008-r2I am doing a BULK INSERT into sqlserver and it is not inserting UTF-8 characters into database properly. The data …
sql-server utf-8 sql-server-2008-r2 bulkinsertIs it possible to create a clustered index from a create table statement in SQL Server 2008 that is not a …
sql-server sql-server-2008 sql-server-2008-r2 azure-sql-database clustered-indexI want to start the SQL Server Agent (sql server 2008 R2 Enterprise edition), then I did: Open SQL Server configuration …
sql-server sql-server-2008-r2 sql-server-agentROW_NUMBER() is only for used in the SELECT clause in MS SQL Server, but I want to use it …
sql-server tsql sql-server-2008-r2 window-functions