There are two undocumented encryption functions. They are not supported by Microsoft, and I have had problems with some SQL Server service packs when using these functions. That being said,
By default, SQL Server 7.0 installation sets up SQL Server to run in a case insensitive mode. For most applications this may work great, but there are certain situations were
Certain applications require business logic to determine the last day of the month. This is the case for accounting applications that perform such tasks as invoice processing and customer billing.
When tuning SQL Server applications, a certain degree of hands-on experimenting must occur. Index options, table design, and locking options are items that can be modified to increase performance. When
Whenever a client application needs to send Transact-SQL to SQL Server, send it in the form of a stored procedure instead of a script or dynamic Transact-SQL. This not only
When a stored procedure is first executed (and it does not have the WITH RECOMPILE option), it is optimized and a query plan is compiled and cached in SQL Server’s
The new INSTEAD OF functionality is not exactly like a trigger, but similar. Unlike AFTER triggers, the INSTEAD OF trigger replaces the incoming transaction data modification statement with its own
Orphan SQL Server connections can decrease SQL Server performance. An orphan connection occurs when SQL Server keeps the connection open, even though it is not being used. There are two
This tip is for when you want to place an action after a time gap between two occurrences (for example, to invalidate an unused session after some permitted time, or