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

14 votes

Find Queries that Are Causing Waits

answered Mar 4, 2011 at 21:39

0 votes

Need to understand the security flaw?

answered Dec 3, 2019 at 1:25

1 vote

Why does SSRS not update a report's description?

answered Feb 21, 2018 at 22:26

62 votes

How do you document your databases?

answered Jan 11, 2011 at 14:10

62 votes

Accepted

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

answered Jan 26, 2011 at 18:46

1 vote

FIFO queue table for multiple workers in SQL Server

answered Jul 5, 2012 at 0:58

0 votes

Migration from SQL Server 2008 to Postgres 9.2

answered Jan 30, 2014 at 17:21

1 vote

Add credentials & set a specific role for a database

answered Mar 3, 2011 at 13:18

4 votes

Sleeping SPID blocking other transactions

answered May 7, 2013 at 20:12

4 votes

Understanding MS SQL Server encryption and backups

answered Sep 26, 2012 at 20:29

0 votes

SQL Server 2008 - Log file out of control & cant shrink it

answered Dec 9, 2011 at 14:45

9 votes

Should dbo schema be avoided?

answered Dec 7, 2011 at 20:07

1 vote

SQL index with additional includes

answered Dec 7, 2011 at 17:23

2 votes

how to Export a document contain tables name, columns names and column description from SQL Server 2008?

answered Dec 7, 2011 at 15:25

0 votes

How to monitor how much data is transfered in a linked server?

answered Dec 7, 2011 at 13:45

0 votes

Accepted

Can't run query using "localhost\sqlexpress"

answered Dec 6, 2011 at 17:35

5 votes

Accepted

New Job and Company uses PostgreSQL

answered Dec 5, 2011 at 20:07

5 votes

How does NHibernate handle execution plan?

answered Mar 23, 2011 at 18:26

4 votes

Which problems arise, declaring the size of all varchar parameters as max in stored proc?

answered Mar 16, 2011 at 18:29

2 votes

Powershell-type SQL Agent Job failing intermittently trying to get Disk Space on Server via WMI-query

answered Mar 11, 2011 at 19:54

4 votes

How to implement paging in an effective way?

answered Mar 3, 2011 at 18:49

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

3 votes

How to insert multiple records using XML in SQL server 2008

answered Feb 28, 2011 at 19:01

7 votes

PostgreSQL CREATE TABLE error

answered Feb 27, 2011 at 16:46

11 votes

Accepted

Needing A Database Design Book

answered Feb 24, 2011 at 14:24

1 vote

Powershell-type SQL Agent Job failing intermittently trying to get Disk Space on Server via WMI-query

answered Feb 23, 2011 at 14:09

4 votes

Is there a non-DDL way to preserve back-references when staging data into production?

answered Feb 23, 2011 at 3:40

8 votes

A database for digital assets

answered Feb 20, 2011 at 2:49

1 vote

What is the best way to find out how many records do not have a proper phone number in SQL Server?

answered Feb 18, 2011 at 4:59

1