?
Solved

Are the benefits of using DROP_EXISTSING with both nonclustered and clustered?

Posted on 2011-04-27
3
Medium Priority
?
236 Views
Last Modified: 2012-06-22
Are the benefits of using DROP_EXISTSING with both nonclustered and clustered?
0
Comment
Question by:Mr_Shaw
3 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 1000 total points
ID: 35476800
0
 
LVL 9

Assisted Solution

by:radcaesar
radcaesar earned 1000 total points
ID: 35477684
It saves the resource by minimizing the index page size. In case of tables with large amount of data you can feel the difference (of using drop_existing). Not needed for average sized tables.
0
 

Author Closing Comment

by:Mr_Shaw
ID: 35511788
thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question