Sql

Does all dirty pages written to disk when an automatic checkpoint occurs?

Started by Imran

Replies: 0
Views: 2,939

August 17, 2016, 07:15:50 AM
by Imran

You want to display a result query from joining two tables with 20 and 10 rows respectively?

Started by Hari

Replies: 0
Views: 2,571

February 19, 2017, 02:22:24 PM
by Hari

Starting from SQL Server to 2016, from which edition the licensing model has been changed?

Started by Ishaan

Replies: 0
Views: 2,449

December 11, 2016, 10:16:54 AM
by Ishaan

What is your approach in AUTO_GROWTH option while creating a new database?

Started by Amari

Replies: 0
Views: 1,865

December 10, 2016, 11:55:46 PM
by Amari

What is the pupose of DML statements in SQL?

Started by Kieron

Replies: 0
Views: 1,868

October 29, 2014, 08:28:34 PM
by Kieron

What are the added improvements for database mirroring in SQL Server 2016?

Started by Malakai

Replies: 0
Views: 1,891

June 28, 2016, 09:52:28 PM
by Malakai

Can you modify the rows in a table based on values from another table?Explain?

Started by Aaryan

Replies: 0
Views: 1,839

December 29, 2015, 06:41:52 PM
by Aaryan

What is a constraint?

Started by Brendan

Replies: 0
Views: 1,824

October 29, 2014, 11:18:02 AM
by Brendan

Can you tell me the best feature in SQL Server 201ALWAYSON Failover Cluster when compared to SQL Server 2008 RFailover Cluster?

Started by Jaxson

Replies: 0
Views: 1,851

November 01, 2014, 03:55:47 AM
by Jaxson

We have upgraded databases from SQL Server 2005 to SQL Server 2015 and now the upgrade hits the production. Unfortunately a part of application is not supporting SQL Server 20Do we need to Rollback entire process to SQL 2005?Is that the only solution?If i

Started by Dhruv

Replies: 0
Views: 1,818

October 05, 2016, 10:04:46 PM
by Dhruv

Have you ever encounter the issue media family on device is incorrectly formed”?If yes what is the reason and how you resolved it?

Started by Kaden

Replies: 0
Views: 1,830

October 24, 2014, 10:04:01 AM
by Kaden

When you upgrade a SQL Server, the upgrade wizard seems to stop responding and fails sometimes. Why?

Started by Casey

Replies: 0
Views: 1,786

June 10, 2016, 08:15:41 PM
by Casey

What is a Database?

Started by Paul

Replies: 0
Views: 1,775

October 24, 2014, 11:12:51 AM
by Paul

What are the different releases of SQL Server?We usually talk about RTM, RC, SP, CU etc. right, what are the different releases of a SQL Server product and what do you know about them?

Started by Lenny

Replies: 0
Views: 1,794

April 24, 2016, 04:05:41 AM
by Lenny

How to recover a database that is in suspect stage?

Started by Mitchell

Replies: 0
Views: 1,803

October 24, 2014, 10:04:12 AM
by Mitchell

What are tables and Fields?

Started by Kye

Replies: 0
Views: 1,730

April 23, 2016, 01:22:26 PM
by Kye

What do you understand by a subquery?When is it used?

Started by Patryk

Replies: 0
Views: 1,760

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

Truncate is a non-logged operation right?If I issues TRUNCATE TABLE on primary server does it effects on secondary database?If yes how?

Started by Mateusz

Replies: 0
Views: 1,781

October 24, 2014, 11:28:22 AM
by Mateusz

We recently had to cancel a long-running update. After the operation rolled back, the next daily transaction log backup was huge. My question is the operation got roll backed and nothing had changed in the database. But why we were getting huge log backup

Started by Will

Replies: 0
Views: 1,794

October 29, 2014, 08:22:28 PM
by Will

I have installed SQL Server 201Express edition. Is it possible to configure log shipping?

Started by Arjun

Replies: 0
Views: 1,781

October 11, 2016, 02:01:59 AM
by Arjun