what are database files and filegroups? : Sql server database administration

945

What do you understand by a view?

996

What is create statement?

951

What is sub query and its properties?

974

Create and insert into temp table in sql server?

1031

Where are stored procedures in sql server?

1065

What happens if null values are involved in comparison operations?

971

How do you set a trace flag in sql server?

1035

How to filter out duplications in the returning rows in ms sql server?

1140

How can you find out how many rows returned in a cursor?

1029

How to get the definition of a trigger back?

1002

What are the encryption mechanisms in sql server?

1028

Can group by and orderby be used together?

1013

Where are sql server user names and passwords stored in sql server?

1090

What are the advantages to use stored procedures?

1109