Posts

SQL BASICS AND DBCC COMMANDS

-
Restore Database ü   “If the database being restored does not exist, the user must have CREATE DATABASE permissions to be able to execute RESTORE. If the database exists, RESTORE permissions default to members of the  sysadmin  and  dbcreator  fixed server roles and the owner ( dbo ) of the database.” ü   “RESTORE permissions are given to roles in which membership information is always readily available to the server. Because fixed database role membership can be checked only when the database is accessible and undamaged, which is not always the case when RESTORE is executed, members of the  db_owner  fixed database role do not have RESTORE permissions.” Backup ü   BACKUP DATABASE and BACKUP LOG permissions default to members of the   sysadmin   fixed server role and the   db_owner   and   db_backupoperator fixed database roles. ü   Ownership and permission problems on the backup device's phy...
Post a Comment
Read more

Slow running query2

-
How to troubleshoot slow-running queries  Tuning database queries can be a multi-faceted endeavor. The following sections discuss common items to examine when you are investigating query performance. Note If you are using SQL Server 2005, use SQL Server Management Studio instead of SQL Query Analyzer, and use Database Engine Tuning Advisor instead of the Index Tuning Wizard. Verify the Existence of the Correct Indexes One of the first checks to perform when you are experiencing slow query execution times is an index analysis. If you are investigating a single query, you can use the Perform Index Analysis option in SQL Query Analyzer; if you have a SQL Profiler trace of a large workload, you can use the Index Tuning Wizard. Both methods use the SQL Server query optimizer to determine which indexes would be helpful for the specified queries. This is a very efficient method for determining whether the correct indexes exist in your database. For information about how t...
Post a Comment
Read more

SQL DBA Interview Questions 2018

-
SQL DBA 2018 Latest interview questions?. If Database size is 500GB then what is TempDB Size in that Server? Why Restore job is taking long time compare to before log restore in logShipping? What are the Tempdb enchancements in 2016 sql server? If TUF is corrupt in logShipping what Happend? What are the 2016 new features? what is StrechDB? Model database is Correpted on that time Instance running fine. After restrting the istance is not responding why?How you will resolve? What is CXPAKET? What is AlwaysOn? What is the basic requiremets to configure AlwaysOn? Can you configure One listner to multiple AG Groups? if yes How? If no why? Can you explain How AlwaysOn Ag work flow? What are the DMV's using in Daily? Can you list out few regular XP's your using? what are the DBCC commands your using?
Post a Comment
Read more