<![CDATA[Article Comments for William Vaughn]]>http://www.windowsitpro.com/authors/author/author/5078020/rsscomment/5078020en-USSun, 27 May 2012 06:01:50 GMTSun, 27 May 2012 06:01:50 GMTManaging TableAdapter Timeoutshttp://www.windowsitpro.com/article/sql-server/managing-tableadapter-timeouts#commentsAnchorMon, 18 Jul 2011 09:22:32 GMT
Where is Listing 2? The most important part of the article is missing :-( Looks very promising though, and I'm sure it would be helpful if I could find the key bit.]]>
Mon, 18 Jul 2011 09:22:32 GMThttp://www.windowsitpro.com/article/sql-server/managing-tableadapter-timeouts#commentsAnchor
Managing TableAdapter Timeoutshttp://www.windowsitpro.com/article/sql-server/managing-tableadapter-timeouts#commentsAnchorFri, 11 Mar 2011 11:36:27 GMT
When I add the "namespace" line to the top of the dataset.vb file then it seems to "override" the code contained under the same namespace in the .designer.vb file. Errors appear everywhere I have used something from the dataset. Any insight?]]>
Allen CalesFri, 11 Mar 2011 11:36:27 GMThttp://www.windowsitpro.com/article/sql-server/managing-tableadapter-timeouts#commentsAnchor
Managing TableAdapter Timeoutshttp://www.windowsitpro.com/article/sql-server/managing-tableadapter-timeouts#commentsAnchorWed, 19 May 2010 11:04:44 GMT
Where is Listing 2?]]>
Garrett JohnsonWed, 19 May 2010 11:04:44 GMThttp://www.windowsitpro.com/article/sql-server/managing-tableadapter-timeouts#commentsAnchor
Passing NULL Parametershttp://www.windowsitpro.com/article/tsql3/passing-null-parameters#commentsAnchorTue, 08 Dec 2009 06:08:23 GMT
A good way is to use dynamic SQL or split into multiple stored procedure. This is to make sure the optimum query plan is generated]]>
benTue, 08 Dec 2009 06:08:23 GMThttp://www.windowsitpro.com/article/tsql3/passing-null-parameters#commentsAnchor
Passing NULL Parametershttp://www.windowsitpro.com/article/tsql3/passing-null-parameters#commentsAnchorTue, 08 Dec 2009 06:00:35 GMT
Try to advoid using this technique. There is a big limitation in performance where most people do not realise. This technique will stuff up the query plan. It will do an index scan instead of index seek. I have fixed this kind of query several times because of this technique. This only occur in the following condition I described: If the WHERE clause in the SQL do not contain any non-nullable values (the parameter must have something).. Page 1 of this article is a good example... Index scan will occur..]]>
benTue, 08 Dec 2009 06:00:35 GMThttp://www.windowsitpro.com/article/tsql3/passing-null-parameters#commentsAnchor
Generate a Clickthrough Report using Visual Studio ReportViewerhttp://www.windowsitpro.com/article/reporting-services/generate-a-clickthrough-report-using-visual-studio-reportviewer#commentsAnchorThu, 24 Sep 2009 20:14:23 GMT
Excellent article..]]>
LouisThu, 24 Sep 2009 20:14:23 GMThttp://www.windowsitpro.com/article/reporting-services/generate-a-clickthrough-report-using-visual-studio-reportviewer#commentsAnchor
Importing Access Reports into SQL Server Reporting Serviceshttp://www.windowsitpro.com/article/reporting2/importing-access-reports-into-sql-server-reporting-services#commentsAnchorFri, 07 Aug 2009 13:48:28 GMT
Any users know of any solid tools out there to help convert CR XI R2 reports to SSRS 2008?]]>
JasonFri, 07 Aug 2009 13:48:28 GMThttp://www.windowsitpro.com/article/reporting2/importing-access-reports-into-sql-server-reporting-services#commentsAnchor
Managing Hierarchical Rowsetshttp://www.windowsitpro.com/article/data-access/managing-hierarchical-rowsets#commentsAnchorFri, 17 Oct 2008 12:16:15 GMT
I tried to "download" the code as described in the article. The complete Visual Studio project is not included in the download as the article states. Could you please provide the VS project/source code for the program described in the article? Thanks in advice.]]>
STEPHENFri, 17 Oct 2008 12:16:15 GMThttp://www.windowsitpro.com/article/data-access/managing-hierarchical-rowsets#commentsAnchor
Managing Hierarchical Rowsetshttp://www.windowsitpro.com/article/data-access/managing-hierarchical-rowsets#commentsAnchorMon, 25 Aug 2008 16:27:40 GMT
Hi TomMohoric, Thanks for commenting on this article. The following is William Vaughn’s response to your comment: "IIRC, the database used in the article, is one of the sample databases downloadable from the Microsoft SQL Server site. http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en." Please feel free to contact me directly at megan.bearly@penton.com if you have anymore questions. Thanks! Megan Bearly Associate Editor, SQL Server Magazine megan.bearly@penton.com]]>
meganbearly Mon, 25 Aug 2008 16:27:40 GMThttp://www.windowsitpro.com/article/data-access/managing-hierarchical-rowsets#commentsAnchor
Managing Hierarchical Rowsetshttp://www.windowsitpro.com/article/data-access/managing-hierarchical-rowsets#commentsAnchorTue, 29 Jul 2008 11:07:46 GMT
There doesn’t appear to be a CREATE database script included.]]>
TomMohoricTue, 29 Jul 2008 11:07:46 GMThttp://www.windowsitpro.com/article/data-access/managing-hierarchical-rowsets#commentsAnchor
Generate a Clickthrough Report using Visual Studio ReportViewerhttp://www.windowsitpro.com/article/reporting-services/generate-a-clickthrough-report-using-visual-studio-reportviewer#commentsAnchorMon, 28 Jul 2008 16:40:31 GMT
great article!]]>
ChrisMon, 28 Jul 2008 16:40:31 GMThttp://www.windowsitpro.com/article/reporting-services/generate-a-clickthrough-report-using-visual-studio-reportviewer#commentsAnchor
Additional Featureshttp://www.windowsitpro.com/article/data-access/additional-features#commentsAnchorThu, 17 Apr 2008 22:23:01 GMT
Hi mjgreco, Thanks so much for your feedback. We have checked both .zip files and found that everything that was provided by the author is accounted for in the .zip files. However, if you would like to discuss this further, please feel free to contact me directly at mbearly@sqlmag.com. Also, I queried the author to see about the database. According to William Vaughn, "The database (IIRC) is Adventureworks (one of the sample database)." Thanks! Megan Bearly Associate Editor, SQL Server Magazine mbearly@sqlmag.com]]>
meganbearly Thu, 17 Apr 2008 22:23:01 GMThttp://www.windowsitpro.com/article/data-access/additional-features#commentsAnchor
Additional Featureshttp://www.windowsitpro.com/article/data-access/additional-features#commentsAnchorWed, 12 Mar 2008 12:34:11 GMT
Neither zip 97182 or 97180 have vs project or database??]]>
MikeWed, 12 Mar 2008 12:34:11 GMThttp://www.windowsitpro.com/article/data-access/additional-features#commentsAnchor
Managing ReportViewer Parametershttp://www.windowsitpro.com/article/tsql3/managing-reportviewer-parameters#commentsAnchorThu, 13 Dec 2007 13:57:02 GMT
Hi, Thanks for pointing that out. Bill actually has the entire project in a 9 Mb .zip file for download. We’ll get the access taken care of shortly. Thanks again. Diana May Technical Editor SQL Server Mag]]>
DianaThu, 13 Dec 2007 13:57:02 GMThttp://www.windowsitpro.com/article/tsql3/managing-reportviewer-parameters#commentsAnchor
Managing ReportViewer Parametershttp://www.windowsitpro.com/article/tsql3/managing-reportviewer-parameters#commentsAnchorThu, 13 Dec 2007 12:40:40 GMT
omhoge, thanks for reading the article and letting us know about possible missing code in the download file. I’m checking on that for you now... Anne Grubb, Web site strategic editor, SQL Server Magazine]]>
AnneThu, 13 Dec 2007 12:40:40 GMThttp://www.windowsitpro.com/article/tsql3/managing-reportviewer-parameters#commentsAnchor
Managing ReportViewer Parametershttp://www.windowsitpro.com/article/tsql3/managing-reportviewer-parameters#commentsAnchorThu, 06 Dec 2007 10:31:08 GMT
Hello, the sample application is not in the 95671.zip file. Can you please tell me where the download is located? We’re having trouble getting the viewer to connect and this sample would be helpful. Thanks so much for this article, perfect timing for my project. much appreciated!]]>
JOHNThu, 06 Dec 2007 10:31:08 GMThttp://www.windowsitpro.com/article/tsql3/managing-reportviewer-parameters#commentsAnchor
Swimming in the .NET Connection Poolhttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchorThu, 24 May 2007 14:25:27 GMT
It’s awesome.]]>
WILLIAMThu, 24 May 2007 14:25:27 GMThttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorWed, 03 Jan 2007 12:18:32 GMT
The article is very dense in relevant information. However, a discussion of the choice of cursor location on performance would be helpful. It is clear from the basic documentation that you should use readonly, forward only cursors and in what order the cursors will take more time/resources, but there is little discussion about cursor location and its effect on performance. Background on the way that records are transfered from server to client would be helpful. Also, a discussion on how things work on the server, the use of the TempDB, the visibility of added/deleted records etc when in a transaction would be helpful - and does the cursor location effect this?]]>
WILLIAMWed, 03 Jan 2007 12:18:32 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
Developing CLR-Based Stored Procedureshttp://www.windowsitpro.com/article/tsql3/developing-clr-based-stored-procedures#commentsAnchorSat, 08 Apr 2006 10:40:49 GMT
Since I wrote it, I like it, but I also think it needs to be updated.]]>
WILLIAMSat, 08 Apr 2006 10:40:49 GMThttp://www.windowsitpro.com/article/tsql3/developing-clr-based-stored-procedures#commentsAnchor
Fast Answershttp://www.windowsitpro.com/article/quering/fast-answers#commentsAnchorTue, 01 Mar 2005 06:59:00 GMT
very usefull]]>
Anonymous User Tue, 01 Mar 2005 06:59:00 GMThttp://www.windowsitpro.com/article/quering/fast-answers#commentsAnchor
Swimming in the .NET Connection Poolhttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchorFri, 15 Oct 2004 10:16:50 GMT
This means that when running an ASP.NET application, the pages sharing an application domain can share a connection pool—if and only if they have the same transaction context and same connection string. Otherwise, different ASP application domains don’t share pools. In a Windows environment, each process gets its own set of pools. Two Windows applications with identical connections strings do NOT share a connection pool. William R. Vaughn President and Founder Beta V Corporation Microsoft MVP (425) 556-9205 (v/f)]]>
SCone_SQLMagFri, 15 Oct 2004 10:16:50 GMThttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchor
Swimming in the .NET Connection Poolhttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchorWed, 06 Oct 2004 08:12:09 GMT
When author says: "Also remember that each .NET assembly gets a unique PID. This means that each new assembly you run gets its own pool-regardless of the similarity of function or the fact that their ConnectionString values are identical." What does he exactly mean? For instance, if I have two assemblies A and B running in the same address space (ASP.NET) and both of them open a DB connection using the same Connection string, does it mean there will be two connection pools created? Thanks]]>
DIMAWed, 06 Oct 2004 08:12:09 GMThttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchor
Developing CLR-Based Stored Procedureshttp://www.windowsitpro.com/article/tsql3/developing-clr-based-stored-procedures#commentsAnchorSat, 10 Jul 2004 01:19:03 GMT
Good]]>
NAGESHSat, 10 Jul 2004 01:19:03 GMThttp://www.windowsitpro.com/article/tsql3/developing-clr-based-stored-procedures#commentsAnchor
Swimming in the .NET Connection Poolhttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchorFri, 02 Jul 2004 17:00:38 GMT
very informative. my pools are over flowing in an asp.net app; while this doesn’t tell me really how to fix it, i learned a lot. and will probably be able to figure it out. thanks a lot!]]>
benjamin j, van der veen Fri, 02 Jul 2004 17:00:38 GMThttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchor
The .NET Connection Pool Lifeguardhttp://www.windowsitpro.com/article/performance/the-net-connection-pool-lifeguard#commentsAnchorMon, 28 Jun 2004 06:23:56 GMT
Using "CommandBehavior.CloseConnection" as argument for ExecuteReader() does close its associated connection, if you close the DataReader yourself (with Close()) after finishing with reading.]]>
J. Kuiper Mon, 28 Jun 2004 06:23:56 GMThttp://www.windowsitpro.com/article/performance/the-net-connection-pool-lifeguard#commentsAnchor
Managing Your MSDE Databasehttp://www.windowsitpro.com/article/permissions/managing-your-msde-database#commentsAnchorWed, 16 Jun 2004 08:25:21 GMT
Your Comments (required):Fantastic. Great work. This document touches all part of the MSDE. Many of my doubt cleared with this document. Thanx a lot. pls touch with me]]>
Name (required):Muhamed Niyas Wed, 16 Jun 2004 08:25:21 GMThttp://www.windowsitpro.com/article/permissions/managing-your-msde-database#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorMon, 14 Jun 2004 06:32:06 GMT
Good article..]]>
DenisMon, 14 Jun 2004 06:32:06 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
Swimming in the .NET Connection Poolhttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchorThu, 03 Jun 2004 17:46:25 GMT
The author didn’t go into enough depth(I suspect he didn’t do enough research either), and most of the text are just lame assertions. There isn’t even a decent sample connection string. Also InvalidOperationException is not thrown when there is connection timeout, it should be SqlException.]]>
csone Thu, 03 Jun 2004 17:46:25 GMThttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchor
Accessing SQL Server Named Parameters with ADO 2.6http://www.windowsitpro.com/article/activex/accessing-sql-server-named-parameters-with-ado-2-6#commentsAnchorThu, 22 Apr 2004 07:04:54 GMT
I spent three hours yesterday trying to determine why an RDO environment definition stopped working after an NT - W2K upgrade. When I decided to just rewrite it with ADO the hurdle was this syntax. It worked the first time.]]>
Gary Majkowski Thu, 22 Apr 2004 07:04:54 GMThttp://www.windowsitpro.com/article/activex/accessing-sql-server-named-parameters-with-ado-2-6#commentsAnchor
The .NET Connection Pool Lifeguardhttp://www.windowsitpro.com/article/performance/the-net-connection-pool-lifeguard#commentsAnchorWed, 07 Apr 2004 16:04:36 GMT
It would be great if you covered something about "how to deal with a full connection pool?" How can we flush the connections in a connection pool? Thanks]]>
Druay AKAR Wed, 07 Apr 2004 16:04:36 GMThttp://www.windowsitpro.com/article/performance/the-net-connection-pool-lifeguard#commentsAnchor
The .NET Connection Pool Lifeguardhttp://www.windowsitpro.com/article/performance/the-net-connection-pool-lifeguard#commentsAnchorMon, 29 Mar 2004 11:07:44 GMT
Very useful article. I have a problem with an application that is levaing orphaned connections but I haven’t found the way to get rid off them. I’ve done all the different things you mentioned in the article but the problem persist. Is there any programatically way to kill of these orphaned connections?]]>
Alexander Gomez Piedra Mon, 29 Mar 2004 11:07:44 GMThttp://www.windowsitpro.com/article/performance/the-net-connection-pool-lifeguard#commentsAnchor
Swimming in the .NET Connection Poolhttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchorSat, 27 Mar 2004 10:16:46 GMT
This article is an extremely high quality description, how connection pooling works and what do to avoid pitfalls. Every developer should read it, before using dotnet database providers.]]>
Oliver Hausler Sat, 27 Mar 2004 10:16:46 GMThttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchor
The .NET Connection Pool Lifeguardhttp://www.windowsitpro.com/article/performance/the-net-connection-pool-lifeguard#commentsAnchorTue, 09 Mar 2004 06:24:14 GMT
I found the article to be very information and enlightening. Gave some good advice on how to avoid the pitfalls of connection pooling. Overall, an excellent read. :-)]]>
yasirTue, 09 Mar 2004 06:24:14 GMThttp://www.windowsitpro.com/article/performance/the-net-connection-pool-lifeguard#commentsAnchor
The .NET Connection Pool Lifeguardhttp://www.windowsitpro.com/article/performance/the-net-connection-pool-lifeguard#commentsAnchorFri, 27 Feb 2004 11:08:03 GMT
Thank you very much. Our department is migrating to .Net from VB6 and we have been floundering, mainly over connection pooling. These two articles are the only ones we found that give complex examples and in-depth discussion. Now we finally understand why we were getting pool overflow--and what to do about it.]]>
Raymo Fri, 27 Feb 2004 11:08:03 GMThttp://www.windowsitpro.com/article/performance/the-net-connection-pool-lifeguard#commentsAnchor
Swimming in the .NET Connection Poolhttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchorWed, 14 May 2003 17:37:40 GMT
I presume when Bill says ’If you use a specific UID for each connection, each UID gets its own pool.’ he means ’if you use a different UID ...’. Two identical cxn strings used by the same process would get pooled even if they use the same specific UID I thought.]]>
Jim Weiler Wed, 14 May 2003 17:37:40 GMThttp://www.windowsitpro.com/article/activex/swimming-in-the-net-connection-pool#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorFri, 09 May 2003 10:27:17 GMT
Finally, an article that really goes into detail about "how to" use ADO more effectively.]]>
Martin Barron Fri, 09 May 2003 10:27:17 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
Managing Extended Propertieshttp://www.windowsitpro.com/article/user-defined-function-udf/managing-extended-properties#commentsAnchorThu, 01 May 2003 13:02:15 GMT
I am totally amazed that SQL server doesn’t have an easier way to associate comments with columns and tables, unlike all the other major relational DB. Surely to play with the big boys, you would think this basic meta-data facility would be there, but instead we get a too complicated method so that third party tools such as Embarcadero can’t migrate that key part of data model...]]>
Brandon Smith Thu, 01 May 2003 13:02:15 GMThttp://www.windowsitpro.com/article/user-defined-function-udf/managing-extended-properties#commentsAnchor
Much ADO About Nothinghttp://www.windowsitpro.com/article/activex/much-ado-about-nothing#commentsAnchorSun, 26 Jan 2003 11:47:33 GMT
The VB6 example If Not rs(0) = Null Then Text1.Text = rs(0) Else Text1.Text = "" End If will not work unless there is some special setting I’m unaware of. The Null will progagate through the expression until it can no longer propagate at which point VB will treat it as false. The code If Not rs(0)=Null then MsgBox "Not Null" EndIf If rs(0)=Null then MsgBox "Null" EndIf Although it seems one of these should be true, neither MsgBox will display because the Null will propagate through both of these and both will evaluate to false.]]>
Craig Bennett Sun, 26 Jan 2003 11:47:33 GMThttp://www.windowsitpro.com/article/activex/much-ado-about-nothing#commentsAnchor
Much ADO About Nothinghttp://www.windowsitpro.com/article/activex/much-ado-about-nothing#commentsAnchorSat, 25 Jan 2003 15:21:34 GMT
Does any one know how to count the ODBC/ADO connections to a database? I don’t seem to be able to find any info on msdn or other lit about counting connections. I have a problem with connection pooling and an error 8004005 where the error is ramdon and does not leave any trace except to tell me it’s an "unspecified error" comment. the software is using ADO, asp and an oracle database using odbc. I can be reached at carlos@dcu-inc.com, thanks...]]>
CARLOSSat, 25 Jan 2003 15:21:34 GMThttp://www.windowsitpro.com/article/activex/much-ado-about-nothing#commentsAnchor
Accessing SQL Server Named Parameters with ADO 2.6http://www.windowsitpro.com/article/activex/accessing-sql-server-named-parameters-with-ado-2-6#commentsAnchorWed, 23 Jan 2002 12:50:15 GMT
I’ve been successfully using ConnectionObject.StoredProcedureName trick for quite some time now in my ASP pages. Works great! (much simpler than constructing Parameter objects and all that jazz). Now, I wanted to move my code into a VB COM object (ActiveX DLL). This, too, worked fine until I tried to debug my code in VB. VB throws the following error "Automation error Invalid access to memory location." When running the same code without the debugger it runs fine. If I comment out the line that calls the stored procedure, the code will debug fine. So... Any thoughts/comments? -- Margo]]>
Margo Wed, 23 Jan 2002 12:50:15 GMThttp://www.windowsitpro.com/article/activex/accessing-sql-server-named-parameters-with-ado-2-6#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorTue, 21 Aug 2001 22:24:15 GMT
This article is excellent. I’ve been working with SQL for about a year now, and 2-3 of the ideas discussed are new to me. I think the proper coding of SQL and actually learning the many different ways to do one thing is what sets experienced SQL developers apart from the pack...]]>
KeithTue, 21 Aug 2001 22:24:15 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorSun, 29 Jul 2001 22:23:42 GMT
This article is really great. I have a few of Bill’s books for my own collection and reference. I think this article explains the practicality of applying Microsoft data-access technology the way it should be used for real-world apps.]]>
Asri Ismail Sun, 29 Jul 2001 22:23:42 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorFri, 13 Jul 2001 13:03:33 GMT
This is in reference to the article "ADO Best Performance Practises" (i.e InstantDoc 16272). It says With the procedures as Connection methods, you can pass the stored procedure’s input arguments as method arguments, and if a Recordset is returned, you can reference the Recordset as the last argument in the method call. For example, the following ADO statement executes a stored procedure called "Fred" that has two input parameters and a returned Recordset: MyConnection.Fred "InputArg1", 2, myRecordset " Microsoft JET Database Engine error ’80040e10’ Too few parameters. Expected 1.]]>
kamranFri, 13 Jul 2001 13:03:33 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorWed, 11 Jul 2001 15:44:08 GMT
This is the type of a article that all developers should see. Thanks for sharing this knownledge with us.]]>
Filipe Santos Wed, 11 Jul 2001 15:44:08 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorWed, 20 Jun 2001 14:43:14 GMT
I bought Bill Vaughn’s book for reference. As a DBA, I refer to it quite often to troubleshoot issues that developers bring up. The book gives us an idea of what to look for, both in SQL and in ASP/ADO app code.]]>
Mike Beadles Wed, 20 Jun 2001 14:43:14 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorMon, 18 Jun 2001 19:50:24 GMT
Good stuff! I’m struggling now to improve my application’s performance. This article gave me good advice with deep explanations. Thank you.]]>
Victor Kuzmich Mon, 18 Jun 2001 19:50:24 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorFri, 04 May 2001 14:54:57 GMT
Why not using the GetRows method? Isn’t it even faster and more practical than the prebinding?]]>
Richard Nolasque Fri, 04 May 2001 14:54:57 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorTue, 13 Mar 2001 19:18:22 GMT
I bought the book. Our GM forced me to sell it to the company as a standard for staff training! Now I have to buy my own copy, again... This article fills out some of our ADO gaps. Thanks.]]>
Normand G. LaBine Tue, 13 Mar 2001 19:18:22 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorWed, 07 Feb 2001 13:28:08 GMT
What a great article! Unlike the common fair that is found on various ASP sites and magazines almost monthly, Bill goes beyond the Microsoft docs and explains things from a real-world perspective. Too many times articles present their ideas as a "one-size-fits-all" approach instead of explaining when and where a concept really applies.]]>
Kirk Allen Evans Wed, 07 Feb 2001 13:28:08 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor
ADO Performance Best Practiceshttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchorSat, 03 Feb 2001 22:49:42 GMT
This article is great, every Ado programmer is always tring to find new ways to get there results finished faster, this article i believe has all the right answers. Chris.]]>
Chris Hatton Sat, 03 Feb 2001 22:49:42 GMThttp://www.windowsitpro.com/article/activex/ado-performance-best-practices#commentsAnchor