Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
I have many users on my web site (20000-60000 per day), which is a download site for mobile files. I …
c# asp.net sql-server-2008-r2 timeout sqlcommandI have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes …
sql sql-server tsql sql-server-2008 sql-server-2008-r2how can i query my sql server to only get the size of database? I used this : use "MY_DB" …
sql sql-server sql-server-2008 sql-server-2008-r2I need to check when function was changed last time. I know how to check creation date (it is in …
sql-server-2008 stored-procedures sql-server-2008-r2 sql-functionCREATE TABLE IF NOT EXISTS works on mysql but fails with SQL Server 2008 R2. What is the equivalent syntax?
sql sql-server sql-server-2008-r2I am writing a Stored procedure in SQL Server 2008. I need to check if a table exists in the database. …
sql sql-server tsql sql-server-2008-r2I have MS SQL 2008 R2, 500 databases. What is the most efficient, easiest and 'modern' way to query all databases sizes. …
sql sql-server tsql sql-server-2008-r2I have a SQL table that all of a sudden cannot return data unless I include with (nolock) on the …
sql sql-server sql-server-2008-r2 locking query-optimizationCurrently, my database is in Single User mode. When I try to expand me database, I get an error: The …
sql-server sql-server-2008-r2I use the following to search for strings in my stored procedures: use DBname SELECT Name FROM sys.procedures WHERE …
sql sql-server sql-server-2008-r2