Tag: sql-server-2008

Found 1126 results for 'sql-server-2008'.

1) sql-server - Pros/Cons of using multiple databases vs using a single database
2) sql-server-2008 - Decision criteria on when to use a non-dbo schema vs a new Database
3) sql-server - Two Inner join on the same field to get same data
4) sql-server - Why is this Full Outer Join not working?
5) sql-server - SQL join query to show rows with non-existent rows in one table
6) sql-server - SQL Server equivalent of Oracle USING INDEX clause
7) sql-server - Is it possible to make a reference to the result of an aggregate function in a SELECT clause from the same SELECT clause?
8) sql-server - Distinct Children rows ordered by a column of Parent
9) sql-server-2008 - How to migrate from SQL Server 2000 to SQL Server 2008 R2 Express Edition
10) sql-server - How to import CSV file in SQL server 2008?
11) sql-server - Issue importing large file into SQL server
12) sql-server - Auto Update Statistics in SQL Server 2008R2: Why do some statistics remain stale despite a large number of row inserts?
13) sql-server - Why does my database structure and SELECT operations generate NULLs?
14) sql-server - Bitmask Flags with Lookup Tables Clarification
15) sql-server-2008 - How would you design a table for a booking system?
16) sql-server - SQL Server VARCHAR Column Width
17) sql - UPDATE and REPLACE part of a string
18) sql-server-2008 - Stored Procedure Consolidation
19) sql-server - Should dbo schema be avoided?
20) sql-server - What are some best practices for using schemas in SQL Server?
21) sql-server - How can I go about building a relationship with variable but ordered number of columns in a table?
22) sql-server - Separate archive tables or soft delete for inventory database
23) sql-server-2008 - Recommended hardware configuration Analysis and Reporting Services
24) sql-server - Remove punctuation marks, special chars and space and compare cols
25) sql-server - Add Check Constraint On Varchar Column to enforce no duplicates
26) sql-server - nvarchar(max) converting to varchar and table optimization
27) sql-server-2008 - varchar performance impact
28) sql-server - varchar storage and comparisons in SQL Server 2008
29) sql-server - Change column data type across database
30) sql-server-2008 - SSIS Connection String Expression at Run Time and during Execution
31) sql-server - SQL Server 2008 can't repair consistency
32) sql-server - Can a PRIMARY KEY constraint (with a NONCLUSTERED INDEX) check for only certain values?
33) sql-server - Are there any way to stop typing 'go' in sqlcmd?
34) sql-server - Delete from table where not in another table using two columns
35) sql-server - SSIS Merge component performing a UNION instead of merging
36) sql-server-2008 - Select the newest data (inner join + group by maybe)
37) sql-server-2008 - Simple Car Rental database
38) sql-server-2008 - Date alignment and pair matching extraction best done with TSQL or C#?
39) sql-server-2008 - Why is replication attempting to distribute NULL values into Identity columns
40) sql-server-2008 - Best way to write SQL Query that checks a column for non-NULL value or NULL
41) sql-server-2008 - Quickly change NULL column to NOT NULL
42) sql-server-2008 - In SQL Server 2008, how can I get all the columns that are marked as nullable in their schemas even though no records contain NULL for those columns?
43) sql-server - SQL Server : explicitly create an index on a primary key and unique fields
44) sql-server - Implications of using a Unique NonClustered Index with Covering Columns instead of a Primary Key
45) sql-server - Check if row exists
46) sql-server-2008 - How to create a trigger that update the date field and time field upon modify of the row?
47) sql-server - Inserting rows into other table whilst preserving IDENTITY
48) sql-server - How to check if a column exists in a SQL Server table
49) sql-server - Sync database table schema and stored procedures
50) sql-server - difference of left join and left outer join