Reputation
649
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 7 14
Newest
 Yearling
Impact
~77k people reached

Dec
9
revised Reduce Size of SYSAUX
minor formatting
Dec
9
suggested approved edit on Reduce Size of SYSAUX
Nov
18
awarded  Yearling
Nov
2
comment How to find all positions of a string within another string
One minor issue might be the limitation of the output up to the recordcount of sys.all_objects for long strings.
Nov
2
comment How to find all positions of a string within another string
@Misiu as expected Aaron Bertrands solutions is not just more elegant but even much faster then mine and should be the accepted solution. You may test this easily with a bigger input, using his example just add SET @name=Replicate(@name,5000) before the call SELECT pos FROM dbo.FindPatternLocation(@name, 'ali'); and try the same with my slow procedure.
Aug
3
awarded  Constituent
Jul
27
awarded  Caucus
Jun
10
comment Duplicate records referenced across different databases
Hi Ralph are you connected with Dataladder in any way?
Jun
4
revised MySQL Aborted connection warning messages
some formatting
Jun
4
suggested approved edit on MySQL Aborted connection warning messages
Jun
1
comment MySQL incremental backups per database (not global)
Hi nima02, please take a look here
May
28
revised How to Retrieve data within nested select statement?
Removed the question part from the answer, it has been add to the question in an edit before
May
27
suggested approved edit on How to Retrieve data within nested select statement?
May
27
revised How to Retrieve data within nested select statement?
Removed question part from an answer of the OP and placed it into the question
May
27
comment Can't select 2 tables at the same time
Hi Vasque, please remove the solution from the question. You might add an own answer if you like and it differs from given solutions.
May
27
suggested approved edit on How to Retrieve data within nested select statement?
May
27
suggested rejected edit on How to Retrieve data within nested select statement?
Mar
18
revised Configuring slave from EC2 master to Amazon RDS slave
formatting
Mar
18
suggested approved edit on Configuring slave from EC2 master to Amazon RDS slave
Mar
16
revised Need help achieving HAProxy active/passive configuration for mysql
removed copy fragments