Determine when an index is appropriate?

1073

How to convert a numeric expression from one data type to another?

1011

What will be query used to get the list of triggers in a database?

998

Can group by be used without aggregate functions?

914

How check triggers in sql server?

987

What is indexed view? How to create it?

994

How to truncate the log in sql server 2012? : sql server database administration

1280

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1168

Data table as parameter in sql server?

1041

What are sub reports?

201

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

912

How to create a user to access a database in ms sql server using "create user" statements?

948

How to attach adventureworkslt physical files to the server?

1104

What are group functions in query statements in ms sql server?

1001

Explain view in sql server?

1052