Database Technologies‎ > ‎MSSQL‎ > ‎

Miscellaneous

 
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

Comments