258 reputation
37
bio website jeremyaboyd.com
location Houston, TX
age 26
visits member for 3 years, 3 months
seen Dec 19 '13 at 17:43

I'm a small time web developer, trying to make it in this world filled with small time web developers. It seems everyone can make websites...


Jan
15
awarded  Notable Question
Sep
9
awarded  Notable Question
Feb
25
awarded  Popular Question
Nov
16
awarded  Popular Question
Jan
17
awarded  Yearling
Nov
11
accepted How to delete a Backup from a backup set in SQL Server 2008 R2
Nov
11
comment How to delete a Backup from a backup set in SQL Server 2008 R2
We ended up doing this, just stinks that we have to have a maintenance plan, and that the backupset can't handle that.
Nov
1
asked How to delete a Backup from a backup set in SQL Server 2008 R2
Sep
15
comment For every insert statement I see sp_executesql in SQL Server Profiler
So I can't get around this using parameterized inserts? Like... at all?
Sep
14
asked For every insert statement I see sp_executesql in SQL Server Profiler
Jun
27
accepted What is more efficient, a where clause or a join with million plus row tables?
Jun
24
asked What is more efficient, a where clause or a join with million plus row tables?
Jun
9
comment SELECT * WHERE VarCharColumn IN (…) Optimization
No but in a table where there isn't a second that a transaction isn't happening, nolock keeps you from deadlocking.
Jun
8
awarded  Supporter
Jun
8
comment SELECT * WHERE VarCharColumn IN (…) Optimization
@Marian, Where time is a factor, no one was able to get the SQL statement itself down to less than 1 minute for 3000 rows. We hired Microsoft, we hired $400/hr SQL consulting firms no one could do it with SQL. So I removed SQL from the equation and it worked. Faster and cheaper than anyone else.
Jun
8
accepted Checking for dupes on Compact Insert Statement
Jun
7
awarded  Scholar
Jun
7
accepted SELECT * WHERE VarCharColumn IN (…) Optimization
Jun
7
answered SELECT * WHERE VarCharColumn IN (…) Optimization
Jun
7
asked Checking for dupes on Compact Insert Statement