You can capture and save data about each event to a file or SQL Server table to analyze later. For example, you can monitor a production environment to see which stored procedures are hampering performances by executing too slowly.
Use SQL Profiler to monitor only the events in which you are interested. If traces are becoming too large, you can filter them based on the information you want, so that only a subset of the event data is collected. Monitoring too many events adds overhead to the server and the monitoring process and can cause the trace file or trace table to grow very large, especially when the monitoring process takes place over a long period of time.
It is often overlooked as one of the main tools for SQL Server management. Its purpose is to ease the implementation of tasks for the DBA, with its full- function scheduling engine, which allows you to schedule your own jobs and scripts. How much level SP nesting is possible? Answer: Yes. Because Transact-SQL supports recursion, you can write stored procedures that call themselves.
Recursion can be defined as a method of problem solving wherein the solution is arrived at by repetitively applying it to subsets of the problem. A common application of recursive logic is to perform numeric computations that lend themselves to repetitive evaluation by the same processing steps. Stored procedures are nested when one stored procedure calls another or executes managed code by referencing a CLR routine, type, or aggregate.
You can nest stored procedures and managed code references up to 32 levels. Answer: Log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server.
Enterprise Editions only supports log shipping. In log shipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and can be used this as the Disaster Recovery plan. The key feature of log shipping is that it will automatically backup transaction logs throughout the day and automatically restore them on the standby server at defined interval.
What are the implications of having it OFF? Answer: A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement. Those particular operators will always evaluate to true or false. Given a table TBL with a field Nmbr that has rows with the following values:. Write a single SQL statement to concatenate all the customer names into the following single semicolon-separated string:.
I have listed all the series in this post so that it can be easily downloaded and used. All the questions are collected and listed in one PDF which is here to download. If you have any question or if you want to add to any of the questions please send me a email or write a comment. Views 5 Downloads 0 File size 1MB. Interview questions and answers It takes a lot of effort and hard work to get to the interview stage, so the last thing.
How to identify what hot fixes and service packs are installed. This is not matter if you are a fresher or Experienced DBA , these questions for all, From very simple to very complex. What are the properties of the relational tables? This is mainly used to capture and save data about each event of a file or a table for analysis. What is recursive stored procedure? SQL Server supports recursive stored procedure which calls by itself. Recursive stored procedure can be defined as a method of problem solving wherein the solution is arrived repetitively.
SQL programming skills are highly desirable and required in the market, as there is a massive use of Database Management Systems DBMS in almost every software application. In order to get a job, candidates need to crack the interview in which they are asked various SQL interview questions.
Following is a curated list of SQL interview questions and answers, which are likely to be asked during the SQL interview. You can even utilize by fill up the rue Dissimilar, passing in the business office to meet with your potential employers, phone interviews leave you to control your own interview surroundings. Sense of province — if you want to get an air air hostess you should realize the sense of province. Your email address will not be published. How do we delete a login?
A login cannot be deleted but only disabled D. In which database state, the database is in single-user mode and may be repaired or restored. All of the above Ans: C 3.
None Ans: A 4. Does not create any index B. DROP database D. Rename database E. What is the syntax for creating new login on the SQL sevrer?
True B. False Ans: B 8. Why type of user is the default in sql server?
0コメント