Dynamic management view to find all queries that have been run against a table since the last reboot.
Archive of entries posted on June 2009
Search Stored Procedure Text
Code snippet used to search within a stored procedure using the INFORMATION_SCHEMA.
SQL Server 2005 vs SQL Server 2008
Outlines some new features of SQL Server 2008 and provides the reasons to upgrade instead of 2005.
SQL Server Indexes Tutorial
This article gives a real world explanation (and code examples) of indexing along with the tools necessary to be able to choose the right indexing strategy for your tables.
SQL Server Interview Questions
Real world questions asked to real interviewees. These interview questions cover the different areas of SQL Development, data flow, and Database Administration.
Delete Duplicate Rows
Examples on how to removed duplicate rows from your table even if you do not have a primary key.
Replace Invalid Characters
Example on how to replace characters within a SQL String. Examples would be to remove all alpha or numeric characters from a string.
MetaData Change Data Capture Solution (CDC)
Change Data Capture, CDC is a feature that is revolutionizing SQL Server in respects to data flow. Previous to change data capture, triggers or high water marks needed to be used in order to perform delta transfers of data to data warehouses or disparate systems. This example shows the use of a custom CDC solution [...]
SQL Server Keywords (Reserved Words)
The keywords (Reserved Words) used by SQL Server 2008
WaitFor Delay & Time
Shows how to make SQL Server “Sleep” using the WaitFor command.
