Wayne Fillis


SQLServerCentral Article

The Effect of NOLOCK on Performance

Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system.

4.55 (20)

You rated this post out of 5. Change rating

2017-02-02 (first published: )

72,331 reads

SQLServerCentral Article

The Dedicated Administrator Connection

New to SQL Server 2005 is the Dedicated Administrator Connection (DAC), which provides a way to ensure you can always connect to your server. No more getting locked out of a busy server as could occur in prior versions. Wayne Fillis brings us a short tutorial on this handy new feature.

4 (4)

You rated this post out of 5. Change rating

2008-05-05 (first published: )

7,687 reads

SQLServerCentral Article

Conditional Flow in DTS

While SQL Server Integration Services is a huge improvement in the ETL capabilities of SQL Server, there are quite a few environments still using DTS in SQL Server 2000. Wayne Fillis brings us a method for implementing conditional logic in your packages.

4 (4)

You rated this post out of 5. Change rating

2008-03-19 (first published: )

10,278 reads

SQLServerCentral Article

SQL Prompt IntelliSense for SQL Server

Visual Studio developers have enjoyed the benefits of intellisense for some time, but us SQL Server users have had to work from memory. Wayne Fillis was so enthralled with a new offering from Red Gate he wrote a short review and sent it in. Check out his thoughts and how this product can help you.

You rated this post out of 5. Change rating

2006-07-18

9,536 reads

SQLServerCentral Article

An Alternative XML Solution

SQL Server 2000 added support for XML documents in a few ways. However the support was a little kludgy as it had not been designed into the product from the beginning, but added on later. New author Wayne Fillis brings us some C++ code and a new way to easily retrieve well formed XML documents from your SQL Server.

You rated this post out of 5. Change rating

2004-11-10

8,635 reads

Blogs

Creating a Striped Backup Set with AI

By

I needed to test a striped backup, so I decided to ask the AI’s...

Trace Flag 1448 – Lessons from a Technical Interview

By

In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...

Disable the sa login in SQL Server (and sleep better)

By

Disable the sa login in SQL Server (and sleep better)If you run SQL Server...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

SQLPS and syspolicy_purge_history job

By schleep

The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...

Be Wary of Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Be Wary of Data

Visit the forum

Question of the Day

Locking Hierarchies

You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:

SELECTo_orderdate,
        o_orderkey,
        o_custkey,
        o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;

What locking hierarchy will Microsoft SQL Server use?

 

See possible answers