Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Neil Boyle

SQLServerCentral.com profile

   Items 1 to 18 of 18   
 

SQL Server 2000 Trigger Enhancements

This article by Neil Boyle looks at the enhancements to triggers that SQL Server 2000 brings.   Read more...
By Neil Boyle 2001/07/11 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 6,670 reads

SQL 7 Bugs on SMP Servers

SQL Server 7 has a number of bugs that occur on multi-processor machines. This article presents a concise listing of these bugs.   Read more...
By Neil Boyle 2001/05/30 | Source: SQLServerCentral.com | Category: bugs
Rating: |  Discuss |   Briefcase | 3,310 reads

Speed Tips For Select Statements

This article by Neil Boyle examines techniques for speeding up your queries by writing better T-SQL.   Read more...
By Neil Boyle 2001/06/07 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 13,466 reads

Saving Space To Increase Performance

Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.   Read more...
By Neil Boyle 2003/02/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,875 reads

Removing Duplicate Rows

Ever have duplicate rows of data returned in a query? This article by Neil Boyle examines different techniques for removing duplicate rows.   Read more...
By Neil Boyle 2001/05/14 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 11,666 reads

Standing Back And Looking At Benchmark Results

What do the TPC-C benchmarks mean to the average DBA? In this article, Neil Boyle steps back and looks at them from a practical view.   Read more...
By Neil Boyle 2001/05/22 | Source: SQLServerCentral.com | Category: news
Rating: |  Discuss |   Briefcase | 5,768 reads

Tuning SQL Server Memory in 2 Minutes

You cannot do a proper tuning job on SQL server in two minutes, but you can get a good idea of how well a server is set up. This article will show you how to quickly evaluate the efficiency of memory usage on your server.   Read more...
By Neil Boyle 2001/05/21 | Source: SQLServerCentral.com | Category: configuring
Rating: |  Discuss |   Briefcase | 9,833 reads

Generate Test Data Quickly With Cross Joins

Need to rough up some bulk test data in a hurry? A carefully thought-out Cross Join could be the answer.   Read more...
By Neil Boyle 2001/05/10 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 5,423 reads

Simplifying Instead Of Triggers

Instead of triggers are a new feature in SQL Server 2000 which greatly extend the functionality of triggers. This article covers a basic introduction to Instead of Triggers and illustrates possibilities for their use.   Read more...
By Neil Boyle 2001/05/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,625 reads

Getting The Best From The Index Tuning Wizard

The Index Wizard is a handy tool shipped as part of the SQL 7 Profiler that can analyze a set of SQL queries and suggest index changes that could improve their performance.   Read more...
By Neil Boyle 2001/05/16 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 5,322 reads

Using Index Intersections

First introduced in SQL Server version 7, Index Intersection gives you new options for creating indexes on tables to maximize performance.   Read more...
By Neil Boyle 2001/06/12 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 5,238 reads

Fixing broken logins and transferring passwords

When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.   Read more...
By Neil Boyle 2004/07/05 (first published: 2002/08/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,934 reads

Speedy Database Recovery with Differential Backups

Differential backups are a new feature in SQL 7 that can speed up your recovery times when restoring from database and transaction log backups.   Read more...
By Neil Boyle 2001/06/05 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,414 reads

Complex updates using the Case statement

One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.   Read more...
By Neil Boyle 2001/06/04 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 10,640 reads

Case Statement Tricks

The CASE statement is a very flexible tool. Here are just a few of the tricks you can work with it.   Read more...
By Neil Boyle 2001/05/15 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 14,246 reads

ANSI Joins

Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.   Read more...
By Neil Boyle 2001/05/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,784 reads

Avoiding Bottlenecks with Temporary Tables

Were you aware that the act of populating a temporary table can cause system-wide bottlenecks on your server? Problems can occur both with SQL Server 6.5 and 7.0/2000 in different ways, and in this article Neil Boyle discusses how best to avoid them.   Read more...
By Neil Boyle 2001/05/08 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,800 reads

SQL 2000 User Defined Function Primer

Many programming languages have supported User Defined Functions for years, but they are new to SQL Server 2000. In this article we will look at some of the ways functions can be used within SQL Server 2000.   Read more...
By Neil Boyle 2004/10/22 (first published: 2001/05/02) | Source: SQLServerCentral.com | Category: user defined function (udf)
Rating: |  Discuss |   Briefcase | 20,652 reads
   Items 1 to 18 of 18