Generating HTML Tables
In this article Andy looks at one way you can separate your presentation code from your data when you generate HTML tables for simple reports. Lots of code examples so you can see how it works.
2002-08-05
5,888 reads
ADO
Case Sensitivity and Collations
Hi Hope someone can shed some light on this for me... I have a Sql 2000 installation that a 3rd party vendor requires to be case sensitive. Innitially when i installed the server i specified case sensitive sort order (I believe) When they arrived to perform their tasks i ended up re-installing the machine useing […]
2002-03-22
34 reads
Huge Transaction Log Backup File after a Full Back
Windows 2000 (SP2) SQL 2000 (SP2) DB: 23000 Tables 22 GB Maintenace plan features: 18:00 Reorganization (about 3h40m) 22:00 Integrity Check (about 1h20m) 00:00 Full Backup (about 1h20m it results a file about 22 GB) All these 3 operations are performed once in a week in this order. Daily every hour: Transaction log backup (ready […]
2002-03-22
Linked server against Oracle
How do you set up a linked server against an Oracle database and how is the syntax to query it ?? Lars Bremberg WM-data Public Partner Sweden
2002-03-22
1 reads
Unable to browse the cube
Dear Listers, I'm trying to resolve an access issue that a developer is currently experiencing. I have only just installed AS, and have had no experience with Data Warehousing. When the developer attemtps to connect via XP Excel the following message occurs: 'Excel cannot find OLAP cube 'Balances_All'. Either the OLAP database has been changed […]
2002-03-21
78 reads
Copying DTS Packages To a Different Server
How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!
2006-05-05 (first published: 2002-03-19)
37,917 reads
Shrinking a Log File
I have just inherited a database with a log file size of 3.5GB, but the actual data used in the log file is only about 70MB. I have tried the DBCC SHRINKFILE command, but the log file still will not shrink even after numerous log backups and database backups. Can someone help me here? What […]
2002-03-18
Reducing Round Trips - Part 3
This week Andy continues his series on how to reduce the number of round trips to the server by looking at some things you can easily add to your applications without a lot of rearchitecting.
2002-03-11
7,966 reads
Performance Comparison: Data Access Techniques
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
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
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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