In this step by step tutorial I will guide you to build the fastest method to display records from the database using plain ASP. The technique we are going to use is based on a simple fact that you don't have to hit database every time you want to display records.
Tag: sql server
By Michael D. Reilly – If you're a Windows 2000 or Windows NT 4.0 systems administrator who has been assigned the task of managing a Microsoft SQL Server system, you might be concerned about how you're going to carry out your new responsibilities. Fortunately, administering SQL Server 2000 a
This 5 day course is packed full of information about SQL Server 2000. The class integrates 3 different levels into one class to give you a wide exposure to the many different components of Microsoft SQL Server 2000.
by Vyas Kondreddi – For a better performing database you need a real DBA and a specialist database programmer, let it be for Microsoft SQL Server, Oracle, Sybase, DB2 or whatever! If you don't use database specialists during your development cycle, databases often end up becoming the performance
How can I program a case-sensitive comparison of a user-typed password on a case-insensitive SQL Server 7.0 instance?
Each chapter has a 2 minute drill which some people may find useful for a last chance review before sitting the exam. Each chapter also has multiple choice questions to test your understanding of the chapter, as found in most study guides.
Pervasive.SQL for DataFlex is a combination of the DataFlex Connectivity Kit for Pervasive.SQL from Data Access Worldwide and Pervasive.SQL from Pervasive Software.
How about this: News that your product has reached $1 billion in annual sales? Now that's a milestone worth celebrating. Ask Steve Murchie he's Microsoft's group product manager for SQL Server Marketing, and Microsoft SQL Server has joined the ranks of products that rake in more than $1
The use of stored procedures is the one area where the Command object comes into its own. A stored procedure (or stored query as it’s sometimes called) is a predefined SQL query stored on the database. So why should we create and use a stored procedure instead of just creating a SQL string on the fl
by Alexander Chigrik – In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 7.0.