HLGEM's user avatar
HLGEM's user avatar
HLGEM's user avatar
HLGEM
  • Member for 12 years, 2 months
  • Last seen more than 5 years ago
  • Virginia, United States
11 votes

EF Code First uses nvarchar(max) for all strings. Will this hurt query performance?

-1 votes

How to migrate data between "all-surrogate" databases?

1 vote

Is this a good strategy for importing a large amount of data and decomposing as an ETL?

3 votes

Find procedures that haven't been called in <n> days

6 votes

Is it worth to separate columns into multiple tables for one-to-one relational table

1 vote

SQL Server transaction log growing without control

2 votes

Left Join not giving desired result

1 vote

MySQL: Join one Row in a table with two Rows in other table

20 votes

Why are constraints applied in the database rather than the code?

1 vote

SQL Server BULK INSERT

2 votes

SSIS keeps force changing excel source string to float

6 votes

Foreign keys - link using surrogate or natural key?

2 votes
Accepted

New Database vs New Table for User Registrations

0 votes

Database Design Regarding a Relationship for Patient Visit

3 votes
Accepted

Database Design question, calculate or save financial positions

2 votes

PRIMARY KEY CONSTRAINT fundamentals

1 vote

Right Join vs Left Join - My joins are broken and I don't understand why

1 vote

Large time difference between two almost identical simple queries....why?

2 votes

Best practices for history/temporal tables?

0 votes

SSIS Validation slow. OLTP OLAP running on same server

9 votes

How could DBAs be more 'programmer friendly'?

2 votes

How to have a one-to-many relationship with a privileged child?

7 votes
Accepted

How to handle huge table

5 votes

How to avoid using the IN clause in sql query used in a stored procedure

0 votes

Inserting rows into other table whilst preserving IDENTITY

0 votes

SQL Server 2000 performance

1 vote

Performance on SQL Join

11 votes
Accepted

Is a surrogate key better than a natural key in this case

1 vote

tempdb usage in SQL Server

0 votes

How do I write portable SQL that refers to a linked server?