Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
3
Newest
 Supporter
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Apr
30
comment Improve SQL Performance with LIKE '%ABC%' QUERY
Of course if you only care about whether the column starts or ends with 'ABC' then there are techniques to turn this into an Index seekable operation.
Apr
30
comment Improve SQL Performance with LIKE '%ABC%' QUERY
Is there an index on the Name column. Although the query can't lookup in an index due to non Sargability, this could still speed up the query as the more rows will fit on the index pages thus speeding up the scan?
Sep
1
comment What do cursors do internally?
@AaronBertrand example using while loop instead of recursive cte here sqlfiddle.com/#!6/c5fd8/12/0
Sep
1
comment What do cursors do internally?
@AaronBertrand I will try and come up with an example, but I'm thinking of a while loop used instead of a recursive CTE. I should state that I believe that you should try to avoid both cursors and while loops.
Aug
29
comment What do cursors do internally?
A while loop is not always exactly the same as a cursor. A cursor always accesses one row at a time whereas a sql statement within a while loop can potentially still be set based, for instance all rows where level=1 then all rows where level=2 etc.
Aug
5
comment Selecting from an excel spreadsheet into SQL Server table
you appear to be writing to #mytemptable then you try to select from ##mytemptable. I guess you want ##mytemptable in both places
Nov
16
awarded  Supporter
Oct
30
awarded  Revival
Oct
30
awarded  Teacher
Oct
30
answered Slow Performance Inserting Few Rows Into Huge Table