Additional Articles

Execution Plan Basics

by Additional Articles

SimpleTalk

Performance Tuning

Every day, out in the various discussion boards devoted to Microsoft SQL Server, the same types of questions come up again and again: Why is this query running slow? Is my index getting used? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? We are very pleased to be allowed to publish the first chapter of Grant Fritchey's excellent new book on execution plans.

2008-05-22

4,960 reads

Measuring Performance of Stored Procedures

by Additional Articles

SQLServerCentral

Performance Monitoring

Database developers need to write stored procedures which are not only fully functional, but also which perform acceptably. This article concentrates on some of the counters used to measure performance and analyses methods of capturing these counters.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2008-05-21

6,671 reads

Using xp_ReadErrorLog in SQL Server 2005

by Additional Articles

SQLServerCentral

SQL Server 2005

I would like to share some interesting parameters I found for the undocumented extended stored procedure xp_ReadErrorLog. In doing some testing with this extended stored procedure I found four very interesting parameters. Adding to some of the articles already on the web that discuss undocumented stored procedures, in this article I will explain my testing, use and some examples of the procedure.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2008-05-21

3,165 reads

Making the Most Out of the SQL Server 2005 Performance Dashboard

by Additional Articles

SQLServerCentral

Performance Tuning

The SQL Server 2005 Performance Dashboard is a new add-on to SQL Server 2005 that became available shortly after the release of Service Pack 2 for SQL Server 2005.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2008-05-20 (first published: 2007-06-06)

7,979 reads

Discuss

What BI Practitioners Can Learn From Operations Research

by Additional Articles

SQLServerCentral

Business Intelligence

Growing interest in analytics and the trend toward automated decision making will lead the business intelligence crowd toward the mix of mathematical and statistical techniques used by operations researchers.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2008-05-20

2,346 reads

Full Text Search Noise Words and Thesaurus Configurations

by Additional Articles

MSSQLTips.com

Full-Text Search

I have heard that Full Text Search uses a noise words to eliminate meaningless words in searches. I have also heard that a thesaurus is used, but I am not exactly sure how. Can you provide some details related to how both of these technologies are used in Full Text Search? I am interested in more of a background on these specific Full Text Search technologies as well as where the files are located and how I can update them.

2008-05-19

2,630 reads

Row Value Constructor in SQL Server 2008

by Additional Articles

SQLServerCentral

SQL Server 2008

This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2008-05-16

3,194 reads

Using Policy-Based Management in SQL Server 2008

by Additional Articles

MSSQLTips.com

Policy Based Management (PBM)

As we are reviewing the new features in SQL Server 2008, we found one that looks really interesting - Policy-Based Management. Could you help us to understand how this works and provide some examples? Can you please explain each of the components and how to manage them in the interface and with commands?

2008-05-16

2,942 reads

Finding dependencies in SQL Server 2005

by Additional Articles

SQLServerCentral

SQL Server 2005

Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2008-05-15

2,960 reads

Using DDL triggers to audit events

by Additional Articles

SQLServerCentral

Auditing

Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2008-05-15

3,467 reads

All authors

Additional Articles

Execution Plan Basics

Measuring Performance of Stored Procedures

Using xp_ReadErrorLog in SQL Server 2005

Making the Most Out of the SQL Server 2005 Performance Dashboard

What BI Practitioners Can Learn From Operations Research

Full Text Search Noise Words and Thesaurus Configurations

Row Value Constructor in SQL Server 2008

Using Policy-Based Management in SQL Server 2008

Finding dependencies in SQL Server 2005

Using DDL triggers to audit events

Blogs

A Pursuit of Lifelong Learning

Advice I Like: Time and Focus

Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals

Forums

Alamat BCA KCP BSD Sektor I Telp:0821°8200°233

Alamat BCA KCP Cikupa Telp:0821°8200°203

Alamat BCA KCP Borobudur Telp:0821°7555°651

Question of the Day

DML Trigger Types