How to find trace or log information in sql server ?

For tracking the database for any incidents like droping any objects and event monitoring.

Starting the Trace
EXEC SP_Configure ‘default trace enabled’,1
RECONFIGURE

Stopping the Trace
EXEC SP_configure ‘default trace enabled’,1
RECONFIGURE

To find the trace information for any sql server table

select * from sys.traces where id =1

How to find trace or log information in sql server ? was last modified: October 14th, 2017 by Justin Antony

Query to search for particular column from sql database

Search particular column sql database

You can search for a particular column that present in the list of database tables in sql server.

SELECT
SCHEMA_NAME(SCHEMA_ID) + '.' + TBL.NAME AS TableName,
COL.NAME AS ColumnName
FROM SYS.TABLES AS TBL
INNER JOIN SYS.COLUMNS COL
ON TBL.OBJECT_ID = COL.OBJECT_ID
WHERE COL.NAME LIKE '%ENTER COLUMN NAME%'
ORDER BY 1

 

 

Query to search for particular column from sql database was last modified: October 10th, 2017 by Justin Antony

What are types of storage modes in OLAP?

OLAP storage modes
There are three standard storage modes in OLAP they are
1.MOLAP — the data and aggregations are stored in a multidimensional format
2.ROLAP — data and aggregations are kept in the relational database instead of on the OLAP server
3.HOLAP — HOLAP is a combination of MOLAP and ROLAP HOLAP stores the detail data in the relational database but stores the aggregations in multidimensional format

What are types of storage modes in OLAP? was last modified: October 1st, 2017 by Justin Antony

What is an user defined datatypes(UDD)?

user defined datatypes sql server
User defined datatypes gives a descriptive name and format to the database tables.
example: suppose if a column named Phone with varchar(10) which appears in many tables.
you can create a UDD called Phone_code_Type of varchar(10) and use it across all the tables of the database.

What is an user defined datatypes(UDD)? was last modified: October 1st, 2017 by Justin Antony