(Mark J. Miller) The SQL IN statement allows a set of records to be returned based on a variable (unknown at design time) number of keys. However, IN doesn’t allow parameters and this leaves us with the choice of using either fixed lists or dynamic SQL statements. The problem with fixed lists is tha

Online Indexing is a new feature available in SQL Server 2005. In SQL Server 2005, DBAs can create, rebuild, or drop indexes online. The index operations on the underlying table can be performed concurrently with update or query operations. This was not possible in previous versions of SQL Server. I

(Pinalkumar Dave) The EXCEPT operator returns all of the distinct rows from the query to the left of the EXCEPT operator when there is no matching rows in the right query. The EXCEPT operator is equivalent of the Left Anti Semi Join. EXCEPT operator works the same way NOT IN. EXCEPTS returns any dis

(Tim Chapman) When data in a database is read or modified, the database engine uses special types of controls, called locks, to maintain integrity in the database. Locks basically work by making sure database records involved in a transaction cannot be modified by other transactions until the first

(Baya Pavliashvili) Those of us who have used SQL Server Profiler acknowledge it as one of the best tools for troubleshooting and tuning relational database applications. If you need to find what indeed is happening “under the hood” Profiler is by far the best place to start. If you want similar fun