SQLServerCentral / Discuss Content Posted by Wayne Fillis / Article Discussions / Article Discussions by Author

The Effect of NOLOCK on Performance

Wayne-153714 — Fri, 15 Dec 2006 09:25:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/WFillis/2764.asp

Managing Selects and Updates in a High Transaction table

Santa Ana — Fri, 27 Mar 2009 09:13:01 GMT

here is a scenario: I have a table that is highly transactional, there is a backend process that will update certain columns in a row at a time.( there could be multiple processes updating multiple rows at a time too )Concurrently, the end users will issue a 'select' and will be 'update'ing the same set of rows that the back end process may be operating on.I was getting enormous DEADLOCKs before i tried NOLOCK on SELECTs and ROWLOCK on UPDATEs.The DEADLOCKs considerably reduced. But they started appearing again slowly(may be the data volume now is huge).How do i handle this scenarios with locks ? Also, what is the effect of using NOLOCK on updates/how bad is this ? Thanks in adv. for your suggestions.

Conditional Flow in DTS

Wayne-153714 — Wed, 14 Mar 2007 13:51:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/WFillis/2929.asp

DAC error

SQL DBA-601753 — Mon, 24 Mar 2008 13:54:24 GMT

Hi,I am not able to connect using DAC. I get the errorTITLE: Connect to Database Engine------------------------------Cannot connect to ADMIN:mdinn,2029.------------------------------ADDITIONAL INFORMATION:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=87&LinkId=20476------------------------------BUTTONS:OK------------------------------

The Dedicated Administrator Connection

Wayne-153714 — Fri, 29 Dec 2006 11:35:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/WFillis/2786.asp

Stored Proc Timeout When Running Simultaneously With Large BCP Insert

mark.dempster — Wed, 24 Oct 2007 02:12:43 GMT

I have a server running SQL 2000 running on a win2003 cluster, it has two databases;1) On DB1, I have a stored proc that simply adds a single record into a table (primary key is an 'identity' column). The stored proc is called from a classic ASP application using ADO, it inserts on average 100 records per hour (every hour) and take milliseconds to execute.2) On DB2, I have a large BCP routine (4gb file, 5 million records, with a BCP batch size of 100000) inserting records into a single table. This routine is run once a day and takes approx 1 hour to execute.The problem I have is that my stored proc on DB1 will occasionally timeout (average of 5% of the time) when it is executed at the same time as the BCP routine is executing. When the BCP stops running the stored proc never experiences any timeouts.NOTE: The stored proc and BCP routines are independent of each other, the only thing they share in common are they both operate on the same instance of SQL server. Can anyone suggest why this is happening?

First Look: SQL Server 2005 SP2 CTP

Wayne-153714 — Tue, 02 Jan 2007 12:01:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/WFillis/2793.asp

SQL Prompt IntelliSense for SQL Server

Wayne-153714 — Tue, 27 Jun 2006 13:49:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/WFillis/sqlpromptintellisenseforsqlserver.asp

An Alternative XML Solution

Wayne-153714 — Wed, 13 Oct 2004 11:28:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/WFillis