Reputation
Next tag badge:
576/400 score
78/80 answers
Badges
8 104 164
Newest
 Nice Answer
Impact
~1.6m people reached

2h
comment Why are schema changes I've made reverting?
Either the changes aren't getting made in the first place - e.g. (1) You're applying them in a transaction and not committing it. (2) You're applying them somewhere else such as another instance of the database by mistake - or someone is overwriting them - e.g. restore backup or publishing old project version from SSDT that doesn't incorporate your changes.
2h
comment Multi-statement TVF vs Inline TVF Performance
@sp_BlitzErik - I don't find that. Using the scalar UDF from here + schemabinding and a #Words table that happens to have 7,569 rows in it. These were the stats for the UDF i.stack.imgur.com/4GTuu.png and for the inline TVF with FORCESEEK i.stack.imgur.com/7GlBI.png (Numbers table had 1 million rows and all STATISTICS and execution plan options switched off apart from client statistics)
5h
revised Separate letters from digits in alphanumeric string
added 144 characters in body
5h
revised Separate letters from digits in alphanumeric string
added 144 characters in body
5h
revised Separate letters from digits in alphanumeric string
added 187 characters in body
6h
revised Separate letters from digits in alphanumeric string
deleted 1 character in body
6h
answered Separate letters from digits in alphanumeric string
6h
revised Test if a string is a palindrome using T-SQL
added 62 characters in body
7h
revised Multi-statement TVF vs Inline TVF Performance
added 39 characters in body
7h
revised Multi-statement TVF vs Inline TVF Performance
added 322 characters in body
8h
revised Multi-statement TVF vs Inline TVF Performance
added 137 characters in body
8h
answered Multi-statement TVF vs Inline TVF Performance
12h
reviewed Approve Separate letters from digits in alphanumeric string
14h
revised Difference between clustered index seek and non clustered index seek
edited title
23h
comment Rules related to Transaction count
@AaronBertrand I don't disagree. This example shows that the potential outcomes might not always be obvious though and so supports the practice.
23h
answered Rules related to Transaction count
1d
comment Does anyone know where the SQL Server Connection Properties are stored?
I suspect this is stored on a file on your local machine rather than a database.
1d
revised Display both null and not null under same id but not both null or not null like XOR logic
Fixed some issues
1d
revised Test if a string is a palindrome using T-SQL
added 798 characters in body
1d
awarded  Nice Answer