News
We need Dynamic SQL to build the object from text strings. Another problem to deal with is that the source for some database objects can exceed 32,767 characters, the maximum limit for VARCHAR2 ...
Since SQL Server has many deployment options, like editions, server locations and so on, different situations might need different specific configurations. However, pointing the application to the ...
A business object written with an SQL pass-through has the database server do more record processing. With a pass-through, the server does the subtotals and sends fewer records back to the object.
During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...
xSQL Software, a provider of SQL Server auxiliary tools and utilities, announced today the availability of xSQL Object 1.5, a utility for SQL Server database administrators and developers that ...
Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...
In-depth knowledge of the database objects supported by the DBMS and the physical structures and files required to support those objects. An understanding of how the DBMS supports indexing, ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results