A new MSDN thread question prompted me to write a new variation of my original blog post 'How to search a string value in all columns in all tables in a database'.
This blog will show how to search for an integer value in all integer (smallint, tinyint, int, bigint) columns in all tables in the dat......

One of the common questions I encounter in the different SQL related forums is "How to search all columns in all tables in the database". My usual answer is to refer people to the Question #2 in this blog The ten most asked SQL Server questions. However, the recent thread in MSDN forum forced me to ......

When I wrote my first article with the same name here, Interesting T-SQL problems, I was thinking it will be a weekly series. However, as it often happens, not all intentions become a reality.So, about a month and a half later, I want to discuss a few problems I encountered in different forums durin......

Jacob asked me to write some explanations regarding my solution for challenge 17. First I'd like to say, that this challenge is the only one I participated so far. Usually if I look at the problem and see the possible solutions, I then try to crack it, otherwise I may not even attempt to solve the p......

I want to discuss a problem I am sure many of us encountered at least once in our life. I myself made this common mistake at least two times before I learned it by heart and now can easily recognize and point others to it. Let's consider this typical life scenario - bring all customers and their ord......