Copyright 2021 © QuinStreet Inc. All Rights Reserved
DevX Tips Bank: Database Tuning
Command in SQL
Using EXISTS can improve the performance of your SQL queries.
Rebuild All Table Indexes in a SQL Server Database with One Command
An undocumented stored procedure lets you refresh all the table indexes in a SQL Server …
Two Methods to Remove Duplicates in an ArrayList
Here are two methods that remove duplicates in an ArrayList.
Check for Duplicates in an ArrayList
Use this simple method to check for duplicates in an ArrayList.
Be Careful How You Name SQL Server Stored Procedures
When creating stored procedures in a database other then the Master database, avoid …
Use WITH RECOMPILE Option for Dynamic Stored Procedures
When a stored procedure is first executed (and it does not have the WITH RECOMPILE …
Send Requests Via Stored Procedures
Whenever a client application needs to send Transact-SQL to SQL Server, send it in the …
Be Sure To Clear SQL Server Cache When Performing Benchmark Tests
When tuning SQL Server applications, a certain degree of hands-on experimenting must …
Watch Out For Orphan SQL Server Connections
Orphan SQL Server connections can decrease SQL Server performance. An orphan …
I am receiving this error in my log: connections rejected: no calls allowed for …
Informix Backups Error Message
We have Informix IDS 7.30 running under SCO 5.0.5. Backups by ontape fail with an error: …
Locking a Row
How can I lock a row in a table from a stored procedure?
Dropping a Bad Chunk
I have a bad chunk in a dbspace that is bad and marked "down" by Informix. I don't really …
Validation on Date Inputs
I'm using Web Datablade and IIF to develop Web pages. I need validation (other than …
Temporary Table Creation
What is the advantage of creating temporary tables?
Acceptable Use Policy
Terms of Service
California - Do Not Sell My Information