Group By Column Count limitation
What is the optimum number of columns that can be grouped by in SQL Server 2000 ?
2001-07-13
2 reads
ADO
Work Around Errors in Database Web Apps
ne of the issues you face when building Web applications is handling the errors you encounter when interacting with a back-end database. I was recently working with someone to create a new Web site with SQL Server™, ActiveX® Data Objects (ADO), and ASP. Lots of little things came up that I thought were worth sharing with MIND readers, so I'll focus this column on what I learned from this experience and the solutions to many of the problems I faced.
2001-07-13
1,579 reads
Executing DTS COM
Using VB code generated from scriptpkg, I have created an ActiveX DLL which imports a given data source into a SQL 7.0 table. The Threading Model of the VB project is set to "Single Threaded" and the ExecuteOnMainThread properties (one for the Source Connection, and one for the Destination connection) within the DTS scripting is […]
2001-07-09
2 reads
arabic language support in SQL Server 2000
Hello, I have SQL SERVER 2000 on WINDOWS 2000 ADVANCED SERVER, there is a problem: I use coldfusion language to add data to SQL 2000 Database> .When I open database for retrieve the data the result as : ?????????????????????????? this is because i use ARABIC LANGUAGE and it is a non UNICODE language . -I […]
2001-07-09
24 reads
TEMPDB Sizing
What's the best way to size TEMPDB? Perfmon lets you monitor % Log used and Database size, but not % use don the database. Ou TEMPDB is 2GB for some reason. I was thinking to resize it to something fairly small, say 200-500MB, and set auto-growth on. Thanks Jay
2001-07-06
15 reads
Taming the Stateless Beast: Managing Session State
Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.
2001-07-06
1,721 reads
SQL Server 2000 Improvements
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/rsharma/sqlserver2000improvements.asp
2001-07-05
Using Stored Procedures from ADO 2.1
If you’re running database-intensive code from Visual Basic or ASP, stored procedures can give you a great speed boost. With ADO 2.1, one of the components that makes up MDAC, this technique is easier to implement than ever.
2001-06-29
1,967 reads
Missing Temp Tables
In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?
2001-06-01
4,182 reads
Prove Your Case and Win a Buck!
Your database design should be impervious to this documented behavior of the ADO delete method. Be one of the first five members to give a compelling reason why not, and take a dollar from starving columnist Sean Burke.
2001-05-21
3,322 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