Tag: databases

SQL Server uses a random port

1433

1433 and 1434

It depends; the port can be chosen by an administrator

Add a TIMESTAMP column to the table; SQL Server will automatically track date and time of every change.

Add a DATETIME column to the table and assign getdate() as the default value.

Add a DATETIME column to the table and write a trigger that sets its value.

Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server's built functions

Next Sunday relative to @MyDateTime

Only date part of @MyDateTime

Only time part of @MyDateTime

Doesn't work because you cannot cast float to datetime

All of them. Permission set SAFE just restricts the use of unmanaged code

None. To use classes from the .NET Framework in SQL Server you need at least permission set EXTERNAL

Some of them are tested specifically for the use within SQL Server, they can be used

Permission sets have nothing to do with SQLCLR

A few seconds

Approximately 5 minutes

Usually approximately one hour; depends on the load on the server

More than one hour but it is running in the background

The user had to have knowledge of the table and index structures

Navigational data access was far slower than declarative access.

Navigational access languages required the coder to embed their queries inside a procedural language shell.

Navigational languages were far slower then SQL

SQL cannot support object-orientation

The same query can be written in many ways, each with vastly different execution plans.

SQL syntax is too difficult for non-computer professionals to use

SQL creates excessive locks within the database

Independence of table relationships

High speed of SQL

Powerful GUI front-end

Easy to install and use

The number of CPUs on the server

The degree of parallelism on the tables

The use of bitmap indexes

The quality of the SQL optimization

Removal of data redundancy

The introduction of data redundancy

The introduction of non-first normal form relations

The introduction of SQL*Plus