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

4 votes

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

answered Feb 23, 2011 at 3:40

4 votes

Passing array parameters to a stored procedure

answered Jan 14, 2011 at 19:39

4 votes

How to implement paging in an effective way?

answered Mar 3, 2011 at 18:49

4 votes

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

answered Mar 16, 2011 at 18:29

4 votes

Understanding MS SQL Server encryption and backups

answered Sep 26, 2012 at 20:29

4 votes

Sleeping SPID blocking other transactions

answered May 7, 2013 at 20:12

3 votes

Remove field from composite key and collate duplicate data

answered Jan 19, 2011 at 18:35

3 votes

Are there any database engines which will intuit the join condition based on the existing foreign keys?

answered Jan 10, 2011 at 22:34

3 votes

How to insert multiple records using XML in SQL server 2008

answered Feb 28, 2011 at 19:01

2 votes

How can I track database dependencies?

answered Feb 3, 2011 at 23:35

2 votes

Accepted

google database api

answered Feb 7, 2011 at 11:40

2 votes

Did anybody use sqlcmd mode in practice?

answered Jan 10, 2011 at 21:42

2 votes

Inserting and updating and selecting at thousands of times per second

answered Jan 22, 2011 at 2:06

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

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

1 vote

SQL index with additional includes

answered Dec 7, 2011 at 17:23

1 vote

FIFO queue table for multiple workers in SQL Server

answered Jul 5, 2012 at 0:58

1 vote

Add credentials & set a specific role for a database

answered Mar 3, 2011 at 13:18

1 vote

Why does SSRS not update a report's description?

answered Feb 21, 2018 at 22:26

1 vote

How to restore database using old full backup and current log file

answered Jan 26, 2011 at 11:18

1 vote

Is there any benefit of a primary key that comprises all columns of the table?

answered Jan 21, 2011 at 14:23

1 vote

Why does this Entity Framework query perform so bad in MySQL?

answered Jan 21, 2011 at 21:25

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

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

0 votes

Need to understand the security flaw?

answered Dec 3, 2019 at 1:25

0 votes

Migration from SQL Server 2008 to Postgres 9.2

answered Jan 30, 2014 at 17:21

0 votes

Accepted

Can't run query using "localhost\sqlexpress"

answered Dec 6, 2011 at 17:35

0 votes

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

answered Dec 7, 2011 at 13:45

0 votes

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

answered Dec 9, 2011 at 14:45

2