I ended my last tip about triggers on the note 'Triggers should always be written to handle multiple rows'. I searched online for different methods people have been using on handling trigger based solutions and thought it would make a good learning t...

I think this was recently discussed here. Not sure it was posted in the "Interview" section though....

I was pretty sure only global temporary table could be accessed. You prove me wrong....

...

...

It's a good reminder, I'm sure people are willing to know all the basics as well as the more advanced topics. I totally went through that kind of SQL issue at some point in my life, newbie or not Guenter post is valuable....

I just stumbled across a weird misconception that I'd like to help you to avoid: If you consume the results of a (non-inline) table valued function, the results are not in the same order as if you take the content óf the TVF in your query. So, if yo...

I just stumbled across a weird misconception that I'd like to help you to avoid: If you consume the results of a (non-inline) table valued function, the results are not in the same order as if you take the content óf the TVF in your query. So, if yo...

I saw today, in someones code, something like this: GO 100 At first, I thought that was some typing mistake, but then I found that GO has not only function of ending batch, but also it can execute that batch many times, as specified in: GO...

I saw today, in someones code, something like this: GO 100 At first, I thought that was some typing mistake, but then I found that GO has not only function of ending batch, but also it can execute that batch many times, as specified in: GO...