Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.
2002-03-01
2,857 reads
I'm fairly new to SQL programming, so this may be a trivial question, but how do I run a hierarchical recordset query such as the following from a sql server stored procedure? I just get syntax errors, although it runs fine in vbscript. Thanks, David SHAPE {Select * from staff} APPEND ({select * from staff_pub_link} […]
2002-02-27
31 reads
[SQL Server 2000 Enterprise Edition on Windows 2000 Advanced Server] We want to copy the data from our Production SQL Server to another SQL Server to run reports on it. What method it easiest for this ? (Replication, Log Shipping...) --> The DB is 3GB at its peak.
2002-02-27
1 reads
Discussion, comments, and ratings of items posted to SqlServerCentral.com by James Travis
2002-02-24
4 reads
HI, I'm currently looking at the configuration for a new SQLServer and am not sure how to calculate overhead of SQL instances. As far as I can tell the only extra overhead is disk space for the installation and the extra memory that SQL uses on the box to run the instance (which I think […]
2002-02-20
43 reads
Hi EveryBody I'm trying to send email from SQL Server to an email recipeint. But whenever i try to execute following statement in Query Analyzer ... USE master EXEC xp_startmail exec Xp_sendmail 'mack2002@hotmail.com', 'Hello' exec xp_stopmail Then i get following error... SQL Mail session started. Server: Msg 18025, Level 16, State 1, Line 0 xp_startmail: […]
2002-02-08
3 reads
Comments posted to this topic are about the content posted at http://www.microsoft.com/sql/evaluation/betanominations.asp
2002-02-07
1 reads
We just ported a web admin app from SQL 7/IIS 4 to SQL 2000/IIS 5. There is one table maintained that has 3 varchar 8000 fields (plus an id and name field). One the new servers you can only enter ~1000 characters into any of the large fields. Even if the other 2 field are […]
2002-02-05
Hi there! I seem to be having a problem trying to DROP a database! It's a simple test database on SQL Server v 7, which I have created using T-SQL (via Visual FoxPro). The ODBC connection is set as the 'sa' login and password. If I attempt to DROP the database I get a 'Database […]
2002-02-05
3 reads
I have a server running multiple copies of the same app (VB6), all talking through same class to the database. On distributed installation one process failed to commit a transaction and left it open causing a complete lockup. Trace shows other similar transactions updating and committing so I think the code is sound but for […]
2002-02-04
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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