Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1095

How to divide query output into multiple groups with the group by clause in ms sql server?

1084

What are the advantages of mirroring?

1041

What is “asynchronous” communication in sql server service broker?

1075

What are the differences between local and global temporary tables?

1125

What is user defined stored procedures?

991

what are the critical issues you have resloved in your company

2015

What is the server name for sql management studio?

1094

What are the differences between sql server and mysql.

1135

What does it mean to normalize data?

995

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1097

explain the storage models of olap? : Sql server database administration

1008

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1027

How to create a testing table with test data in ms sql server?

1139

What is report snapshot in ssrs?

280