What is RDBMS? RDBMS stands for Relational Database Management System. It organizes data into related rows and columns. Features:- It stores data in tables. Tables have rows and column. These tables are created using SQL. And data from these tables are...
What is TRANSLATE Function in SQL? Replaces the Characters in a string with required set of characters. It Replaces one character at a time. It Translate character by character Example: SELECT ' TECHBLOG' STRING, TRANSLATE('TECHBLOG','TECH','SQL') TRANSLATE...
What is REPLACE Function in SQL? Replaces the Characters in a string with required set of characters. It Translate Pattern by Pattern. Example: SELECT ' TECHBLOG' STRING, REPLACE('TECHBLOG','TECH','SQL') REPLACE FROM DUAL; WHERE ENAME LIKE'%A%'; STRING...
Replace used for String where as Translate used for Character. Replace Replaces entire string at a time where as Translate Replaces character one-to-one basis Replace Function replaces single character with multiple characters where as Translate Function...
DENSE_RANK NTILE RANK ROW_NUMBER DENSE_RANK The DENSE_RANK Function is one of the SQL Server ranking function. This function will assign the rank number to each record present in a partition without skipping the rank numbers. SQL DENSE_RANK Function Syntax...
SQL SQL Server 2014 Create Database SELECT Statement WHERE Clause ALIAS Column ORDER BY Clause TOP Clause SELECT DISTINCT Statement SELECT INTO Statement INSERT INTO SELECT Statement GROUP BY Clause HAVING Clause BULK INSERT Statement SQL Query Builder...
How to recover a database from suspect mode ? Step 1: Open SQL Server Management Studio and connect to the SQL Server. Make sure that your current database is set to master Step 2: Clear the suspect mode of the database using sp_resetstatus DatabaseName....
What are the reasons for the database to be in suspect state? 1) Data and Log files missing 2) Corruption of pages in the Data files. 3) Issues that are caused during Recovery/Restoring process 4) Disk level failures 5) SNA drives are missing
SQL Database in Suspect Mode What are the reasons for the database to be in suspect state? 1) Data and Log files missing 2) Corruption of pages in the Data files. 3) Issues that are caused during Recovery/Restoring process 4) Disk level failures 5) SNA...
SQL Memory issue Memory Issues It can be external or internal. Physical – External - Physical RAM may be low and SQL Server detects and reduce the commit charge of the buffer pool. Internal –Responding to external memory pressure Changed memory settings...
