A. SQL Server excludes an ORDER BY clause from a view to comply with the ANSI SQL-92 standard. Because analyzing the rationale for this standard requires a discussion... Read more »
Recompilations might be the source of the slower stored procedure speed. To find out for sure, you need to do some performance investigation, such as looking at... Read more »
You can get a list of tables in a database by calling the INFORMATION_SCHEMA.Tables view like this: SELECT * FROM information_schema.tables This returns the name... Read more »
You can use the DTS object model to programmatically create, modify and run DTS packages. You can do this many ways, but essentially this object model has objects... Read more »
SQL Server has no native command for outputting query results to a file. You can use the extended stored procedure xp_cmdshell and call isql (command-line SQL) with... Read more »
If you want to query the version of SQL Server that’s currently running you can use the @@version variable: SELECT @@version This returns the version, processor,... Read more »
All you need to do is compare the table to itself to find out which candidates are duplicates. Do this by assigning aliases to the table so you can use it twice,... Read more »
To find rows in one set that do not exist in another set, use the except operator (as defined in SQL-92 and SQL-99). For example, here’s how you find column1 from... Read more »
Use the OpenRowSet Function to Run a Query on a Remote SQL Server You can use the OPENROWSET( ) function to run a query on a remote SQL server by using the following... Read more »
STARTUP is the process of starting an instance, presumably with the intent of mounting and opening a database in order to make a database system available for use. To... Read more »
Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would involve... Read more »
A transaction must be: 1. Atomic - it is one unit of work and does not dependent on previous and following transactions. 2. Consistent -... Read more »
The concept of overloading in PL/SQL relates to the idea that you can define procedures and functions with the same name. PL/SQL does not look only at the referenced... Read more »
Equi Join: This is the most common type of join which involves only equality comparisions. The disadvantage in this type of join is that there Read more »
A recovery model is a database property that controls the basic behavior of the backup and restores operations for a database. Recovery models determine how transactions... Read more »
SQL *NET is ORACLE’s mechanism for interfacing with the communication protocols used by the networks that facilitate distributed processing and distributed databases.... Read more »
SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. One can load data into an Oracle database by using the sqlldr... Read more »
The xp_cmdshell extended store procedure makes it possible to execute operating system commands from within SQL Server. Example: EXEC Master..xp_cmdshell ‘Dir... Read more »