Using CASE statements is something I see a lot of developers use. They use it in complex environments and I have been fortunate to troubleshoot and look at code blocks that run for pages using the standard CASE statements. 369 more words
Tags » T-SQL
I am approaching my last day at my current job. I love it here and will be really sad to leave, but have an awesome opportunity to grow my knowledge and career with a company on my “want to work for” list. 272 more words
I have written tons of blogs in the past around using sparse columns. The best part and lesser known part of sparse columns is that we can write to the column sets directly too. 474 more words
Question: What is the difference between CHARINDEX vs PATINDEX?
Answer: We can use either CHARINDEX or PATINDEX to search in a TEXT field in SQL SERVER. 148 more words
Technology innovations over years have made personal computing and the infrastructure inside our datacenters even more powerful. Gone are the days when our laptops used to come with single processors and single cores. 441 more words