Questions tagged [sql-server-2008-r2]

219

votes

13

answers

Select SQL Server database size

asked 2013-08-02T10:12:40.090

14

votes

7

answers

SQL Server drop and recreate indexes of a table

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

asked 2013-07-05T12:17:47.383

27

votes

6

answers

The service cannot be started, either because it is disabled or because it has no enabled devices associated with it

sql-server-2008-r2

asked 2013-07-01T12:40:42.060

19

votes

3

answers

SQL Server Profiler - how do I find which database is being connected?

database sql-server-2008-r2 connection trace sql-server-profiler

asked 2013-06-10T21:59:46.293

19

votes

11

answers

SQL Server "." Alias Not Working

sql-server-2008 sql-server-2008-r2 connection-string alias

asked 2013-05-28T14:03:25.147

14

votes

2

answers

Typing in password for every connected table from SQL Server 2008 R2 in Excel 2010 Powerpivot Addin

sql-server-2008-r2 excel-2010 powerpivot

asked 2013-05-24T10:38:41.027

237

votes

11

answers

Error on renaming database in SQL Server 2008 R2

sql sql-server sql-server-2008-r2

asked 2013-05-22T06:53:45.953

27

votes

4

answers

Getting count of records in child table using select statement

sql sql-server sql-server-2008 t-sql sql-server-2008-r2

asked 2013-05-15T08:44:38.510

19

votes

3

answers

SQL how to convert row with date range to many rows with each date

sql sql-server-2008-r2

asked 2013-05-03T12:29:17.690

13

votes

4

answers

How to set identity column to created table in SQL server

sql-server sql-server-2008-r2

asked 2013-04-24T09:24:54.117

8

votes

1

answers

Error 175: The specified store provider cannot be found in the configuration, or is not valid

.net visual-studio entity-framework sql-server-2008-r2

asked 2013-04-15T17:53:59.553

12

votes

4

answers

Combine consecutive date ranges

sql t-sql sql-server-2008-r2

asked 2013-04-03T09:17:08.910

9

votes

7

answers

How to divide two values from the same column in SQL

sql sql-server sql-server-2008-r2

asked 2013-03-14T03:05:20.920

18

votes

5

answers

Convert YYYYMMDD to DATE

sql sql-server sql-server-2008-r2

asked 2013-03-09T23:56:22.613

23

votes

10

answers

Getting a "one or more parameters required to run the report have not been specified" error

reporting-services sql-server-2008-r2

asked 2013-02-28T16:07:51.037

27

votes

5

answers

Passing dynamic order by in stored procedure

sql sql-server sql-server-2008-r2

asked 2013-02-26T09:11:16.320

16

votes

5

answers

Same number of columns for Union Operation

sql sql-server-2008-r2 union union-all

asked 2013-01-31T04:53:31.770

16

votes

1

answers

Cannot persist computed column - not deterministic

sql-server database sql-server-2008-r2 calculated-columns

asked 2013-01-02T15:19:11.753

9

votes

1

answers

SQL Server 2008 transactional replication 'Missing end comment mark '*/''

sql sql-server-2008-r2 comments replication transactional

asked 2012-12-13T14:56:49.020

48

votes

2

answers

Collation Error

sql sql-server-2008-r2

asked 2012-12-09T08:25:02.150

27

votes

7

answers

Want to create a script to export Data and tables and views to a sql script

sql-server sql-server-2008-r2

asked 2012-12-07T17:27:31.467

16

votes

2

answers

Where clause on subquery statement in select

sql sql-server-2008-r2

asked 2012-11-06T23:29:31.257

10

votes

2

answers

SQL Server Management Studio - Server Names Disappeared

sql-server-2008-r2 ssms sql-server-2008

asked 2012-10-25T13:38:55.687

16

votes

3

answers

Clarification as to why EXECUTE AS USER/LOGIN is not returning the expected results?

sql sql-server sql-server-2008 sql-server-2008-r2 ssms

asked 2012-10-23T19:34:39.113

28

votes

1

answers

Does SQL Server support IS DISTINCT FROM clause?

sql sql-server sql-server-2008 sql-server-2008-r2 distinct

asked 2012-09-17T09:44:44.637

12

votes

