Log In
Sign Up
Snippet
Articles
Tutorial Docs
Video
Certification Practice
Interview Q/A
Tools
Hena Parveen
0 Followers
Posts
820
Comments
0
Likes
Views
3.69218M
My Badges
My interview questions and answers
820
Name at least three output columns of sp_monitor?
4513
0
2
0
What is ‘sp_refreshdatabase’ from ‘SourceBackup.bak’....
4476
0
2
0
What is the use of sp_refreshview?
4502
0
2
0
What is the difference between EXEC and sp_executesql?
4497
0
2
0
What is the purpose of sp_cycle_errorlog?
4401
0
2
0
How can you change the option of AUTO_UPDATE_STATESTICS?
4497
0
2
0
What is the difference between sp_clean_db_free_space and DB....
4864
0
2
0
What are the permissions required to run sp_who or sp_who2?
5596
0
2
0
Which status is reset by sp_resetstatus?
4563
0
2
0
What is the difference between sp_rename and sp_renamedb?
4541
0
2
0
Explain the usage of below procedures
4529
0
2
0
Can you name 5 undocumented Stored procedures that you have ....
4514
0
2
0
What is the difference between Stored Procedure and Functio....
4600
0
2
0
What are stored procedures?
4537
0
2
0
How can you Suppress BACKUP COMPLETED log entries going to W....
4540
0
2
0
How can you stop sending backup entries into MSDB?
4501
0
2
0
Which trace Forces DBCC HELP to return syntax of undocumente....
4518
0
2
0
Which trace is used with DBCC CHECKTABLE to see the total co....
4426
0
2
0
Which Trace is used with DBCC CHECKTABLE to see the total co....
4536
0
2
0
How do you collect Statistics for system tables?
4460
0
2
0
How do you equally distribute data in all data files or make....
4516
0
2
0
How do you disable read ahead for the server or current conn....
4588
0
2
0
How do you enable full output when using the SET SHOWPLAN_AL....
4407
0
2
0
How do you print information about the cost of using a non-c....
4570
0
2
0
How do you prevent ad-hoc query plans to stay in cache?
4520
0
2
0
How can you disable SELECT permission for DBCC SHOW_STATISTI....
4493
0
2
0
What are different types of Traces?
4453
0
2
0
How can you find out all active trace flags on a SQL server ....
4572
0
2
0
How to enable or disable a trace flag?
4509
0
2
0
What are trace flags?
4525
0
2
0
What are the most important DMVs\DMFs from a DBA perspective....
4459
0
2
0
Which DMVs are useful to gather information about database m....
4531
4
2
0
Name few database related DMVs:-
4466
0
2
0
Mention some SQL OS related DMVs\DMFs.
4508
0
2
0
Name some Security related DMVs\DMFs.
4460
0
2
0
Which DMV give me query plan or I will use old method to fin....
4572
0
2
0
How are DMV’s and DMF’s changing the memory consumptions....
4517
0
2
0
What permission does a user need to access the DMV’s
4607
0
2
0
How can DMVs help with performance tuning?
4457
0
2
0
What is the effect of DBCC CHECKDB and DBCC DBREINDEX on the....
4512
0
2
0
Can anyone predict how long DBCC Check DB will run on any da....
4522
0
2
0
How can you check if any transaction is running on a databas....
4488
0
2
0
Explain DBCC TRACEON & DBCC TRACEOFF?
4427
0
2
0
Which DBCC command is used to store the Procedure cache rela....
4591
0
2
0
Which DBCC command is used to shrink database files?
4494
0
2
0
What is use of DBCC DBREINDEX?
4574
0
2
0
List 5 important DMVs for Index analysis.
4519
0
2
0
Why does RUNNABLE transition into RUNNING?
4454
0
2
0
Why does SUSPENDED transition into RUNNABLE?
4490
0
2
0
Why does RUNNING transition to SUSPENDED?
4510
0
2
0
While viewing activity on SQL Server, for example, sp_who2 ....
4613
0
2
0
List few DMVs for space usage related information?
4535
0
2
0
Explain DBCC inputbuffer()?
4549
0
2
0
How many types of DMVs are there?
4451
0
2
0
What are all the SQL Server Dynamic Management Views(DMV) an....
4580
0
2
0
What is the exact use of DMVs?
4487
0
2
0
Can you explain DBCC Check DB?
4540
0
2
0
What is back process for the DBCC?
4518
0
2
0
What are the DMV’s in SQL Server?
4577
0
2
0
What is the use of DBCC commands?
4523
0
2
0
What are the benefits of Column Stored index?
4439
0
2
0
Various types of compression in SQL Server database?
4519
0
2
0
What are the Limitations and Restrictions of Data Compressio....
4552
0
2
0
What all database objects can be configured with Data compre....
4504
0
2
0
What is data compression in a SQL server database?
4569
0
2
0
What is SORT_IN_TEMPDB option while creating or rebuilding a....
4529
0
2
0
How can we identify Index usage history?
4552
0
2
0
Which DMV is used to identify missing Indexes in a database?....
4492
0
2
0
What are missing indexes in a database?
4504
0
2
0
How to resolve Fragmentation for a heap table?
4472
0
2
0
What is the difference between Online and Offline operations....
4577
0
2
0
How to resolve Fragmentation in Indexes?
4545
0
2
0
What all modes are available to get a report about Index fra....
5044
0
2
0
How to get information about the Index Fragmentation in a da....
4549
0
2
0
How External Fragmentation occurs?
4470
0
2
0
What is External Fragmentation?
4499
0
2
0
How Logical Fragmentation occurs?
4465
0
2
0
What is Logical Fragmentation?
4499
0
2
0
How Internal Fragmentation occurs?
4526
0
2
0
What is Internal Fragmentation?
4506
0
2
0
How many types of Index Fragmentation are there in SQL Serve....
4515
0
2
0
What are the Causes of Index Fragmentation?
4430
0
2
0
What is Index Fragmentation?
4515
0
2
0
Can we have indexes on Views?
4520
0
2
0
What is Pad index in Index?
4611
0
2
0
How to set Fill Factor?
4521
0
2
0
What are Points to remember while using the FILLFACTOR Argum....
4513
0
2
0
What is Fill factor in indexes?
4549
0
2
0
What are the Disadvantages of Indexes?
4484
0
2
0
What are the Advantages of Indexes?
4504
0
2
0
What is the Heap?
4446
0
2
0
How many maximum columns can be a part of on an index?
4441
0
2
0
What is the Maximum Number of Index per Table?
4491
0
2
0
Why can there be only one Clustered Index and not more than ....
4542
0
2
0
Can we Insert Data if Clustered Index is disabled?
5138
0
2
0
How to Enable Indexes?
4565
0
2
0
How to Disable Indexes?
4511
0
2
0
Explain the structure of Index in SQL server?
4534
0
2
0
How to create a multi-column index in SQL Server database? ....
4528
0
2
0
What are the different index configurations a table can have....
4586
0
2
0
By default which index is created when we create a Unique Ke....
4534
0
2
0
By default which index is created when we create a Primary K....
4527
0
2
0
What is FOREIGN KEY constraint?
4497
0
2
0
What is UNIQUE KEY constraint?
4587
0
2
0
What is PRIMARY KEY constraint?
4511
0
2
0
What is an Alternate Key?
4520
3
2
0
What is a Candidate Key?
4558
0
2
0
What is a Super Key?
4548
0
2
0
What is the difference between Cluster and Non Cluster Index....
4410
0
2
0
What is a Full text index?
4510
0
2
0
What is an XML index?
4848
0
2
0
What is spatial index?
4563
0
2
0
What is Filtered index?
4809
0
2
0
What is Index with Included columns?
4546
0
2
0
What is Column-store index?
4600
0
2
0
What is Unique Index?
5250
0
2
0
What is Non-Cluster index?
4517
0
2
0
What is Cluster index?
4553
0
2
0
What are the various Types of indexes available in SQL Serve....
4527
0
2
0
What is an Index?
4484
0
2
0
How merry-go-round scanning is associated with SQL Server?
4516
0
2
0
What are the performance related benefits which are availabl....
4558
0
2
0
What is SQLIOSim tool?
4587
0
2
0
What is SQLIO tool?
4615
0
2
0
What are the components of SQL Server scheduler?
4614
0
2
0
What is the difference between preemptive and non-preemptive....
4628
0
2
0
What is a scheduler in SQL Server?
4573
0
2
0
How can we update the statistics on a table?
4513
0
2
0
How to check when the statistics were updated for a table.
4539
0
2
0
What is the impact of stale statistics over database perform....
4525
0
2
0
What’s New in SQL Server 2012 with Respect to Statistics?
4580
0
2
0
What conditions trigger “Auto UpdateStatistics” process....
4557
0
2
0
What is “Auto UpdateStatistics” properties of a SQL Ser....
4605
0
2
0
What is “Auto Create Statistics” properties of a SQL Se....
4529
0
2
0
What kind of information is stored by Statistics?
4481
12
2
0
What are various types of SQL server database statistics?
4489
0
2
0
What are statistics in SQL Server?
4462
0
2
0
What is the Query below gives the amount of worker threads c....
4523
0
2
0
What is the shortcut key to invoke Task manager?
4497
0
2
0
What is Halloween protection?
4484
0
2
0
How LRU K algorithm is associated with SQL Server?
5919
0
2
0
What is Row versioning?
4564
0
2
0
What is Optimistic and pessimistic locking?
4466
0
2
0
What is non buffer latch?
4518
0
2
0
What is buffer latch?
4554
0
2
0
What are the types of latches?
4470
0
2
0
What are the advantages of Dynamic Locking in SQL Server?
4423
0
2
0
What is a latch?
4447
0
2
0
What is Dynamic Locking?
4460
0
2
0
What is the most restrictive lock?
4492
0
2
0
What is the least restrictive type of lock?
4471
0
2
0
How can we disable Lock escalation in SQL Server?
4663
0
2
0
Is it possible to disable Lock escalation in SQL Server?
4512
0
2
0
What is lock escalation?
4585
0
2
0
What triggers lock escalation?
4534
0
2
0
What is BULK UPDATE lock?
4578
0
2
0
What is KEY RANGE lock?
4523
0
2
0
What is SCHEMA lock?
4495
0
2
0
What is INTENT lock?
4542
0
2
0
What is EXCLUSIVE lock?
4473
0
2
0
What is SHARED lock?
4543
0
2
0
What are the different types of lock modes in SQL Serve?
4487
0
2
0
What is a lock?
4467
0
2
0
What are the various workarounds to overcome this problem?
4492
0
2
0
• Query Hintstell the optimizer to apply this hint through....
4506
0
2
0
What are various types of Hints available in SQL Server?
4501
0
2
0
What are HINTS in SQL Server Query
4524
0
2
0
In which Isolation level dirty reads occur?
4461
0
2
0
What are Phantom reads?
4545
0
2
0
What are dirty reads?
4479
0
2
0
What is controlled by Transaction isolation levels?
4532
0
2
0
What is the default Isolation level of SQL Server databases?
4488
0
2
0
What is SNAPSHOT Isolation Level?
4441
0
2
0
What is SERIALZABLE Isolation Level?
4481
0
2
0
What is REPEATABLE READ Isolation Level?
4506
0
2
0
What is READ UNCOMMITTED Isolation Level?
4555
0
2
0
What is READ COMMITTED Isolation Level?
4519
0
2
0
How many types of Isolation levels are available in SQL Serv....
4469
0
2
0
What is Isolation level in SQL Server?
4552
0
2
0
If major bulk data deletion/insertion activity happened last....
4438
0
2
0
How can you check last patching activity status of SQL Serv....
7269
0
2
0
If you know that a feature of an application is performing ....
4480
0
2
0
What are unused indexes and how can they be identified?
4497
0
2
0
What are missing indexes and how can they be identified?
4475
0
2
0
How do you check the fragmentation level?
4422
0
2
0
What is the key parameter for decision making about Rebuildi....
4517
0
2
0
What is difference between Reorganizing and Rebuilding index....
4468
0
2
0
How can you check stats information?
4474
0
2
0
What is wait time; signal wait time & resource wait time?
4500
0
2
0
how do you check Wait stats?
4454
0
2
0
How do you check blocking, locking or suspended connections?
4446
0
2
0
How do you check SQL Server error logs and Event Logs?
4470
0
2
0
How do you monitor resource usages?
4445
0
2
0
What are SQL Server Extended Events?
4480
0
2
0
What is SQL Server Performance Dashboard?
4490
0
2
0
What is SQL Server Database Tuning Adviser (DTA)?
4503
0
2
0
How can Server Profiler trace help while troubleshooting Pe....
4513
0
2
0
How can SQL Server Management Studio help while troubleshoo....
4481
0
2
0
How SQL Server can be forced to use a specific query plan.
4522
0
2
0
Please explain why SQL Server does not select the same query....
4529
0
2
0
How deadlock is a performance problem and some techniques to....
4480
0
2
0
How a deadlock can be identified?
4470
0
2
0
Explain a SQL Server deadlock
4514
0
2
0
Name three different options to capture the input (code) for....
4501
0
2
0
Can you please name different approaches to capture a query....
4526
0
2
0
Explain the NOLOCK optimizer hint and some pros\cons of usin....
4506
0
2
0
True or False – It is always beneficial to configure TempD....
4520
0
2
0
What is a query plan and what is the value from a performan....
4528
0
2
0
True or False – It is possible to correlate the Performanc....
4566
0
2
0
How do I configure the Max Degree of Parallelism at the serv....
4502
0
2
0
Can we add or drop a single article from a publication. If s....
4533
0
2
0
What is Max Degree of Parallelism or MAXDOP?
4621
0
2
0
Give some examples of DBCCs related to SQL Server Cache?
4496
0
2
0
How can you clear plan cache?
4438
0
2
0
What is Caching Mechanisms?
4518
0
2
0
What is index Scan?
4447
0
2
0
What is index Seek?
4438
0
2
0
Can you create a Non cluster index on primary key?
4415
0
2
0
What is Index with included columns?
4496
0
2
0
What are the different types of indexes in SQL Server 2012 V....
4433
0
2
0
What are indexes?
4403
0
2
0
Why is it important to avoid functions in the WHERE clause? ....
4519
0
2
0
Can you please name three DMVs that you have used recently w....
4355
0
2
0
How can DMVs help with performance tuning?
4466
0
2
0
What is server side trace?
4517
0
2
0
Will you advise to leave a profiler trace running on forever....
4483
0
2
0
Should you always leave a profiler trace running on a produc....
4447
0
2
0
What is the use of profiler while dealing with performance i....
4470
0
2
0
How far behind is the Distribution Agent? Should I reinitia....
4540
0
2
0
Does replication affect the size of the transaction log?
4574
0
2
0
How can grants on the subscription database be configured to....
4463
0
2
0
Does replication work over low bandwidth connections? Does ....
4479
0
2
0
Can multiple publications use the same distribution database....
4426
0
2
0
Is it possible to have 2 publications with one table in com....
4466
0
2
0
How can I prevent the snapshot agent failing with ‘Server....
4476
0
2
0
What are the differences between 32 and 64 bit replication?
4473
0
2
0
How can I ensure that triggers fire during initialization?
4501
0
2
0
How can Replication Alerts be written to Event Viewer?
4505
0
2
0
How can I see the text for ‘sys.sp_MSrepl_helparticlecolum....
4503
0
2
0
How can I have redundancy for the publishing database?
4494
0
2
0
How can I add a “NOT NULL” column to an existing article....
4521
0
2
0
What should I do if my system is running out of memory when ....
4582
0
2
0
My replication monitor incorrectly shows a failed publicatio....
4541
0
2
0
What is a “Global Subscriber”?
4435
0
2
0
What is a “Local Subscriber”?
4585
0
2
0
In Merge replication, for the conflict resolver: I have a ro....
4515
0
2
0
Is it possible to subscribe to specific articles in a public....
4463
0
2
0
What Options we use to secure Replication Data?
4526
0
2
0
What are advantages of Peer-Peer Replication?
4467
0
2
0
Have you considered static row filters?
4480
0
2
0
Do you set the “Replicate Schema Changes” subscription o....
4510
0
2
0
In Transactional Replication, If we drop a column in a table....
4532
0
2
0
In Transactional replication, If a table in database ‘A’....
4479
0
2
0
Is there a need to stop activity on a database when it is pu....
4489
0
2
0
How will you monitor replication activity and performance?
4370
0
2
0
If I create a publication with one table as an article, and ....
4535
0
2
0
Data is not being delivered to Subscribers, what can be the ....
4550
0
2
0
What options are available to delete rows on the publisher a....
4540
0
2
0
s it possible to run multiple publications and different typ....
4523
0
2
0
How do I move or rename files for databases involved in repl....
4548
0
2
0
Does replication resume if a connection is dropped or do we ....
4520
0
2
0
What is NOT FOR REPLICATION option for table constraints?
4550
0
2
0
Why can’t I run TRUNCATE TABLE on a published table?
4499
0
2
0
What is the effect of running a bulk insert command on a re....
4538
0
2
0
Does replication encrypt data?
4470
0
2
0
Can multiple publications use the same distribution database....
4502
0
2
0
Can the same objects be published in different publications....
4524
0
2
0
What recovery model is required on a replicated database?
4500
0
2
0
Are tables locked during snapshot generation?
4505
0
2
0
Please underline the complications involved in using replica....
4471
0
2
0
Are logins and passwords replicated?
4446
0
2
0
Can we rename a database used in Publication or subscription....
4565
0
2
0
What are data type concerns in transactional replication?
4527
0
2
0
What is conflict resolution in merge replication.
4513
0
2
0
What is peer to peer replication.
4567
0
2
0
What are the advantages and disadvantages of Snapshot replic....
4558
0
2
0
Name some commonly used Replication DMVs and their use.
4501
0
2
0
What permissions are needed to a user to monitor replication....
4499
0
2
0
Explain Latency in replication. How can you monitor Latency ....
4436
0
2
0
Can we use replication to replicate data across different R....
4522
0
2
0
Define sp_replcounters
4502
0
2
0
Define Article, Publication & Subscription.
4561
0
2
0
Define Distributor, Subscriber & Publisher
4530
0
2
0
Difference between push and pull replication.
5902
0
2
0
What are prerequisites of transactional replication?
4581
0
2
0
Why is primary key needed in Transactional replication?
4475
0
2
0
What are various Agents of replication?
4456
0
2
0
What are types of replication?
4451
0
2
0
What is replication?
4471
0
2
0
What are the benefits of Always on feature?
4513
0
2
0
Does AlwaysOn Availability Groups repair the data page corru....
4640
0
2
0
What is read intent option?
4470
0
2
0
Can we manually fail over to a secondary replica?
4506
0
2
0
Is it possible to create additional statistics on read-only ....
4442
0
2
0
Is it possible to create additional indexes on read-only se....
4361
0
2
0
If a DBA expands a data file manually on the primary, will S....
4495
0
2
0
Can I redirect the read-only connections to the secondary re....
4478
0
2
0
Is it possible to run DBCC CHECKDB on secondary replicas?
4622
0
2
0
What are different synchronization preferences are available....
4454
0
2
0
How to change the Session Timeout period?
4513
0
2
0
What is session timeout period?
4517
0
2
0
Can a database belong to more than one availability group?
4498
0
2
0
Does AG support Bulk-Logged recovery model?
4529
0
2
0
Is SQL Server 2012 AlwaysOn support encryption and compressi....
4536
0
2
0
How to remove a secondary database from an availability grou....
4487
0
2
0
How to add a secondary database from an availability group?
4503
0
2
0
Is AG support automatic page repair for protection against a....
4504
0
2
0
Can we have two primary availability replica?
4479
0
2
0
Suppose primary database became in suspect mode. Will AG hav....
4470
0
2
0
Can system database participate in AG?
4452
0
2
0
Database Snapshot supported by Always ON or not?
4381
0
2
0
Change Data Capture supported by Always ON or not?
4449
0
2
0
FILESTEAM is supported by Availability Group or not?
4517
0
2
0
Is it possible to setup Replication on a database which is p....
4481
0
2
0
Is it possible to setup Replication on a database which is p....
4504
0
2
0
Is it possible to setup Log Shipping on a database which is ....
4599
0
2
0
How many read-write and read only databases replica can be c....
4595
0
2
0
What are the minimum requirements of a database to be part o....
4513
0
2
0
What are the Restrictions on Availability Groups?
4509
0
2
0
What is availability group wizard?
4482
0
2
0
What is Use the AlwaysOn Dashboard?
4426
0
2
0
What are the Failover types supported by under asynchronous-....
4472
0
2
0
Can we configure Automatic failover of Availability Groups w....
4460
0
2
0
What is Automatic failover?
4498
0
2
0
What is planned manual failover?
4405
0
2
0
What are the Failover types supported by Synchronous-commit ....
4482
0
2
0
How many types of Failover are supported by Always ON?
4463
0
2
0
What is “Failover” in Always ON?
4431
0
2
0
Can we take Transaction log backups on the secondary replic....
4476
0
2
0
What all types of DB backups are possible on Secondary Repli....
4438
0
2
0
Can we use secondary replicas to take the db backups?
4462
0
2
0
Can we use a secondary for reporting purpose?
4461
0
2
0
How many synchronous secondary replicas can I have?
4428
0
2
0
What are the benefits of Readable Secondary Replicas?
4476
0
2
0
What are Readable Secondary Replicas?
4547
0
2
0
What is Availability Group listener?
4549
0
2
0
What is called Secondary replica?
4439
0
2
0
What is called Primary replica?
4533
0
2
0
What is the Difference between Asynchronous-commit mode and ....
5426
0
2
0
How many Availability modes are supported by Always ON?
4470
0
2
0
Do we need shared storage to configure Always ON?
4481
0
2
0
Do we need SQL Server Cluster instances to configure Always ....
4524
0
2
0
What is Availability mode in Always ON?
4527
0
2
0
How many databases can be configured in an AlwaysOn Availab....
4524
0
2
0
How many AlwaysOn Availability Groups can be configured in A....
4528
0
2
0
How many replicas can I have in an AlwaysOn Availability Gro....
4459
0
2
0
What editions on Windows server support Always ON Functional....
4364
0
2
0
Which SQL Server Editions include AlwaysOn Availability Grou....
4517
0
2
0
What are Availability Databases?
4412
0
2
0
What are Availability Groups?
4439
0
2
0
What is Always on in SQL Server 2012?
4496
0
2
0
How can we check the current node/host name where SQL Server....
4520
0
2
0
What is SMB share
4438
0
2
0
Can we configure Windows cluster between two servers which a....
4323
0
2
0
Can we configure Tempdb database on a local drive?
4509
0
2
0
Can we place out Non Critical SQL Server User Databases on a....
4545
0
2
0
Can we use other SQL Server cluster Nodes for reporting purp....
4523
0
2
0
Will there be any downtime in Active\Active cluster in case ....
4506
0
2
0
Is SQL Server a Load balancing solution or not?
4478
0
2
0
Where the results of validation tests are stored?
4495
0
2
0
What are the basics tests done by the validation tests in W....
4562
0
2
0
What are Validation tests in Windows Cluster?
4562
0
2
0
What are SQL Server Cluster unaware services?
4497
0
2
0
What are SQL Server Cluster aware services?
4475
0
2
0
What is “IS Alive”?
4534
0
2
0
What is “Look Alive”?
4522
0
2
0
What is Distributed lock management?
4511
0
2
0
Why do we keep SQL Services in manual mode on each of the in....
4565
0
2
0
What kinds of permissions are required in the active directo....
4516
0
2
0
What are Services and Application folder represent?
4478
0
2
0
What does a failover cluster do in Windows Server 2008?
4499
0
2
0
What is the maximum number of nodes in an MNS cluster in Win....
4425
0
2
0
How will you add a disk to the SQL Group cluster?
4516
0
2
0
How do you bring the SQL Server down?
4502
0
2
0
What are Virtual Servers?
4494
0
2
0
What happens to a running Cluster if the quorum disk fails ....
4546
0
2
0
What happens to a running Cluster if the quorum disk fails i....
4469
0
2
0
What new functionality does failover clustering provide in ....
4481
0
2
0
What are the Drawbacks of SQL Server Cluster?
4531
0
2
0
What are the Benefits of SQL Server Cluster?
4540
0
2
0
Is it mandatory to configure MSDTC in Windows 2008 cluster b....
4473
0
2
0
Can we change the Quorum settings after installing the windo....
4509
0
2
0
Difference between SQLSERVER 2005 and SQLSERVER 2008 Cluster....
4533
0
2
0
What is the difference between Active\Passive and Active\Act....
4763
0
2
0
Different types of SQL Server Cluster?
4615
0
2
0
What is SQL Server Network Name (Virtual Name)?
4534
0
2
0
How do you open a Cluster Administrator?
4508
0
2
0
How many IP Addresses we require for setting up Active\Acti....
4445
0
2
0
How many IP Addresses we require for setting up Active\Passi....
4531
0
2
0
What are the Hardware requirements for SQL Server Cluster?
4487
0
2
0
What are the Hardware requirements for Windows Server Cluste....
4521
0
2
0
How Spilt Brain situation is resolved?
4430
0
2
0
What I Split Brain situation in Cluster?
4436
0
2
0
What is No Majority: Disk only mode?
4449
0
2
0
What is Node and File Share Majority model?
4726
0
2
0
What is Node and Disk Majority model?
4542
0
2
0
What is Node Majority model?
4433
0
2
0
Different types of Quorum Models supported in windows Serve....
4503
0
2
0
What is Quorum Drive?
4445
0
2
0
What Failover and Failback terms mean in Windows Cluster?
4524
0
2
0
What is Heartbeat in Windows cluster?
4465
0
2
0
What is Private Network?
4459
0
2
0
What is Private Network?
4429
0
2
0
What is Public Network?
4453
0
2
0
What is a Cluster Group?
4399
0
2
0
What are the different states of a Resource in Windows clust....
4459
0
2
0
What is called a Resource in Windows cluster?
4457
0
2
0
What is a Cluster Node?
4473
0
2
0
What is Cluster Service?
4462
0
2
0
What is Windows Cluster?
4404
0
2
0
What are the page types which are not repairable using Autom....
4454
0
2
0
What is Automatic Page Repairing?
4406
0
2
0
What is Log buffer?
4451
0
2
0
What is Transparent Client Redirection?
4460
0
2
0
How to disable mirroring by scripts?
4429
0
2
0
If we add any users to the Primary database, will it be copi....
4501
0
2
0
What will be the impact if we add data files to the Primary ....
4508
0
2
0
What will be the impact if we add data files to the Primary ....
4466
0
2
0
How to monitoring Mirroring?
4492
0
2
0
What status of mirroring has if mirroring is paused?
4477
0
2
0
How can I increase Heartbeat time between principal and mir....
4507
0
2
0
What status of mirroring has if principle is down?
4460
0
2
0
What status of mirroring has if secondary is down?
4459
0
2
0
How to know the database mirroring connection time out in Mi....
4482
0
2
0
Can I configure a single database to be mirrored to more tha....
4493
0
2
0
Can I create multiple endpoints for configuring different da....
4461
0
2
0
Is it possible to take backup of mirrored database in mirror....
4320
0
2
0
Can we configure mirroring between Standard Edition & Enterp....
4450
0
2
0
What are the benefits of Database Snapshots?
4464
0
2
0
What are the restrictions in Database Snapshots?
4435
0
2
0
Can we detach a database snapshot?
4482
0
2
0
Can we take a backup of a database snapshot?
4340
0
2
0
Can we change the permissions in a database snapshot?
4494
0
2
0
How can we check the SPARSE files?
4395
0
2
0
What are important things to remember about sparse files?
4387
0
2
0
What is SPARSE file?
4465
0
2
0
How does a snapshot work?
4463
0
2
0
How to create a Database Snapshot?
4456
0
2
0
What is Database Snapshot?
4470
0
2
0
Can we configure a single database to be mirrored to more th....
4460
0
2
0
Why we get the below error message while configuring databas....
4442
0
2
0
What does DISCONNECTED state means in Database Mirroring?
4475
0
2
0
What does PENDING_FAILOVER state means in Database Mirroring....
4436
0
2
0
What does SUSPENDED state means in Database Mirroring?
4717
0
2
0
What does SYNCHRONIZED state means in Database Mirroring?
4506
0
2
0
What does SYNCHRONIZING state means in Database Mirroring?
4523
0
2
0
What are the Database Mirroring states?
4450
0
2
0
How to Remove a Witness Server from Database Mirroring?
4445
0
2
0
How to Set a Witness Server to Database Mirroring?
4441
0
2
0
What is Role-switching?
4454
0
2
0
Is it possible to perform read only operation at mirrored da....
4473
0
2
0
What is Log Hardening?
4513
0
2
0
What is the default of end points (port numbers) of principa....
4456
0
2
0
What are End Points and its usages?
4386
0
2
0
What are Recovery models support Database Mirroring?
4420
0
2
0
What is High Performance operating mode?
4434
0
2
0
What is High Protection operating mode?
4459
0
2
0
What is High Availability operating mode?
4445
0
2
0
What are the operating modes of Database Mirroring?
4445
0
2
0
What is Synchronous and Asynchronous mode of Database Mirror....
4427
0
2
0
What is a Witness Server?
4486
0
2
0
What is a Mirror?
4440
0
2
0
What is a Principal server?
4495
0
2
0
What are the Restrictions for Database Mirroring?
4504
0
2
0
What are the minimum requirements for Database Mirroring?
4471
0
2
0
What are the Disadvantages of Database Mirroring?
5041
1
2
0
What are the benefits of that Database Mirroring?
4409
0
2
0
How does Database Mirroring works?
4410
0
2
0
What is Database Mirroring?
4447
0
2
0
Can we take full backup of the log shipped database in secon....
4450
0
2
0
What editions of SQL Server is log shipping available in?
4431
0
2
0
Can we take full backup of the log shipped database in prima....
4458
0
2
0
Can we shrink log shipped database log file?
4440
0
2
0
Can we setup multiple secondary databases in Log Shipping?
4479
0
2
0
Yes, we can configure Log Shipping on the server residing in....
4472
0
2
0
Can we configure Log Shipping between the different domains?....
4368
0
2
0
Is it possible to configure Log shipping on the database ser....
4422
0
2
0
Can we configure Log Shipping between the different domains?....
4505
0
2
0
If you add a file on the Primary database in a location whic....
4461
0
2
0
If you add a file on the Primary database in the same locati....
4508
0
2
0
If you create a user on the Primary database, will it automa....
4463
0
2
0
If you create a Job on the Primary database server, will it ....
4496
0
2
0
What will happen to Log Shipping if TUF file is corrupted or....
4598
0
2
0
What is TUF file?
4472
0
2
0
What’s the difference between the secondary being in “Re....
4469
0
2
0
What is STANDBY Mode on the secondary database?
4447
0
2
0
Is it possible load balance in Log Shipping?
4434
0
2
0
What are Log Shipping System Store Procedures?
4456
0
2
0
What are Log Shipping System Tables and in which database th....
4416
0
2
0
What is Monitor server?
4417
0
2
0
What is the copy Job in Log shipping and on which instance i....
4442
0
2
0
What permissions are required for shared folders on Primary ....
4420
0
2
0
What all jobs are created after configuring the Log Shipping....
4742
0
2
0
What is Log Shipping Monitor Settings?
4492
0
2
0
Is it possible to configure Log Shipping from lower version ....
4457
0
2
0
In which recovery model Log Shipping can be configured?
4438
0
2
0
What the drawbacks of Log Shipping?
4739
0
2
0
What are the Benefits of Log Shipping?
4501
0
2
0
What is Log Shipping?
4446
0
2
0
What all High Availability options are available in SQL Serv....
4422
0
2
0
What is High Availability in SQL Server?
4513
0
2
0
Is it possible to perform a point in time recovery with Bulk....
4469
0
2
0
How can you mount a database from MDF file even if you don....
4477
0
2
0
How to script out the user permissions of the database befor....
4435
0
2
0
What are the benefits of Read only file groups?
4513
0
2
0
How to make the File Group read only?
4450
0
2
0
Is it possible to mark Primary File Group as Read only?
4418
0
2
0
What are Mirrored Backup Media Sets?
4438
0
2
0
Is it possible to attach the Data and log files of upper ver....
4442
0
2
0
Is there any alternate method of restoring the database from....
4496
0
2
0
Is it possible to attach the Data and log files of upper ver....
4476
0
2
0
Is there any alternate method of restoring the database from....
4434
0
2
0
Why Database restores from upper version to lower version is....
4440
0
2
0
What are the options to do a point in time recovery P13?
4346
0
2
0
What are the options to restore the database till Point 10 i....
4467
0
2
0
What are the options to restore the database till Point 8 i.....
4459
0
2
0
What are Partial Backups in SQL Server?
4466
0
2
0
What is piecemeal Restore?
4437
0
2
0
What is Point in Time recovery?
4430
0
2
0
Is it possible to restore a Database backup of SQL Server 2....
4444
0
2
0
What are the permissions required to perform Database Restor....
4487
0
2
0
What are Marked Transactions?
4467
0
2
0
What all steps are involved in the Database restore process?....
4452
0
2
0
Why there is a requirement to restore the database?
4472
0
2
0
What is WITH STANDBY Mode?
4479
0
2
0
What is the Difference between WITH RECOVERY and WITH NORECO....
4550
0
2
0
What are the phases of Database restore process?
4477
0
2
0
How can we be notified if a native SQL Server database backu....
4460
0
2
0
What is Notify Operator task in Database Maintenance Plan?
4486
0
2
0
Which system stored procedures are used by History Cleanup T....
4433
0
2
0
What is History CleanUp Task in Database Maintenance Plan?
4468
0
2
0
Can we run a SQL Server Agent job using Database Maintenanc....
4525
0
2
0
Can we execute TSQL Statement using Database Maintenance Tas....
4427
0
2
0
Is it possible to change the Database Maintenance plan once....
4515
0
2
0
In which table all the Maintenance Plans meta data is store....
4444
0
2
0
In which Database all the Maintenance Plans are stored?
4534
0
2
0
What all options we have in a Database maintenance plans whi....
4489
0
2
0
What are the Benefits of Database Maintenance Plans?
4507
0
2
0
What are Database Maintenance Plans?
4481
0
2
0
From a best practices perspective, what is your backup reten....
4417
0
2
0
What is the Backup strategy in your environment?
4468
0
2
0
Suppose I have a Database maintenance plan which runs every ....
4450
0
2
0
What are the Benefits with Windows Azure Blob storage servic....
4743
0
2
0
What is a SQL Server Credential?
4492
0
2
0
What is Windows Azure Blob storage service Database backups?
4500
0
2
0
How does the database recovery model impact database backups....
4517
0
2
0
What are the options to deal with Over Growing transaction l....
4466
0
2
0
Is it mandatory to take a Full backup if we switch the recov....
4485
0
2
0
Is it possible in any situation when differential backup gro....
4444
0
2
0
Whether Full or Differential backups clear the Transaction L....
4527
0
2
0
What is a log chain?
4452
0
2
0
What is BUFFERCOUNT option in Backup database command?
4457
0
2
0
What is MAXTRANSFERSIZE option in Backup database command?
4444
0
2
0
What are the Disadvantages of using TDE?
4435
0
2
0
What are the Advantages of using TDE?
4465
0
2
0
What is a MASTER KEY?
4525
0
2
0
Is there a performance impact for using TDE?
4544
0
2
0
Which versions of SQL Server support TDE?
4505
0
2
0
What is TDE (Transparent Data Encryption) method in SQL Serv....
4538
0
2
0
What is RPO?
4477
0
2
0
What is RTO?
4411
0
2
0
What are the common issues you faced in Database backup?
4439
0
2
0
How many copies are allowed when taking a backup using MIRRO....
4456
0
2
0
Name any 2-3 Third party SQL Server database backup tools?
4449
0
2
0
Can we have multiple copies of the database backup is a sing....
4483
0
2
0
What are the Best Practices recommendations related to SQL S....
4430
0
2
0
What is Back up WITH CHECKSUM?
4480
0
2
0
What all operations are prohibited when the database backups....
4390
0
2
0
What are the restrictions on the Database backups operations....
4456
0
2
0
What are the limitations with Windows Azure Blob storage ser....
4530
0
2
0
What are the Backup and Restore Enhancements?
4510
0
2
0
Is there any option to prevent All successful SQL Server ba....
4535
0
2
0
What are the permissions required to perform backup?
4497
0
2
0
What is the meaning of the values in Type column in backups....
4484
0
2
0
How can I verify that backups are occurring on a daily basis....
5646
0
2
0
In a situation with full, differential and transaction log ....
4696
0
2
0
For differential backups, how is the data determined for tho....
4467
0
2
0
What are the backup and restore system tables? What do each ....
4484
0
2
0
What is the database that has the backup and restores system....
4467
0
2
0
How do you know if your database backups are restorable?
4578
0
2
0
What all operations are minimally logged when the database i....
4572
0
2
0
In which recovery model, Transaction Log backups are possibl....
4507
0
2
0
Is it possible to add password to a backup file in SQL Serv....
4518
0
2
0
Types of Database backups?
4483
0
2
0
What are database backups?
4472
0
2
0
How can you setup a default recovery model for all newly cr....
4522
0
2
0
How many types of Recovery models we have in SQL Server?
4519
0
2
0
What is recovery model in SQL Server?
4533
0
2
0
What are the recommended Data files settings for tempdb?
4456
0
2
0
What is the default owner of master, model, tempdb and msdb ....
4560
0
2
0
Is it possible to rename any of system databases?
4488
0
2
0
Is it possible to take the tempdb database backup?
4458
0
2
0
Is it important to take the system database backups?
4515
0
2
0
What are the system databases created when we configure Repo....
4478
0
2
0
What is the database that has the backup and restores system....
4562
0
2
0
What are the typical objects that are created in the TempDB ....
4525
0
2
0
What is the location of resource database?
4527
0
2
0
What is resource database?
4521
0
2
0
What is tempdb database?
4518
0
2
0
What is msdb database?
4525
0
2
0
What is model database?
4608
0
2
0
What is master database?
4574
0
2
0
What are system databases?
4563
0
2
0
What is the use of setup.exe under the below folder
4498
0
2
0
What is Master Data Services Configuration?
4558
0
2
0
What is Policy Management Tool?
4226
0
2
0
What is Project Conversion Wizard?
4258
0
2
0
What is Data Profile Viewer?
4319
0
2
0
What is DTutil.exe?
4373
0
2
0
What is DTExec.exe?
4346
0
2
0
What is snapshot.exe?
4411
0
2
0
What is logread.exe?
4364
0
2
0
What is Distrib.exe?
4601
0
2
0
What is tablediff.exe? What are the usages?
4368
0
2
0
What is SQL Nexus Tool?
4306
0
2
0
What are Database Maintenance Plans
4269
0
2
0
What is PSSDIAg Manager Utility?
4416
0
2
0
What is SQLDiag?
4310
0
2
0
What are Extended events in SQL Server 2012?
4279
0
2
0
What is Data Quality Client?
4265
0
2
0
What is SQLPS module and what are its usages?
4401
0
2
0
What is bcp?
4305
0
2
0
What is OSQL?
4332
0
2
0
What is SQLCMD?
4397
0
2
0
What is Activity Monitor in SQL Server 2012?
4275
0
2
0
What is SQL Server upgrade advisor?
4337
0
2
0
What is Always on DashBoard?
4258
0
2
0
What is Replication Monitor?
4337
0
2
0
What is Resource Governor?
4219
0
2
0
What is Reporting Services Configuration manager?
4319
0
2
0
What is SQL Server Configuration Manager and its usages?
4275
0
2
0
What is Database Engine Tuning Advisor?
4362
0
2
0
What is SQL Server profiler?
4468
0
2
0
What is SSMS?
4318
0
2
0
What is Fail Safe Operator? How can we enable this?
4538
0
2
0
What could be the reason if your Database Mail working fine ....
4286
0
2
0
How can we change the Job History Retention?
4219
0
2
0
Sometimes there is no History available for the Failure or S....
4276
0
2
0
What are maintenance jobs for a SQL Server database?
4268
0
2
0
What is Notification property in SQL Server job properties?
6042
0
2
0
Can we run Operating system command in the SQL Server jobs?
4311
0
2
0
Is it possible to run an SSIS package from a job step? How? ....
4276
0
2
0
Is it possible to get and change all the schedules informati....
4242
0
2
0
Can we have multiple schedules for a single job?
4268
0
2
0
What is a SQL Server Agent Proxy Account?
4390
0
2
0
What is the difference between Public profile and Private Pr....
4353
0
2
0
What is a Database Mail Profile?
4261
0
2
0
What is a Database Mail Account?
4299
0
2
0
How to enable Database mail?
4252
0
2
0
Is SQL Mail option is available in SQL Server 2012 or not? I....
4299
0
2
0
How can we grant permissions on the SQL Server agent jobs an....
4357
0
2
0
Which tables will give you the Job history related informati....
4276
0
2
0
Which table contains information about the SQL Server jobs ....
4350
1
2
0
Which tables can be Queries to get details about the Jobs an....
4284
0
2
0
Which database contains information about the jobs and other....
4312
1
2
0
What is an Alert?
4254
0
2
0
What is a Schedule?
4262
0
2
0
What is an Operator?
4297
0
2
0
What is a SQL Server job?
4500
0
2
0
What are various components of SQL Server Agent service?
4305
0
2
0
What is SQL server Agent? What are its benefits?
4272
0
2
0
What are the various components involved in Distributed Repl....
4263
0
2
0
What is Distributed Replay?
4245
0
2
0
What is the high Level SQL Server start up process?
4955
0
2
0
What will happen if SQL Server Browser service is stopped?
4358
0
2
0
Which Port no. is used by SQL Server Browser service?
4271
0
2
0
What is Protocol is used by SQL Server Browser service?
4337
0
2
0
Which system database is associated with SQL Server agent se....
4258
0
2
0
What are the mandatory databases to bring SQL Services up?
4263
0
2
0
Name some of the Important Trace flags and their functionali....
4410
0
2
0
How do I know what Trace Flags are turned on at the moment?
4252
0
2
0
How the trace flags are enabled?
4264
0
2
0
What are trace flags and how can we apply trace flags on a ....
4364
0
2
0
How to start SQL Server with single user model?
4313
0
2
0
How to start SQL Server with single user model?
4279
0
2
0
How to start the SQL Server with minimal configuration?
4339
0
2
0
What are the default parameters of SQL Server service start ....
4287
0
2
0
What are the different ways to start and Stop SQL Server ser....
4406
0
2
0
How to check how many SQL Server instances are installed on ....
4342
0
2
0
What is Distributed Transaction Coordinator?
4368
0
2
0
What is SQL Server Active Directory Helper?
4733
0
2
0
What is Full-Text Search service?
4261
0
2
0
Which types of backups are supported by SQL Write Service?
4276
0
2
0
Which types of backups are supported by SQL Write Service?
4290
0
2
0
What is SQL Server VSS Writer?
4556
0
2
0
What is SQL Server Reporting Services?
4392
0
2
0
What is SQL Server Browser?
4407
0
2
0
What is SQL Server Integration service and its importance?
4296
0
2
0
What is SQL Server Analysis service and its importance?
4308
0
2
0
What is SQL Server Agent service and its importance?
4293
0
2
0
What is SQL Server service and its importance?
4344
0
2
0
List out various services which are important for SQL Server....
4324
0
2
0
How Does Log Truncation occurs?
4841
0
2
0
What is a Log Truncation?
4423
0
2
0
What is Log Sequence No?
4249
0
2
0
What is the way to check Virtual Log file details?
4247
0
2
0
How VLFs are created SQL Server in a Transaction log file?
4353
0
2
0
What are Virtual Log files? How these are created?
4294
0
2
0
What is a Transaction log file?
4237
0
2
0
What is a Physical read?
4269
0
2
0
What is a Logical Read?
4235
0
2
0
What is a Fill Factor?
4291
0
2
0
How can we monitor or detect Page Splits?
4301
0
2
0
How Page Splits impacts the database performance?
4285
0
2
0
What is a PAGE SPLIT?
4266
0
2
0
What are LOB pages
4250
0
2
0
What is an IAM page?
4278
0
2
0
How many types of Allocation units are there?
4283
0
2
0
What is Boot Page?
4310
0
2
0
What is a BCM and its significance?
4332
0
2
0
How SQL Server engine will decide which extents need to be ....
4290
0
2
0
What is a DCM and its significance?
4293
0
2
0
How many GAM pages will be there in a 7GB data file?
5178
0
2
0
What is a GAM Page?
4262
0
2
0
What is PFS?
4293
0
2
0
What is a Page Header?
4236
0
2
0
What is an Index Page?
4240
0
2
0
What is a Data Page?
4311
0
2
0
What is Instant file initialization?
5289
0
2
0
What is trustworthy property of a database?
4372
0
2
0
How can we check the allocation unit of objects?
4300
0
2
0
What is ROW_OVERFLOW_DATA? How does it work?
4350
0
2
0
What is a logical File and physical File name?
4483
0
2
0
What is the difference between single user and restricted us....
4550
0
2
0
What is an extent
4235
0
2
0
What is auto shrink option?
4301
0
2
0
What is auto close option?
4357
0
2
0
How many databases can be created in SQL server instance?
4299
0
2
0
What are the recommended settings for transaction Log File f....
4290
0
2
0
How many maximum files can be added to a database?
4429
0
2
0
How many Maximum File groups can be added in a database?
4276
0
2
0
What is Database Growth and what settings are available in ....
4287
0
2
0
Will the below script work if yes, how?
4271
0
2
0
Is there any benefit to add multiple log files? Yes/No, Why....
4339
0
2
0
What is the use of having multiple File Groups?
4288
0
2
0
Is it possible to add Transaction Log file in a file group?
4255
0
2
0
Is it possible to change the Default file group from Primar....
4395
0
2
0
What is the default File Group in a database?
4378
0
2
0
What are file groups and Type of File Groups?
4461
0
2
0
What is the major difference between Primary data files and ....
4553
0
2
0
Explain each type of database files?
4479
0
2
0
How many types of files are there in a SQL Server database?
4447
0
2
0
What is a Batch, Task, Windows Thread, Fiber, Worker Thread....
4540
0
2
0
What is MaxDOP term in SQL server?
4537
0
2
0
What is HOT ADD CPU term in SQL server?
4476
0
2
0
What is the different protocol supported by SQL server, expl....
4494
0
2
0
How Ghost cleanup task works?
4741
0
2
0
Which process removes the records which are marked as Ghost....
4443
0
2
0
What are ghost records in SQL server?
4499
0
2
0
What is log flush?
4445
0
2
0
What is LazyWriter?
4415
0
2
0
What is a check point?
4456
0
2
0
How is the dirty page written to disk?
4418
0
2
0
What are dirty pages?
4454
0
2
0
What is Write Ahead Logging?
4432
0
2
0
What is a Transaction manager and its role?
4504
0
2
0
What is a Buffer pool? What is the importance of Data cache?
4445
0
2
0
What is a Buffer Manager?
4442
0
2
0
What are Access methods and its roles?
4488
0
2
0
What is Query Executor?
4446
0
2
0
What is the role of an Optimizer?
4446
0
2
0
What is a Plan Cache?
4500
0
2
0
What is an Execution Plan?
4533
0
2
0
What is a Command Parser?
4509
0
2
0
What are Tabular Data Stream (TDS) Endpoints?
4552
0
2
0
What is SNI Protocol Layer?
4957
0
2
0
What is Relational Engine and its Role?
4491
0
2
0
Tell me something about the SQL Server Architecture?
4494
0
2
0
Define SQL Server Surface Area Configuration Tool?
4460
0
2
0
What are the types of keys used in encryption?
4467
0
2
0
What is Service master key?
4387
0
2
0
What is Transparent Data Encryption?
4443
0
2
0
Being a DBA what all measures you will follow to make SQL SE....
4505
0
2
0
How can SQL Server instances be hidden?
4521
0
2
0
What are Orphaned Users?
4492
0
2
0
What are Application Roles?
4517
0
2
0
What is the purpose of db_denydatawriter and db_denydataread....
4556
0
2
0
What are Fixed Database Roles?
4534
0
2
0
Which one is highest privileged role out of SQL Agent User R....
4616
0
2
0
What are the extra DB roles available in msdb?
4559
0
2
0
What are the security related catalog views?
4338
0
2
0
Is it possible to create new User Defined Server role in 20....
4449
0
2
0
What is a guest account?
4568
0
2
0
What are “View Definition” permissions?
4658
0
2
0
What are “View Server State”, “VIEW DATABASE STATE” ....
4647
0
2
0
What are Fixed Server roles and importance?
4486
0
2
0
What is a schema?
4488
0
2
0
What are logins and users and its difference?
4480
0
2
0
Explain scope of securable on Server, Database and Schema le....
4513
0
2
0
What is a Securable?
4372
0
2
0
What are Principals?
4486
0
2
0
Being a DBA which authentication mode you will prefer if you....
4515
0
2
0
What’s the difference between Windows and Mixed mode?
4453
0
2
0
How many type of SQL Server authentication mode supported by....
4474
0
2
0
What is Authentication and Authorization? What is the differ....
4493
0
2
0
Is it possible to increase the retention of Error log files....
4495
0
2
0
How many SQL Server log files can be retained in the SQL Ser....
4694
0
2
0
What’s the location of SQL Server log files?
4446
0
2
0
What is a Filestream?
4455
0
2
0
How to get the port number where the SQL Server instance is ....
4550
0
2
0
What is the default port of a SQL Server instance?
4599
0
2
0
What is a silent installation and how can we use this featur....
4359
0
2
0
What is a slip stream installation and its usages?
4463
0
2
0
What is a silent installation and how can we use this featur....
4478
0
2
0
What is a slip stream installation and its usages?
4452
0
2
0
What’s the practical approach of installing Service Pack?
4468
0
2
0
Is it mandatory to restart the Windows server after installi....
4575
0
2
0
What is the latest Service pack available for SQL Server 201....
4422
0
2
0
What is a Service Pack, Patch, Hot fix and its difference?
4534
0
2
0
What is an RTM setup of SQL Server?
4636
0
2
0
What is a collation and what is the default collation?
4563
0
2
0
Can we install multiple instances on the same disk drive?
4522
0
2
0
Type of Instance and maximum no. of instances which can be i....
4491
0
2
0
What is an Instance?
4491
87
3
0
What are Shared Features Directory and its usages?
4460
0
2
0
Do we need to grant Administrator permissions on the Window....
4497
0
2
0
What permissions are required to install SQL Server on a ser....
4527
0
2
0
. What is a service account?
4434
0
2
0
. What is the location of ConfigurationFile.ini file?
4474
0
2
0
What is “ConfigurationFile.ini” file?
4490
0
2
0
Home
Snippet
Search
Interview
LogIn
