Every day when I woke up there are hundreds of emails with various questions related to SQL. I spend my first hour of the day answer each of them. 62 more words
Tags » T-SQL
Today, we’re going to look at how to distribute values with what I call “overlapping ranges”. What I mean by that is that the value that you need to distribute has a given range and the objects you want to distribute the values to are also defined as ranges. 1,215 more words
Here is an interesting problem which I enjoyed solving yesterday.
There were multiple SQL Files in my one folder. When I had to send it to my friend I had to collect all the files into a folder and zip it to send it via email. 211 more words
277 more words
Definição MSDN: Especifica que as instruções não podem ler dados que foram modificados, mas que ainda não foram confirmados por outras transações. Isso impede leituras sujas.
Just like any business person, I work with Excel pretty much half of my time when I am not working with SQL Server. Recently I faced challenges when I wanted to extract domain from the email address. 137 more words