Skip to main content
Eric Humphrey - lotsahelp's user avatar
Eric Humphrey - lotsahelp's user avatar
Eric Humphrey - lotsahelp's user avatar
Eric Humphrey - lotsahelp
  • Member for 13 years, 5 months
  • Last seen more than 4 years ago
70 votes
Accepted

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

63 votes
Accepted

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

62 votes

How do you document your databases?

31 votes
Accepted

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

18 votes

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

14 votes

Find Queries that Are Causing Waits

11 votes
Accepted

Needing A Database Design Book

10 votes

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

10 votes
Accepted

How to restore multiple backups

10 votes

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

9 votes
Accepted

Shouldn't SQL Server Support RANGE?

9 votes
Accepted

Is my function nondeterministic one

9 votes

Should dbo schema be avoided?

8 votes

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

8 votes
Accepted

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

8 votes

A database for digital assets

7 votes

PostgreSQL CREATE TABLE error

7 votes
Accepted

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

6 votes
Accepted

How do I replace this where clause with a join?

6 votes

Oracle SQL - CASE in a WHERE clause

6 votes

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

6 votes

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

6 votes
Accepted

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

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?

5 votes

How does NHibernate handle execution plan?

5 votes
Accepted

New Job and Company uses PostgreSQL

5 votes
Accepted

Multi-database object-oriented proxy

5 votes

What learning resources are there for part-time DBAs?

5 votes
Accepted

TOP X of SQL Server in MySQL Analog

4 votes
Accepted

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