What is the difference between value type and reference type?

919

What are the basic features of a trigger in ms sql server?

1193

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2521

What is acid properties?

1097

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2236

What options are available to audit login activity? : sql server security

1152

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1163

Can group by and orderby be used together?

1013

What are “phantom rows”?

1657

Explain what is dbcc?

1010

What is the function of inner join?

1072

How does normalization work?

917

What is cursor in ms sql server?

1144

What is normalization? What number of normalization shapes are there?

1108

Does the unique constraint create an index?

1056