Discuss Content Posted by Neil Jacobson
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Neil Jacobson
2002-02-10
5 reads
Basics
Reducing Round Trips - Part 2
Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it!
2002-02-06
9,321 reads
Table name a reserved word in the future
I am getting ready to do an upgrade of a fairly large ASP app from 6.5 to 2000. And I was going through a list of the reserved words and found out that catalog is going to be a reserved word in the future release of 2000 SPs. Now this table is a very important […]
2002-02-04
Triggers not firing
Can anyone tell me why a trigger would not fire when a table is updated from an app, when it fire OK when the same table is updated from query analyser? A similar trigger (generated from the same code)on another table, fires in both instances. I have checked the NOCOUNT is on, and the user […]
2002-01-29
BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server
XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information.
2002-01-28
1,740 reads
Discuss Content Posted by Neil Weicher
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Neil Weicher
2002-01-27
2 reads
OLE DB Times Out
Hello, Ever since we moved from MDAC 2.5 to MDAC 2.6 We have been facing this problem of all DTS, Queries timimg out. The same queries, DTS packages used to work. These do work some times. But the max number of times they time out. Is there a way of setting the time out for […]
2002-01-26
2 reads
Discuss Content Posted by Daniel Gallagher
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Daniel Gallagher
2002-01-25
1 reads
XML Data Solutions
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
Moving and Deleting Rows
What is the best method to move big quantity of rows from one table no another and to delete rows (delete is very slow).
2002-01-15
Blogs
Our Contributions Towards a Stronger Open Source Future
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
Rebuilding a SQL Server Database Transaction Log
“Could you help me, we deleted the database’s transaction log file and now that...
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers