263 reputation
39
bio website jeremyaboyd.com
location Houston, TX
age 26
visits member for 3 years, 7 months
seen 3 hours ago

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


9h
revised Multi-Column Full Text Search Going Very Slow
added 99 characters in body
9h
asked Multi-Column Full Text Search Going Very Slow
17h
awarded  Popular Question
Jul
2
awarded  Curious
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