Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
929Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
928Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
976
How do I view a trc file?
How many replicas are maintained for each sql azure db?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is exporting utility?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
Define views.
What happens if we shrink log file in sql server?
Explain about builtinadministrator?
List the different index configurations possible for a table?
What is the use of @@spid?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What command must you use to include the not null constraint after a table has already been created?
What is store procedure?
What is the command used to check locks in microsoft sql server?
Explain filtered indexes benefits?