Category Archives: Joy of T-SQL
Well, I published new article about how to tune the performance for LIKE wildcard queries… Please navigate to this article on Microsoft TechNet Wiki I’ll also publish it on this blog soon! 🙂
The follow text is copied from this blog: Official Blog of TechNet Wiki Using Error Handling within the Transact SQL language needs a deep knowledge. It depends on the SQL Server version, there are various implementations for handling the … Continue reading
March 19, 2015 9:45 PM GMT Saeid Hasani Structured Error Handling in SQL Server The goal of this session is to provide a simple and easy to use error handling mechanism with minimum complexity. This session is compatible … Continue reading
I added the article which comes from a question that asked in MSDN forum. The problem is how to delete all rows from a table but remain the Top (N) rows, for example, remaining only the top (1000) rows. All Code samples … Continue reading
My last article is providing in depth tutorial about these statements: ISNULL COALESCE IIF CHOOSE The main purpose of introducing these statements is improving code readability and achieving cleaner code. Using these statements may result to poor performance in some … Continue reading
This post is came up from a MSDN forum post that discussed last night . Problem was to write CASE in ORDER BY cluase without using dynamic sql. This is my solution that I just want to share it.
This is very simple to retrieve this data from “sysobjects”. Note that this query returns DML triggers in database.
One of the most powerful features in MSSQL SERVER is dynamic sql that has its own complexity. When we use this feature, it’s very important that we must know its limitations and correct usage of it. By design, we limit … Continue reading
Recently, I worked a lot with change tracking that’s new feature in Sql Server 2008. Now I just wanna share somethings about select changes at column level. Later, I will publish a very complete article about change tracking.