Sql

Can you technically explain how memory allocated and lock pages works?

Started by Maximus

Replies: 0
Views: 1,884

November 01, 2014, 03:19:05 PM
by Maximus

What happens if we lose Mirror / Witness or both?

Started by Jordan

Replies: 0
Views: 1,884

October 27, 2014, 12:49:01 PM
by Jordan

My publisher is in SQL Server 2015 and we need to subscribe to SQL Server 201instance. Is it possible?

Started by Adrian

Replies: 0
Views: 1,924

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

What is a unique key?

Started by Ryley

Replies: 0
Views: 2,108

August 11, 2014, 12:40:12 AM
by Ryley

What are the various multiple row comparison operators in SQL?

Started by Myles

Replies: 0
Views: 2,106

October 21, 2016, 02:53:34 AM
by Myles

If a table contains duplicate rows, does a query result display the duplicate values by default?How can you eliminate duplicate rows from a query result?

Started by Travis

Replies: 0
Views: 2,100

October 31, 2014, 12:08:01 AM
by Travis

In your production environment mirroring is configured for one of the premium database and you are asked to cross check the configuration. Can you elaborate what are all the options you would check for?

Started by Lukas

Replies: 0
Views: 2,104

October 22, 2014, 10:42:26 PM
by Lukas

What is TEMPDB PAGELATCH Contention and how to resolve it?

Started by Hassan

Replies: 0
Views: 2,132

December 11, 2016, 12:03:34 AM
by Hassan

What are the most common symbols/operators used for SQL Injection?

Started by Aston

Replies: 0
Views: 2,108

October 24, 2014, 11:39:02 AM
by Aston

What is DBMS?

Started by Shay

Replies: 0
Views: 2,083

December 29, 2015, 06:45:14 PM
by Shay

How SQL Server Relational Engine works in processing SQL queries?

Started by Emmanuel

Replies: 0
Views: 2,075

October 24, 2014, 11:05:42 AM
by Emmanuel

I have node Active/Passive failover cluster on SQL Server 201built on Windows Server 201R Now on active node SQL instance one of the databases is not coming online due to a page corruption. Can you get it online by initiating a manual failover to other no

Started by Preston

Replies: 0
Views: 2,081

August 01, 2016, 03:24:42 PM
by Preston

In database mirroring what are the events happens when an automatic failover occurred?

Started by Vincent

Replies: 0
Views: 2,104

August 17, 2016, 02:43:22 PM
by Vincent

We are using In-Memory feature for one of our production database. The database contains memory-optimized tables. Can we run DBCC CHECKDB on this database?Does it support?

Started by Christian

Replies: 0
Views: 2,111

September 05, 2015, 08:06:54 PM
by Christian

What is an Index?

Started by Ashley

Replies: 0
Views: 2,117

October 24, 2014, 11:22:21 AM
by Ashley

You are leading a DBA team and one of your team members came to you and reported that he has executed an UPDATE command without WHERE CLAUSE on production database. Now that entire table has got updated with the wrong data. How do you handle the situation

Started by Josh

Replies: 0
Views: 2,074

November 03, 2015, 01:29:01 AM
by Josh

What are the different tools available while upgrading SQL Server?

Started by Jaden

Replies: 0
Views: 2,075

October 24, 2014, 11:39:01 AM
by Jaden

What are the ALWAYSON improvements added in SQL Server 2015 and 2016?

Started by Abdul

Replies: 0
Views: 2,103

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

Why don't we just backup SQL Server Database Files (MDF, LDF and NDF) using Windows backup tool instead of SQL Server native backup?

Started by Leighton

Replies: 0
Views: 2,053

September 05, 2015, 01:49:07 AM
by Leighton

I have an indexed view, now base table data has been modified, does the modified data reflected in view automatically?

Started by Beau

Replies: 0
Views: 2,057

June 17, 2016, 08:14:31 AM
by Beau