7

answers

Drop all extended properties on SQL Server

sql-server sql-server-2008 sql-server-2005 sql-server-2008-r2

asked 2012-09-11T11:14:56.640

30

votes

4

answers

IIF(...) not a recognized built-in function

sql sql-server-2008 t-sql sql-server-2005 sql-server-2008-r2

asked 2012-08-20T09:18:51.327

9

votes

4

answers

How to determine which SSAS Cube is processing now?

sql-server-2008-r2 ssas olap

asked 2012-08-10T09:53:55.597

28

votes

9

answers

Find Column dependency

sql-server t-sql sql-server-2008 sql-server-2008-r2

asked 2012-08-01T23:49:16.517

12

votes

2

answers

Database is not accessible after 'taking it offline' process failed

sql sql-server sql-server-2008-r2

asked 2012-07-09T06:22:36.700

14

votes

3

answers

How to get SQLCMD to output errors and warnings only

sql sql-server sql-server-2008-r2 sqlcmd

asked 2012-06-28T11:04:45.043

20

votes

2

answers

SQL Server Management Studio Missing after 2008 R2 Install

sql-server-2008-r2

asked 2012-06-09T02:38:38.000

30

votes

2

answers

Search XML with a LIKE or similar full search operation

sql xml xpath sql-server-2008-r2

asked 2012-05-06T15:01:53.643

275

votes

14

answers

SQL Server Configuration Manager cannot be found

sql-server sql-server-2008 sql-server-2012 sql-server-2008-r2 sql-server-config-manager

asked 2012-03-23T18:40:41.823

14

votes

9

answers

How to get the list of active triggers on a database?

sql-server triggers sql-server-2008-r2

asked 2012-03-09T12:46:23.210

21

votes

9

answers

Why select Top clause could lead to long time cost

sql sql-server sql-server-2008-r2

asked 2012-03-08T11:30:52.667

9

votes

1

answers

How to have analysis service up and running in SQL Server Express Edition

sql sql-server sql-server-2008-r2 analysis

asked 2012-03-06T16:40:06.360

13

votes

1

answers

What is the difference between being db_owner vs. db_datareader / db_datawriter?

security sql-server-2008-r2

asked 2012-02-02T17:30:22.263

16

votes

8

answers

Why only some users get the error: "Connection is busy with results for another command"

sql-server delphi database-connection sql-server-2008-r2

asked 2012-01-26T11:10:19.440

11

votes

3

answers

Automatically generate a user defined table type that matches an existing table

sql sql-server-2008 t-sql sql-server-2008-r2

asked 2012-01-20T18:31:35.837

9

votes

5

answers

Execution plan over query with temp tables

sql-server sql-server-2008-r2 sql-execution-plan

asked 2012-01-11T16:29:00.403

63

votes

9

answers

How to find out what is locking my tables?

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

asked 2012-01-05T20:36:50.110

10

votes

1

answers

select top 10 ... and select top 30 follows different execution plan

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

asked 2011-11-17T16:14:54.590

12

votes

3

answers

How should I return an int from a stored procedure in entity framework 4.1?

c# stored-procedures entity-framework-4.1 sql-server-2008-r2

asked 2011-11-15T15:05:54.410

31

votes

5

answers

INSERT IF NOT EXISTS but return the identity either way

sql sql-server sql-server-2008-r2

asked 2011-11-06T21:01:49.187

48

votes

2

answers

SQL Server: Could not find type in the assembly

sql-server sql-server-2008-r2 user-defined-functions sqlclr

asked 2011-10-19T15:08:31.470

12

votes

9

answers

Password mismatch while logging to sql server

sql sql-server asp-classic sql-server-2008-r2

asked 2011-10-19T04:28:45.987

53

votes

2

answers

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

triggers sql-server-2008-r2

asked 2011-09-08T14:02:01.833

25

votes

3

answers

determining the character set of a table / database?

sql-server sql-server-2008-r2 collation

asked 2011-09-06T14:00:19.413

24

votes

7

answers

Fastest way to find string by substring in SQL?

sql sql-server full-text-search query-optimization sql-server-2008-r2

asked 2011-07-11T14:45:27.817

Questions tagged sql-server-2008-r2