(Eli Leiba) This article describes how to identify an update (Blocking) Lock by scheduling a job to run every few minutes and checks if a blocking lock on an object is held from the previous execution of the job to the current job execution. (R)

This article contains information about the bugs that are fixed by Microsoft SQL Server 2000 Service Pack 4 Beta. (SP4).

(Muthusamy Anantha Kumar) Automatic file growth in SQL Server data and log files made the SQL Server Database Administrator’s life easier, since the transaction log is not filled; it expands automatically based on the percentage settings [refer Fig 1.0]. However, this feature introduced the crisis o

(Cesar Cerrudo) This paper will not cover basic SQL syntax or SQL Injection. It is assumed that the reader has a strong understanding of these topics already. This paper will focus on advanced techniques that can be used in an attack on a (web) application utilizing Microsoft SQL Server as a bac

(Robert Marda) Sooner or later someone will ask you to include dates and/or times in a query or two. Sometime after you start using dates and/or times you will notice that data stored with the datetime data type doesn’t always react the way you expect in a query and that storing the date and time in

When you try to run an update statement, an insert statement, or a delete statement on a table in Microsoft SQL Server 2000 post-Service Pack 3 (SP3) hotfix build 8.00.818 or a later build, the trigger on the table is not successful. You receive the following error message (where yourTrigger is the

(Brad M. McGehee) When it comes to auditing index use in SQL Server databases, I sometimes get overwhelmed. For example, how to do you go about auditing indexes in a database with over 1,500 tables? While auditing a single index is relatively straight-forward, auditing thousands of them in multiple

(Serdar Yegulalp) SQL Server has two basic administrative options that control how much memory is used by the program: dynamic and static allocation. Dynamic allocation allows the administrator to declare a range of memory sizes; SQL Server can allocate up to the maximum amount of memory allowed for

(William Pearson) In this lesson, we will continue our examination of the IIF() function, which we began in my article String / Numeric Functions: Introducing the IIF() Function. In that introductory session, we explored the IIF() function, discussing its primary purpose, and touching upon its many

(Itzik Ben-Gan) T-SQL querying problems often require you to apply complex logical thinking. Even though some people may be born with stronger logical-deduction abilities than others, logic is an area in which you can significantly improve by constant practice. So, the more you practice tough T-SQL