To set the memory limits of the JVM in a Java application, run the program using following switches: java

The following is a VBScript function that will escape an entire SQL string, not just individual field values. This is so that ‘ becomes ” when it’s supposed to. The

This ASP script will enable you to order your database by columns instead of the default by rows, which is not easy on the eye. Due to the way HTML

There is a table called v$session, which is visible if you haveDBA privileges. This table contains an entry for each session connected to the Oracle database. To see who is

Use this code to notify a form that displays another form when the displayed form is closed

Since the operators ++ and — can have two definitions (one for prefix, other for postfix), we should have two ways to overload them.These overloaded fns. are differentiated on the

It is possible to use the PaintPicture Method of the PictureBox or Form by entering different dimensions for source height/width and destination dimensions.Here is a sample:1) Create a new Standard

You may need to execute a portion of code in a function only once the first time it is called. The following fragment illustrates an easy way to do this:

Suppose that we have an object A, whose constructor allocates lots of resources and the destructor frees that. class A{ public: A() { //Allocate resources, memory, handles etc. } ~A()

By sending appropriate messages to a multi-line TextBox control you can read and modify its formatting rectangle – that is, the inner portion of the control where the user can

Private Declare Function GetTempPath Lib “kernel32” Alias “GetTempPathA” (ByVal _ nBufferLength As Long, ByVal lpBuffer As String) As LongFunction TemporaryDirectory() As String Dim buffer As String * 512, length As

Private Declare Function GetClassName Lib “user32” Alias “GetClassNameA” (ByVal _ hWnd As Long, ByVal lpClassName As String, ByVal nMaxCount As Long) As LongPrivate Declare Function GetWindowText Lib “user32” Alias “GetWindowTextA”

Private Declare Function GetWindowText Lib “user32” Alias “GetWindowTextA” _ (ByVal hwnd As Long, ByVal lpString As String, ByVal cch As Long) As LongPrivate Declare Function GetClassName Lib “user32” Alias “GetClassNameA”

Option ExplicitPrivate Declare Function GetStdHandle Lib “kernel32” (ByVal nStdHandle As Long) _ As LongPrivate Declare Function WriteFile Lib “kernel32” (ByVal hFile As Long, _ lpBuffer As Any, ByVal nNumberOfBytesToWrite As

Private Declare Function GetStdHandle Lib “kernel32” (ByVal nStdHandle As Long) _ As LongPrivate Declare Function ReadFile Lib “kernel32” (ByVal hFile As Long, _ lpBuffer As Any, ByVal nNumberOfBytesToRead As Long,

Private Declare Function GetClassName Lib “user32” Alias “GetClassNameA” (ByVal _ hwnd As Long, ByVal lpClassName As String, ByVal nMaxCount As Long) As Long’ Return the class name of the specified

IIS5 enables buffering by default, therefore all the output from your ASP is actually sent to the browser only when the page completes its processing. In many cases this approach

It is especially important to correctly set Windows NT4’s Server service in “Application Server” mode to ensure that the Server service doesn’t absorb all the available hardware resources while providing

The indexing schema plays a fundamental role in performance tuning, and tools such as the Index Tuning Wizard that can suggest efficient schemas on the grounds of a database usage.

At times a database appears to be marked as “suspect” in the Enterprise Manager. SQL Server marks a database as suspect with it can’t access the database. What happens at

Using the sp_user_counterX stored procedure (where X is a number between 1 and 10) you can set internal SQL Server counters. This values are read by the Performance Monitor, the

This article explains how you can create a Microsoft Word document from T-SQL and fax it through a method exposed by its Automation object model. You can create and destroy

The MSDE database engine is 100% compatible with SQL Server and subject to the same license policy of the Jet engine. One of the fundamental differences between MSDE and SQL

SQL Server provides several security levels, and the control that the system administrators can pursue over the DB’s objects is extremely accurate. It’s often useful to know which rights each

One of the neatest features in SQL Server 7 and later versions is the capability to query external data sources through their OLE DB providers, in other words behaving exactly

If you haven’t localized SQL Server for your language, the default date format is the American one: DD/MM/YY. You may need to display a date in different formats, and you