We can link any server provided we have the OLE-DB provider
from Microsoft to allow a link. For Oracle we have a OLE-DB
provider for oracle that microsoft provides to add it as a
linked server to the sql server group.

Linked Servers is a concept in SQL Server by which we can
add other SQL Server to a Group and query both the SQL
Server dbs using T-SQL Statements.

SQL Profiler utility allows us to basically track
connections to the SQL Server and also determine activities
such as which SQL Scripts are running, failed jobs etc..

Profiler help us to view the changes happened in the back 
end process.

There are three types of joins: Inner Join, Outer Join,
Cross Join

In some situations we may need to pull data from one or 
more related tables at a time. In such cases we use JOINs 
to extract data from more than one table at a time and 
display the information in a single result set.
There are several types of joins.(1)Inner Join 
                                                   (2)Outer 
Join------Right Outer Join,Left Outer Join, Full Outer Join
Inner join is used to link tables on a common column and 
return records that match in those columns.
Right Outer Join displays all records from the table on 
right most side of the JOIN clause whether or not there are 
matching records in the Left table.
Left Outer Join  displays all records from the table on the 
left most side of the JOIN clause whether or not there are 
matching records on the Right table.
Full Outer Join diplays all records from both right and 
left tables.
Example: If we have a HR database with employee information 
table, salary information table, sick days table etc, and 
if we want to know which employee
have used more than 15 sick days, we would need the 
information form sick days table and employee information 
table in a single result set.

Join actually puts data from two or more tables into a
single result set.

Collation is basically the sort order. There are three types
of sort order Dictionary case sensitive, Dictonary - case
insensitive and Binary.

collation is a set of rules to determine how data is 
sorted  and compared.

Collation refers to a set of rules that determine how data 
is sorted and compared. Character data is sorted using 
rules that define the correct character sequence, with 
options for specifying case-sensitivity, accent marks, kana 
character types and character width.

collation is a set of rules determine the how data is 
sorted and compared.

Case sensitity collation
Accent Sensitity collation
Kane sensitiy collation

Having Clause is basically used only with the GROUP BY
function in a query. WHERE Clause is applied to each row
before they are part of the GROUP BY function in a query.

HAVING CLAUSE is used for evaluating a condition with an 
aggregate function, i.e., GROUP BY whereas WHERE CLAUSE is 
used for general conditions.

In such cases we can first bring to db to single user using
sp_dboptions and then we can rename that db and then we can
rerun the sp_dboptions command to remove the single user mode.

In This case you take following action

1. Alter DataBase <dbname> set single_user with rollback 
immediate

2. Sp_renamedb 'olddb','newdb'

3. Alter DataBase <dbname> set multi_user

 By
Kumar.T

DBCC stands for database consistency checker. We use these
commands to check the consistency of the databases, i.e.,
maintenance, validation task and status checks.

No. We cannot use Truncate command on a table with Foreign
Key because of referential integrity.

Delete command removes the rows from a table based on the
condition that we provide with a WHERE clause. Truncate will
actually remove all the rows from a table and there will be
no data in the table after we run the truncate command.

 Delete Command require Log file updation for each row of 
deleting process. But the Truncate command not.
So, the Truncate Command is so faster than Delete Command. 

Truncate will fail if the concerned table has foreign key 
constraints while delete doesnt.

Truncate is DDL Command while Delete is DML Command

Truncate command result can be rolled back as it is not 
made an entry in the log where as Delete command result 
can't be rolled back

Delete command only delete the rows from the  table but the 
schema of the table yet remains.Whereas Truncate command 
delete the rows along with the tale's schema from the 
memory permanently.

Delete command deletes the data from the tables .. but can 
get back on issue of roll back whereas when you issue 
truncate deletes the records and oracle implicitly issues 
commit command and even when you issue rollback you won't 
get the data back

http://weblogs.sqlteam.com/mladenp/archive/2007/10/03/SQL-
Server-Why-is-TRUNCATE-TABLE-a-DDL-and-not.aspx

Truncate:

 - deallocates the data pages in a table and only this 
deallocation is stored in transaction log

 - aquires only table and page locks for the whole table. 
since no row locks are used less memory is required  (lock 
is a pure memory object)

 - resets identity column if there is one

 - removes ALL pages. NO empty pages are left behind in a 
table

 - fast(er)

 - doesn't fire delete triggers

Delete:

 - removes one row at the time and every deleted row is 
stored in the transaction log

 - aquires table and/or page and row locks for the whole 
table 

 - leaves identity column alone

 - can leave empty pages in a table since empty page 
removal requires a table lock which doesn't necessarily 
happen

 - slow(er)

 - fires delete triggers 


http://weblogs.sqlteam.com/mladenp/archive/2007/10/03/SQL-
Server-Why-is-TRUNCATE-TABLE-a-DDL-and-not.aspx

truncate provide faster processing than delete because of 
truncate does'n require transaction log uddation

From the Network Utility TCP/IP properties ?> Port
number.both on client and the server.

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE 
SERVER
1.	Open the Microsoft SQL Server Enterprise Manager. 
2.	Right-click on your server instance (you may have 
to expand the server groups). 
3.	Choose Properties. 
4.	Under the General tab, click the button 
labeled "Network Configuration". The SQL Server Network 
Utility will be displayed. 
5.	On the right, under the Enabled Protocols, you 
should see TCP/IP. Select it and hit the Properties button. 
6.	The Network Protocol Default Value Setup dialog 
will ask for the Default Port for SQL Server (it will most 
likely be 1433). Changing this entry will change the port 
that SQL Server listens on. Make the change and hit OK to 
close the dialog. 
7.	Hit Apply on the SQL Server Network Utility screen, 
then OK. 
8.	The system will tell you that the changes are 
saved, but that they will not take effect until you stop 
and restart the SQL Server service. Hit OK. 
9.	Hit OK to close the Properties dialog. 
10.	Right-click on your server instance again, and 
choose to stop the SQL Server service. 
11.	Once it has stopped, right-click and choose to 
start the SQL Server service. Restarting it will now use 
the new port.

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE 
CLIENT
1.	Close the ILLiad Client and any Administrative 
tools (Customization Manager, User Manager, etc.). 
2.	On each ILLiad Client machine, go to the ILLiad 
program group and open the Client Network Utility under the 
Networking folder. 
3.	On the right, under the Enabled Protocols, you 
should see TCP/IP. Select it and hit the Properties button. 
4.	The Network Protocol Default Value Setup dialog 
will ask for the Default Port for SQL Server (it will most 
likely be 1433). Changing this entry will change the port 
that ILLiad connects to on the ILLiad/SQL Server. 
5.	Change the entry and hit OK to close. 
6.	Hit OK to close and save the changes

SQL Server runs on port 1433 but we can also change it for
better security.

1433

This command is basically used when we do a large processing
of data. If we do a large amount of deletions any
modification or Bulk Copy into the tables, we need to
basically update the indexes to take these changes into
account. UPDATE_STATISTICS updates the indexes on these
tables accordingly.