User Eric Humphrey - lotsahelp - Database Administrators Stack Exchange

Eric Humphrey - lotsahelp

Member for 12 years, 8 months
Last seen more than 3 years ago

Twitter
erichumphrey.com
Fort Worth, TX

59 Answers

Score Activity Newest

70 votes

Accepted

Is it okay to put dots in SQL Server database names?

answered Feb 10, 2011 at 20:46

62 votes

Accepted

How do I copy a table with SELECT INTO but ignore the IDENTITY property?

answered Jan 26, 2011 at 18:46

62 votes

How do you document your databases?

answered Jan 11, 2011 at 14:10

31 votes

Accepted

Is it better to store images in a BLOB or just the URL?

answered Jan 20, 2011 at 19:17

18 votes

When using an ORM, what are some things to watch out for in your database design

answered Jan 11, 2011 at 0:36

14 votes

Find Queries that Are Causing Waits

answered Mar 4, 2011 at 21:39

11 votes

Accepted

Needing A Database Design Book

answered Feb 24, 2011 at 14:24

10 votes

Is the ADO.NET Entity Framework known for generating poorly performing queries?

answered Feb 15, 2011 at 21:59

10 votes

Accepted

How to restore multiple backups

answered Feb 2, 2011 at 15:07

10 votes

What is a good way to store a large number of columns?

answered Jan 24, 2011 at 4:04

9 votes

Accepted

Shouldn't SQL Server Support RANGE?

answered Jan 24, 2011 at 1:06

9 votes

Accepted

Is my function nondeterministic one

answered Jan 20, 2011 at 14:19

9 votes

Should dbo schema be avoided?

answered Dec 7, 2011 at 20:07

8 votes

SQL Server 2005 : How to use pivot instead of a bunch of case statements?

answered Jan 25, 2011 at 17:21

8 votes

Accepted

How do you handle adding nullable columns to each other in a query?

answered Feb 2, 2011 at 20:35

8 votes

A database for digital assets

answered Feb 20, 2011 at 2:49

7 votes

PostgreSQL CREATE TABLE error

answered Feb 27, 2011 at 16:46

7 votes

Accepted

How-to implement an entity with an unknown maximum number of attributes?

answered Feb 14, 2011 at 12:37

6 votes

Accepted

How do I replace this where clause with a join?

answered Feb 14, 2011 at 16:44

6 votes

Oracle SQL - CASE in a WHERE clause

answered Feb 11, 2011 at 0:04

6 votes

LIKE to select the independent existence of the word whereever in the text

answered Feb 5, 2011 at 22:03

6 votes

Possible to run two DBCC INDEXDEFRAG commands simultaneously, each on a different table?

answered Jan 20, 2011 at 21:39

6 votes

Accepted

Is it possible to specify Active Directory username and password in connection string?

answered Mar 1, 2011 at 17:16

5 votes

Accepted

Is having a 92MB MDF with a 58MB LDF cobo ok? How do I manage the log to keep things running well?

answered Mar 1, 2011 at 17:12

5 votes

How does NHibernate handle execution plan?

answered Mar 23, 2011 at 18:26

5 votes

Accepted

New Job and Company uses PostgreSQL

answered Dec 5, 2011 at 20:07

5 votes

Accepted

Multi-database object-oriented proxy

answered Jan 20, 2011 at 14:25

5 votes

What learning resources are there for part-time DBAs?

answered Jan 10, 2011 at 21:54

5 votes

Accepted

TOP X of SQL Server in MySQL Analog

answered Feb 7, 2011 at 11:30

4 votes

Accepted

Best way to sync a table between two sql server databases with an identity key

answered Feb 3, 2011 at 18:47

1