Tag: SQL

Why everyone wants to use Top 1?

Do NOT ever use Top 1 (MSSQL, MySQL) or First 1 (Firebird) if you’re not sure, how to use it properly. Developers, who use this construction, in most cases use it inappropriate way. Recently I’ve found 2 stored…

Read More »

One more fail at the interview

Finally I’ve understand, why one of my Interviews failed. Few months ago I was passing MSSQL interview and was asked about transactions and how should I handle it in MSSQL server. I knew about transactions and how to…

Read More »