Alex Rivera | Logout

Questions tagged sql-server-2008

405 questions · page 1 of 9

Sort by: Newest Votes Active
219
votes
13
answers

Select SQL Server database size

sql sql-server sql-server-2008 sql-server-2008-r2
asked 2013-08-02T10:12:40.090
8
votes
3
answers

Convert rows to columns after counting

sql sql-server sql-server-2008
asked 2013-07-26T07:15:33.030
51
votes
8
answers

SQL ignore part of WHERE if parameter is null

sql database sql-server-2008 stored-procedures
asked 2013-07-25T06:36:12.553
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
11
votes
6
answers

How to avoid Duplicate values for INSERT in SQL?

sql sql-server-2008
asked 2013-07-03T08:12:49.847
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
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
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
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
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
30
votes
3
answers

How to find Full-text indexing on database in SQL Server 2008?

sql-server-2008 full-text-search
asked 2013-04-29T14:14:57.297
8
votes
2
answers

using if statement how to replace values

sql sql-server-2008 if-statement sql-update case
asked 2013-04-13T05:23:43.730
8
votes
2
answers

SQL Server Create Table with Foreign Key

sql sql-server sql-server-2008
asked 2013-04-10T22:26:13.040
9
votes
2
answers

Is moving a constraint into a join more efficient than join and a where clause?

sql-server sql-server-2008 t-sql
asked 2013-04-02T21:37:09.860
8
votes
2
answers

How to speed up integration tests using SQL Server Dev Edition

sql-server-2008 unit-testing c#-4.0 nunit resharper
asked 2013-04-01T21:22:00.850
8
votes
1
answers

How to find which OLE provider is available for SQL Server?

sql sql-server-2008 t-sql oledb linked-server
asked 2013-03-15T14:19:44.193
16
votes
1
answers

Multiple condition in single IF statement

sql sql-server sql-server-2008
asked 2013-03-15T10:29:48.427
8
votes
4
answers

Refine Search SQL with Custom Pagination

c# asp.net sql sql-server sql-server-2008
asked 2013-03-02T06:34:52.000
10
votes
4
answers

Language which compiles to t-sql

sql-server sql-server-2008 t-sql dsl
asked 2013-03-01T20:18:55.937
13
votes
6
answers

Using DATEADD with bigints

sql sql-server sql-server-2008
asked 2013-02-22T18:05:23.027
37
votes
5
answers

How to disable Constraints for all the tables and enable it?

sql-server sql-server-2008 foreign-keys constraints foreign-key-relationship
asked 2013-02-20T05:21:09.577
15
votes
6
answers

How to get running sum of a column in sql server

sql sql-server sql-server-2008 select
asked 2013-02-19T08:50:10.673
11
votes
9
answers

SQL Performance, .Net Optimizations vs Best Practices

c# .net sql-server asp.net-mvc sql-server-2008
asked 2013-02-13T22:23:48.513
17
votes
3
answers

SQL Comma separated string total count

string sql-server-2008 count
asked 2013-02-11T18:35:04.470
11
votes
3
answers

Detecting SQL Server Utilization with a query

sql sql-server database sql-server-2008 rdbms
asked 2013-02-08T15:48:35.270
261
votes
11
answers

How do I do multiple CASE WHEN conditions using SQL Server 2008?

sql sql-server-2008
asked 2013-01-31T16:51:44.313
9
votes
2
answers

Using Sumif in SQL Server2008

sql sql-server-2008
asked 2013-01-30T20:46:47.617
129
votes
4
answers

How to enable Ad Hoc Distributed Queries

sql sql-server-2008
asked 2013-01-27T03:48:05.430
11
votes
1
answers

Passing a user-defined table type between SQL Server database

sql-server sql-server-2008 user-defined-types
asked 2013-01-24T15:21:16.923
42
votes
5
answers

Want to learn more on NTILE()

sql sql-server sql-server-2008 t-sql
asked 2013-01-16T09:43:10.530
11
votes
5
answers

Prevent SQL Injection in ORDER BY clause

c# sql-server-2008 sql-order-by sql-injection
asked 2013-01-14T11:10:02.063
13
votes
2
answers

How to attach MDF with no log file?

sql sql-server sql-server-2008
asked 2013-01-09T23:20:20.197
16
votes
4
answers

Replacing leading characters in string

sql sql-server sql-server-2008
asked 2013-01-08T14:14:03.513
29
votes
6
answers

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

sql web-services sql-server-2008 https
asked 2013-01-05T10:35:06.093
15
votes
3
answers

SQL select multiple rows in one column

sql sql-server sql-server-2008 t-sql
asked 2012-12-28T06:01:16.320
8
votes
2
answers

SQL - How to find what actions are using all of the max concurrent connections

sql sql-server sql-server-2008
asked 2012-12-19T16:04:01.360
9
votes
2
answers

Can I access more than one table via the same DataContext object simultaneously?

c# .net sql-server-2008 datacontext
asked 2012-12-19T12:11:34.277
14
votes
1
answers

Dropping/ Disabling index is better in sql server

sql-server-2008 indexing
asked 2012-12-18T17:59:46.903
44
votes
4
answers

SQL Server 2008 thousands separator for a column

sql sql-server database sql-server-2008 t-sql
asked 2012-12-13T10:01:24.017
8
votes
2
answers

Query global temp table on a linked server

sql-server sql-server-2008 distributed-transactions
asked 2012-12-03T22:49:56.240
21
votes
3
answers

SQL query to split column data into rows

sql sql-server sql-server-2008 t-sql
asked 2012-11-23T10:50:05.067
8
votes
4
answers

SQL Server 2008: I/O Wait Time per Database File

sql sql-server sql-server-2008
asked 2012-11-22T09:20:03.100
9
votes
2
answers

MERGE vs TRUNCATE and INSERT

sql-server sql-server-2008
asked 2012-11-15T06:51:28.417
130
votes
8
answers

Add a column to a table with a default value equal to the value of an existing column

sql sql-server-2008
asked 2012-11-06T11:21:52.243
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
22
votes
6
answers

Compare values of two columns then select the larger value

sql sql-server-2008
asked 2012-10-24T20:42:15.887
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
36
votes
14
answers

Cumulating value of current row + sum of previous rows

sql sql-server sql-server-2008 cumulative-sum
asked 2012-10-01T07:01:02.897
11
votes
4
answers

Selecting Values From a table as Column Headers

sql sql-server sql-server-2008 t-sql pivot
asked 2012-09-27T10:46:28.530
page 1 of 9 Next →