Sql

What is a join?

Started by Sidney

Replies: 0
Views: 2,034

October 31, 2014, 12:09:06 AM
by Sidney

How to apply service pack on Active/Passive cluster on 2008 and 2012?

Started by Umar

Replies: 0
Views: 2,020

October 24, 2014, 10:03:34 AM
by Umar

We need to perform a DELETE operation on various tables on a VLDB. What are your suggestions to optimize the delete process on huge tables?

Started by Freddy

Replies: 0
Views: 2,009

August 17, 2016, 07:19:42 AM
by Freddy

How many read-write and read only databases replica can be configure in SQL Server 2015 and 2014?

Started by Stephen

Replies: 0
Views: 2,424

October 24, 2014, 10:03:34 AM
by Stephen

What are the performance improvements in SQL Server 2016?

Started by Zakariya

Replies: 0
Views: 2,374

November 26, 2016, 06:23:39 AM
by Zakariya

There is a non-clustered index IX_available on table T. I have created a duplicate index IX_ Now can you tell me which is the index is chosen by query optimizer and why?

Started by Isaiah

Replies: 0
Views: 2,410

August 18, 2016, 12:55:41 AM
by Isaiah

In SQL Server” do we have Statistics on Table and Statistics on Index?Or both are same?

Started by Rayan

Replies: 0
Views: 2,406

March 09, 2016, 09:11:21 AM
by Rayan

We know we cannot use Order by inside a view. Can you tell me why?

Started by Eric

Replies: 0
Views: 2,385

December 30, 2015, 04:35:48 AM
by Eric

What is Denormalization?

Started by Cian

Replies: 0
Views: 2,360

October 30, 2014, 08:36:54 PM
by Cian

We have recently upgraded to SQL Server 2016 and we would like to configure database mirroring for one of our production database. As a lead DBA what is your suggestion on this?

Started by Kane

Replies: 0
Views: 2,365

April 17, 2016, 03:50:12 AM
by Kane

Do we need to create a covering index for all queries?If not on which basis we have to create covering index?

Started by Caiden

Replies: 0
Views: 2,341

November 01, 2014, 02:08:34 AM
by Caiden

What is Self-Join?

Started by Junior

Replies: 0
Views: 2,356

October 24, 2014, 10:04:11 AM
by Junior

What is a View?

Started by Elias

Replies: 0
Views: 2,364

October 30, 2014, 10:32:26 AM
by Elias

Why clustered index shouldn't be created on a column when it's having duplicates?

Started by Martin

Replies: 0
Views: 2,418

October 24, 2014, 10:03:34 AM
by Martin

Is there any performance impact if we enable the backup encryption?

Started by Justin

Replies: 0
Views: 2,364

October 27, 2016, 06:09:01 PM
by Justin

Does TDE (Transparent Data Encryption) supports in all SQL Server High Availability and Disaster Recovery features?

Started by Scott

Replies: 0
Views: 2,368

July 10, 2016, 10:03:32 AM
by Scott

What is the proxy account in SQL Server?

Started by Ismail

Replies: 0
Views: 2,394

October 24, 2014, 10:03:21 AM
by Ismail

One of the disk drive is 95% full within a very less time. Now you started getting disk full alerts and you need to free up the space. What are the different options you try to clear the space?And what are the possible reasons that cause the sudden disk f

Started by Frank

Replies: 0
Views: 2,330

October 29, 2014, 10:16:28 AM
by Frank

What are all the different types of indexes?

Started by Raphael

Replies: 0
Views: 2,329

November 09, 2016, 05:55:45 PM
by Raphael

What are local and global variables and their differences?

Started by Rufus

Replies: 0
Views: 2,322

October 31, 2014, 01:17:55 PM
by Rufus