So why an interview question book on SQL Server? If you look at any .NET interview conducted in your premises both parties (Employer and Candidate) pay no attention to SQL Server even though when it is such an important part of development project. They will go talking about stars (OOP, ...
4. I have an instance on which there are databases in both FULL and SIMPLE recovery models. If I restart the sql service, what is the difference between these databases in recovering or what happens while restarting the services? 5. I have a log file which is of 250 GB. Log is full....
Here are listing out few question and answers on installing sql server, lets go through these questions. 1.What are the components installed with the SQL Server 2005 installation? Ans: Server Components SQL Server Database Engine Analysis Services Reporting Services Notification Services Integration Ser...
ALTER INDEX pk_tbl_Students_StudID ON dbo.tbl_Students REBUILD GO SQL Server: You must know about the sys.dm_os_wait_statsSQL Server Interview: How to prevent 'SELECT *' using T-SQL Script? Anvesh Patel Database Engineer ImageFebruary 18, 20177 CommentsSQL Server,SQL Server...
SQL Interview Questions http://career.guru99.com/top-50-sql-question-answers/ 1. What is DBMS? A Database Management System (DBMS) is a program that controls creation, maintenance and use of a database. DBMS can be termed as File Manager that manages data in a database rather than ...
SQL Server books online has enough information on this topic and there is a good white paper available on Microsoft site. 12. Explain the architecture of SQL Server This is a very important question and you better be able to answer it if consider yourself a DBA. SQL Server books online is...
A DB query is a code written in order to get the information back from the database. Query can be designed in such a way that it matched with our expectation of the result set. Simply, a question to the Database.What is subquery?
DBA question It writes all dirty pages for the current database to disk. Dirty pages are data pages that have been entered into the buffer cache and modified, but not yet written to disk.Day11 How does using a separate hard drive for several database objects improves performance right away...
When we execute a query and use theWHEREkeyword on a column that does not have an index, then the SQL Server has to do a full-table scan and check every row to find matches. This is a bad practice because it can be unpredictable in terms of execution time. Therefore this process may...
1. Freeze the service groups on Node A (active node). 2. Confirm all SQL services are stopped on Node B. 3. Upgrade the SQL Server 2008 instance on Node B. 4. Reboot node B. 5. Unfreeze the service group on node A. 6. Fail over the service group to Node B. ...