Database Technologies‎ > ‎MSSQL‎ > ‎


Full-Text Search
Full Text Search is used for optimum performance on query like the below

SELECT * FROM NotesTable WHERE Notes Like '%Full-Text Search%'

Implementing Full-Text Search,

1) Create Catalog, to store full text indexes
2) Create Full-text indexex within this catalog
To Rename a database
EXEC sp_renamedb '<old_name>', '<new_name>'

Getting Information About server.

select @@version
select @@servername
select serverproperty('servername')

select @@SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User Name'

select system_user

select user

select @@language as 'language Name'
select @@servicename as 'Service Name'

Difference Between Truncate and Delete

Delete is an DML Statement, whereas Truncate is DDL
At delete Rollback segments / Undo segments gets utilized. At truncate they dont
Triggers get fired on Delete, they dont get fired on truncate