(Andrew Novick) In the previous issue I discussed the AppSession table that I use as a way of organizing application trace lines that come from the same program. This issue is about writing trace lines in order to record information about your application. In .Net it’s been my practice to write ab

(Subhash Ramachandran) SQL Server 2000 has many features which when used wisely, will improve the performance of the queries and stored procedures considerably.

Hash and merge algorithms can be used in a join operation between two or more tables only if there is at least one qualified equality comparison between the join attributes. An OR clause disqualifies all equality comparisons between joined tables.

(Don Schlichting) This article concentrates on using Full Text Search to query text located inside Microsoft Office documents. In previous articles, Microsoft Search was introduced as an add-on service to enable advanced text queries. Catalogs, the physical storage units for search, were created and

(Tom Moreau) Aggregation, which is commonly used to deliver reports to users, often also delivers poor performance. To help guarantee that you’re delivering the best performance possible, you should explore different versions of the query and pick the best one. This month, look over Tom Moreau’s

(Robert L. Bogue) When looking at SQL performance there’s an immediate desire to jump into the queries that the SQL Server is being forced to process and see what can be done to improve them. Unfortunately, it’s not always that simple. Sometimes the queries are coming from packaged software that

(Yatin Karekar) This tip will show you how to connect to SQL Server using ADODB Retrieving Records using Record Set and connecting it to Crystal Reports.

(William E. Pearson, III) In our previous article, Execution Log Reporting: Preparation as a Data Source, we began with a discussion about a valuable source of information for performance and auditing analysis, the Report Server Execution Log. We noted that the Execution Log captures data specif

(Muthusamy Anantha Kumar) SQL Server database administrators are often faced with hundreds of emails and pages when all of the SQL Servers are scheduled for rebooting. In some organizations, the reboot cycles are performed on a weekly basis and in some organizations, the reboot cycles are performed

The stored procedure outlined in the MORE INFORMATION section of this article will display information for triggers defined within a database. The report includes trigger name, trigger type, associated database, and the table on which the trigger is defined. This information is not available from sp