| 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. |