Questions tagged [sql-server]

219

votes

13

answers

Select SQL Server database size

asked 2013-08-02T10:12:40.090

12

votes

5

answers

Invalid Object Name Error in Function in SQL

asp.net sql sql-server

asked 2013-07-31T10:21:58.740

24

votes

2

answers

Setting a variable date in SQL

sql sql-server variables date ssms

asked 2013-07-30T20:05:55.803

8

votes

3

answers

Convert rows to columns after counting

sql sql-server sql-server-2008

asked 2013-07-26T07:15:33.030

10

votes

5

answers

Counting number of records for specific ranges sql server

sql sql-server coldfusion

asked 2013-07-23T14:38:21.840

35

votes

13

answers

Update one of 2 duplicates in an sql server database table

sql sql-server

asked 2013-07-22T09:23:00.560

48

votes

3

answers

What is the practical use of timestamp column in sql server with example?

sql-server

asked 2013-07-21T02:54:53.280

8

votes

4

answers

How to convert Float to Varchar in SQL

sql sql-server t-sql

asked 2013-07-20T09:54:44.127

8

votes

4

answers

Exporting SQL Server Table to multiple part files

sql sql-server database hive bcp

asked 2013-07-13T16:51:08.530

142

votes

4

answers

How to make a query with group_concat in sql server

sql-server string-aggregation sql-server-group-concat

asked 2013-07-11T10:54:00.877

11

votes

7

answers

SQL Server Copying tables from one database to another

sql sql-server data-migration

asked 2013-07-11T00:03:49.267

8

votes

2

answers

Database Design : Is it a good idea to combine two tables with the same columns and too many data?

sql-server sql-server-2008 database-design

asked 2013-07-08T06:04:52.053

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

16

votes

2

answers

Stored procedure slower when called from ASP.NET vs. SQL Mgmt Admin

c# sql-server performance

asked 2013-06-28T12:12:26.590

11

votes

6

answers

Return rows in the exact order they were inserted

sql sql-server

asked 2013-06-27T14:21:20.703

44

votes

6

answers

Check if a column contains text using SQL

sql sql-server t-sql

asked 2013-06-26T14:00:59.880

13

votes

3

answers

Database insert error: "string or binary data would be truncated"

c# asp.net sql-server ado.net

asked 2013-06-26T05:58:58.760

18

votes

7

answers

Order By month and year in sql with sum

sql sql-server

asked 2013-06-24T08:44:22.817

10

votes

2

answers

Selecting specific row number in sql

sql sql-server

asked 2013-06-23T10:14:04.930

9

votes

1

answers

creating a new server in SQL Management studio 2012

sql-server ssms

asked 2013-06-21T19:17:22.583

9

votes

1

answers

subquery - how to refer to outer query value

sql sql-server subquery

asked 2013-06-17T04:15:46.087

9

votes

2

answers

while loop inside a trigger to loop through all the columns of table in sql

sql-server t-sql triggers

asked 2013-06-11T18:16:47.290

64

votes

6

answers

My Select SUM query returns null. It should return 0

sql sql-server

asked 2013-06-11T15:44:08.333

13

votes

1

answers

How to find the boundaries of groups of contiguous sequential numbers?

sql-server sql-server-2008 gaps-and-islands

asked 2013-06-11T14:08:13.663

23

votes

2

answers

Not retrieving schema list from source when migrating from MSSQL to MySQL using Workbench

mysql sql-server mysql-workbench migrate

asked 2013-06-11T07:30:44.177

25

votes

6

answers

Query all table data and index compression

sql-server sql-server-2012

asked 2013-06-07T15:59:21.780

57

votes

2

answers

SQL recursive query that gets all ancestors of an item

sql sql-server

asked 2013-05-25T11:31:10.463

93

votes

2

answers

Is it necessary to use # for creating temp tables in SQL server?

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

asked 2013-05-25T11:25:30.020

10

votes

2

answers

How to add a dash to pattern matching

sql-server

asked 2013-05-24T19:11:17.410

15

votes

7

answers

Very slow DELETE query

sql sql-server performance sql-execution-plan table-variable

asked 2013-05-23T12:59:55.473

12

votes

1

answers

xml-sql: update multiple nodes

sql-server xml

asked 2013-05-23T11:32:51.487

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

288

votes

6

answers

How to create a table from select query result in SQL Server 2008

sql sql-server sql-server-2008

asked 2013-05-22T04:57:38.890

57

votes

15

answers

SQL Query to find the last day of the month

sql-server sql-server-2005 date datetime

asked 2013-05-20T09:37:20.507

15

votes

4

answers

sql rounding up to a multiple of 5?

sql sql-server t-sql

asked 2013-05-16T16:15:46.753

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

13

votes

4

answers

DateCreated or Modified Column - Entity Framework or using triggers on SQL Server

sql-server entity-framework triggers

asked 2013-05-15T00:17:19.090

16

votes

2

answers

Entity Framework and CROSS/OUTER APPLY

sql sql-server entity-framework cross-apply outer-apply

asked 2013-05-11T19:35:37.797

11

votes

2

answers

Where clause when using XML in SQL

sql sql-server xml sql-server-2012

asked 2013-05-10T14:26:06.750

16

votes

1

answers

Convert SQL geography to C#

c# sql-server t-sql sqlgeography

asked 2013-05-09T07:10:27.223

21

votes

5

answers

Login failed for user 'IIS APPPOOL\myAppPool

asp.net sql-server iis-7

asked 2013-05-07T19:48:15.737

66

votes

6

answers

Does Sql JOIN order affect performance?

sql sql-server

asked 2013-05-03T14:07:03.363

15

votes

4

answers

Check if value is date and convert it

sql sql-server sqldatetime

asked 2013-05-03T07:02:41.663

14

votes

5

answers

Multithreaded caching in SQL CLR

c# sql-server multithreading caching sqlclr

asked 2013-04-30T15:28:22.920

11

votes

2

answers

Get all employee who directly or indirectly reports to an employee, with hierarchy level no

sql sql-server foreign-keys iteration primary-key

asked 2013-04-26T08:56:25.490

161

votes

2

answers

Is there a ternary conditional operator in T-SQL?

sql-server t-sql

asked 2013-04-25T08:21:08.137

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

21

votes

2

answers

SQL Server : left join results in fewer rows than in left table

sql sql-server left-join

asked 2013-04-20T04:27:15.603

9

votes

2

answers

SQL Azure - Failed Connections - But no problems?

sql-server entity-framework azure azure-sql-database

asked 2013-04-19T17:04:58.967

45

votes

5

answers

Cannot find the user '', because it does not exist or you do not have permission

sql-server t-sql sql-server-2005 stored-procedures

asked 2013-04-16T15:06:41.443

Questions tagged sql-server