Profile cover photo
Profile photo
Alan Burstein
Data and SQL Enthusiast
Data and SQL Enthusiast
About
Alan's posts

Post has attachment

Post has attachment
Looking for a Nasty Fast alternative to PERCENT_RANK? Check out my article on +SQLServerCentral. #sqlserver   #sqlperformance   #WindowFunctions   #RankingFunction  

Post has attachment
Just more good RBAR-free, set-based, high-performing string manipulation functions.

Post has attachment
PatReplace8K has been updated and is even faster. #TallyTable   #SetBased   #SQLStringFunctions  

Post has attachment
Great Paul White article

Post has attachment

Post has attachment
This is the best way to remove repeated spaces. Period!

Post has attachment
This is hands-down the best summary of Big Data I have ever read. If you are new to Big Data or looking for an article that clearly explains it then this is the article for you!

#bigdata #datascience #analytics #Hadoop #google #sql #mapreduce

Post has attachment

Post has attachment
PatReplace for SQL Server! Whoohoo. #sqlserver   #strings   #tallytable  
Wait while more posts are being loaded