Does anyone know the equivalent to returning the current source row in SQL Server 7 DTS ActiveX Script? In SQL 2000 it is Clng(DTSTransformPhaseInfo.CurrentSourceRow) to a GlobalVariable. cheers!
2002-01-31
4 reads
One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips.
2005-07-15 (first published: 2002-01-24)
21,643 reads
This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.
2002-01-18
2,982 reads
This week Andy takes a look at a new product from Red-Gate that gives you even more options than you get with their SQL Compare and SQL Data Compare tools - now you can build your own. Add the features you always wanted. Build automated processes instead of using the GUI. It's an interesting product - read the review and then maybe even enter the contest to win a free copy.
2002-01-16
5,396 reads
Hi All, We are planning to use log shipping (SQL 2000) to maintain our stand-by server. I have a few doubts regarding this 1. To use BCP i have to use bulk-logged recovery. But, what happens to my bulk inserted data. Will this be transferred to my standby-server. 2. If I use DTS for the […]
2001-12-19
14 reads
The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.
2007-02-09 (first published: 2001-12-18)
39,653 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/other/newyearcontest.asp
2001-12-16
2 reads
In three previous articles Andy has done a very basic introduction to the ADO connection, command, and recordset objects. In this wrap up article he talks about how to use the power of ADO client side filtering and disconnected recordsets, then adds some code which shows how to combine all the objects. ADO is not simple, but Andy has done a good job in limiting his dicussion to the things you REALLY need to know about ADO to get started.
2001-12-07
9,999 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/bknight/servicepack2forsqlserver2000.asp
2001-12-02
5 reads
In the several years that I have been programming ASP pages, I have seen countless methods of dynamically filling HTML drop down list boxes. Well, here's another method. This one uses sql 2000's new FOR XML EXPLICIT clause, and I really like the results.
2001-11-14
8,133 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers