Reputation
1,438
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 24
Newest
 Custodian
Impact
~89k people reached

Jun
26
awarded  Custodian
Jun
23
accepted Predicate not resulting in expected scan
Jun
23
comment Predicate not resulting in expected scan
@MartinSmith indeed it does.
Jun
23
comment Predicate not resulting in expected scan
@MartinSmith that's it!
Jun
23
comment Predicate not resulting in expected scan
If my recolection serves me correctly GETDATE() functions are calculated prior to runtime and therefore this does not apply. Also it is used in the first query and the Image date is used in that one.
Jun
23
asked Predicate not resulting in expected scan
Jun
16
revised How to pass parameter in select query(In with clause) and not in where condition in SQl Server SSIS Package?
added 1 character in body
Jun
16
answered How to pass parameter in select query(In with clause) and not in where condition in SQl Server SSIS Package?
Jun
16
comment Optimization issue with user defined function
@JamesZ it sound like you've got a developer to strangle.
Jun
12
comment Avoiding “Row by row” fetch method when dealing with source LOB columns
I echo @billinkc's thought. On the items that aren't VARCHAR(MAX) try creating a new ODBC Source and see if it changes your datatype.
Jun
3
comment What are the edges of typical (or specific) paid databases like oracle of mysql compared to the free oness?
@JimThio the idea that you're just going to pop over to MongoDB from MySQL leads me to beleive you might need to look into Mongo a little further.
May
29
comment SQL Server Agent Job, Access Denied
Can you clearify what you mean here "I have a T-SQL agent job that I've created that adds steps to itself depending on a query of the MSDB database." ?????
May
29
answered How can I determine which tables are causing the database to grow over time?
May
22
comment LDF files vs. TRN files vs. Tempdb.MDF+LDF files.:
I think we could probably get the just of this without your IP address.
May
22
comment Trace Flag 4199 - Enable globally?
Are you currently experiencing cardinality estimate issues or something?
May
21
revised What is the fastest way to insert large numbers of rows?
deleted 1 character in body
May
6
comment How to optimize a query so that it seeks on one index first, and then another index after that
What does your query plan look like if you remove those hints?
May
6
comment Issuing Inserts/Updates to Progress OpenEdge via ODBC
Wait are you trying to use a linked server query in SSIS?
May
4
revised Convert date in date list condition to list of date ranges
Added a proper DB tag.
May
4
suggested approved edit on Convert date in date list condition to list of date ranges