Explain the steps to perform Table Partitioning and best practices? (Video Answer)
How would you determine the version and Edition of SQL Server Instance you are working on? (Video Answer)
What are the steps to Restore a SQL Server Database to a Point in Time? (Video Answer)
How would you shrink the tempdb database in SQL Server? (Video Answer)
Which built in tool you have used to Monitor SQL Server activity? (Video Answer)
How would you identify table level locks in SQL Server? (Video Answer)
What is isolation level and what are four types of them? (Video Answer)
If you need to query Oracle database from SQL Server, how would you do that? (Video Answer)
What are the differences between DMV's and DMF's? (Video Answer)
The tran log of a database has grown huge, How would you shrink the log file? (Video Answer)
What are the important points you consider before coming up with Backup strategy? (Video Answer)
You have installed SQL Server Instance on Window 2008 Server. Total Memory of Server is 64 GB but you need to assign only 12 GB to SQL Server Instance, how would you do that? (Video Answer)
What is the difference Between Index Rebuild and Index Reorganize? (Video Answer)
How would you create a SQL Server Agent job that only should run on 5th business day of each month? (Video Answer)
You have provided some permission on a Database to a users, but user is not able to connect to that Database. Where will you see the error details in SQL Server? (Video Answer)
You have a big database, Before taking the full backup you want to estimate the total time for backup. How would you do that?
Your company has found out that the account SQL Services are running is not what it should be. They want you to change to Service account, How would you do that? (Video Answer)
What is the differences between differential database backup and Transaction log backup? (Video Answer)
What permissions will you grant to a users in SQL Server database, so He/She can truncate table?
What are DDL Triggers? Where and why have you created them? (Video Answer)
How would you perform Schema comparison between two databases? (Video Answer)
You need to perform Data Comparison between two tables,How would you do that? (Video Answer)
You need to backup all the logins and Jobs, How would you do that? (Video Answer)
You have installed Name Instance of SQL Server, After installation you realized that you misspelled the instance name. Can you correct the name of SQL Server Instance without re- installation?
You have installed SQL Server instance on Windows 2008 (MyServerName\MySQLInstance). If your want to change the computer name to only ServerName, Will SQL Server Instance will or You have to re-install SQL Server Instance?
What is DAC (Dedicated Administrator Connection) ? Is it enabled or disabled by default? Why and where we use this feature?
You need to create full backup of all the databases from one of the SQL Server Instance every night. If any new database is created that should also become the part of backup process. What would be your approach to perform this? (Video Answer)
All the sudden, users start complaining that the SQL Server is running slow. What steps you would take to analysis the problem? (Video Answer)
What is by default SQL Server Agent Job history Retention? If you need to keep two week of history for each of the job what steps will you take when some of the jobs run every five minutes and some run one time a day? (Video Answer)
If you need to find all the processes running by specific login, How would you do that? (Video Answer)
How would you find out how many transactions/second SQL Server Instance is performing? (Video Answer)
How would you find currently running queries on SQL Server Instance? (Video Answer)
How would you find orphan users and fix them? (Video Answer)
How would you script user with permission from a SQL Server Database?
Your company has a Database for which the Tran Log grows very fast. What strategies you should adopt to keep the Tran log reasonable? (Video Answer)
What is the difference between Actual Execution plan and Estimated Execution plan? (Video Answer)
What is the difference between Differential Backup and Full Backup? (Video Answer)
What are two Server Authentication modes available in SQL Server? (Video Answer)
If you have installed SQL Server Instance with Windows Authentication Mode and later you want to change to Mix Mode (SQL Server and Windows Authentication Mode), How would you do that and does it require service restart? (Video Answer)
What is the difference to Restore database "Restore With NoRecovery" and "Restore With StandBy"? (Video Answer)
What are major differences between SQL Server 2005 and SQL Server 2008 version?
What are the major difference between SQL Server 2008/R2 and SQL Server 2012 version?
What is the difference between Full Backup and Copy option in Full Backup? (Video Answer)
How would you find out that How long SQL Server Instance is running? (Video Answer)
What is the difference between Physical and Logical Reads? (Video Answer)
Does SQL Server allow duplicate indexes ( indexes with different name but same definition)? If yes, How would you find them and keep only one of them? (Video Answer)
What is the difference between shrinking and truncating database log file? (Video Answer)
What are the best practice to configure TempDB? (Video Answer)
What is Latch? What is the difference between Latch and Lock? (Video Answer)
What is the difference between Schema and Database?
Can you schedule replication? And under what circumstances do we schedule replication? (Video Answer)
Your team needs to know if replication breaks/fails, what exactly would you do to accomplish that? ( Video Answer)
What is re-initializing means in replication? (Video Answer)
Under what circumstances will you re-initialize replication? (Video Answer)
How would you add new tables in existing replication? (Video Answer)
Can you explain what would be the replication overhead on production server? (Video Answer)
Transactional replication is set on production source, article schema changed on source but target is not showing that change, what exactly is the issue? (Video Answer)
How will you truncate the replicated table? (Video Answer)
You have setup AlwaysOn and send application team to connect with SQL server using Listener, application can't connect with Listener name, what could be the issue?
Can you configure Listener using static port? (Video Answer)
Listener port is set to 1533, can you connect to SQL server using Listener name? (Video Answer)
Availability Group is in resolving state, what does it mean? (Video Answer)
What is Contained Database? In which version of SQL Server they were introduced? (Video Answer)
What is Policy- Based Management in SQL Server? (Video Answer)
How would you identify the isolation level used by the query when dead lock occurs? (Video Answer)
What is FileTable Feature in SQL Server, How does it works? (Video Answer)
You need to import large amount of data to tables in a database, you want to keep the transaction log size small while import the data, How would you do that? (Video Answer)
You need to save passwords in SQL Server Table, What type of encryption would you use?
For what purpose do you use Dynamic management views?
You have 35 Databases on one of the SQL Server instance, You need to create process to take full backup nightly and transaction log backup every hour, how would you do that? (Video Answer)
You need to store and manager unstructured data in SQL Server, Which approach you would use it? (Video Answer)
What is the difference between FileStream and FileTable?
You have a Server that has 24 processors, You need to install multiple SQL Server instances on it.What method you will use to allocate processors to each instance depending upon the requirement? (Video Answer)
Suppose you have a big table with million of rows. You need to provide a solution in which the most recent data should be stored on fastest storage and old data on slow storage, What solution would you provide for this scenario? (Video Answer)
