Eric Humphrey - lotsahelp

less info
3,385 reputation
621
bio website erichumphrey.com
location Fort Worth, TX
age 33
visits member for 2 years, 4 months
seen yesterday
stats profile views 164

I'm the database administrator for Six Flags Entertainment. I specialize in SQL Server with experience in several different programming languages and database platforms.

I am passionate about the SQL and .NET developer communities. I enjoy presenting SQL related topics and enticing users to see what is possible with technology.

You can also find me on Twitter via @lotsahelp


May
7
answered sleeping SPID blocking other transactions
Apr
7
awarded  Notable Question
Jan
10
awarded  Yearling
Oct
18
awarded  Taxonomist
Sep
26
answered Understanding MS SQL Server encryption and backups
Sep
21
awarded  Custodian
Sep
3
awarded  Nice Answer
Aug
7
comment Mapped drive for Microsoft SQL Server 2008
Why backup to a mapped drive when you can just backup to a UNC path directly?
Jul
5
comment Can I prove my database does not have memory issues?
If the transition from slow to fast was very rapid, then you most likely have out of date statistics. If it was a slow degrade, then it could be fragmented indexes.
Jul
5
answered FIFO queue table for multiple workers in SQL Server
Jun
17
awarded  Nice Answer
Apr
29
awarded  sql-server
Mar
1
awarded  Popular Question
Feb
10
awarded  Good Answer
Jan
10
awarded  Yearling
Jan
10
awarded  Announcer
Dec
9
answered SQL Server 2008 - Log file out of control & cant shrink it
Dec
9
comment SQL Server 2008 - Log file out of control & cant shrink it
Run DBCC OPENTRAN and see if there are any open transactions that are holding onto the log file.
Dec
9
comment SQL Server 2008 simple recovery mode issue
As a followup, please read the following blog posts: sqlskills.com/BLOGS/PAUL/category/Misconceptions.aspx
Dec
9
comment How to monitor how much data is transfered in a linked server?
Unfortunately, I won't be of much help on that question.