What is data modeling with example?

713

How can you fix a poorly performing query?

864

What is DB Development software?

1815

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2627

What are the three basic rules which are to be followed for the relational model of the database?

767

What is an application role and explain a scenario when you would use one?

773

fact table and dimension table containg one to many relationship or many to one relastionship

2275

How is data stored in dbms?

706

How can you log an error to the server event log from a stored procedure?

811

How to generate OIDS

1906

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

758

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

807

How to read and create .LDC data files which are used by linguatic dictionary.

2283

What is database design and development?

797

What are the constraints on severity level in raiseerror?

767