What's the best way to delete or update 100 million records in an MSSQL server?

Asked by Last Modified  

1 Answer

Learn MS SQL

Follow 4
Answer

Please enter your answer

Manoj kumar Vishwakarma

MS SQL SERVER DBA Trainer

For Delete use Truncate command and for update million records use like... Consider a table called test which has more than 5 millions rows. Suppose you want to update a column with the value 0, if it that column contains negative value. Let us also assume that there are over 2 million row in that column...
read more
For Delete use Truncate command and for update million records use like... Consider a table called test which has more than 5 millions rows. Suppose you want to update a column with the value 0, if it that column contains negative value. Let us also assume that there are over 2 million row in that column that has a negative value. The usual way to write the update method is as shown below: UPDATE test SET col=0 WHERE col<0 read less
Comments
Dislike Bookmark

Related Questions

Need help regarding SQL Server and Access Database Connectivity over a network on ODBC. Can pay a good price. Thanks
Ok send me the details what you are using as a frontend lang like java or c# and what probelms you are facing.
Ruchi
2 0
5

Hello All,

Hope you are doing well. I am having experience of more than 6+ years into HR Recruitment wants to change my profile either into some analytical techno functional role or BA or any Operations profile. Kindly suggest some good exciting career opportunity.  
Hello Prafulla, As per your previous experience, you can go for salesforce course. Since you are from the non-IT background, you can do Salesforce Admin.
Prafulla
For openrowset function which privileges is need to give nonsys user in sql server 2008 r2
BULK ADMIN privilege is required
Amit
Dear Sir, Please guide me for MS SQL Administration training Tutor and SQL server 2012 Book. Please get in touch with me.
Hi, for training on MS SQL Admin and SQL server kindly contact us.
Kailash
What is the best way to start learning SQL server 2016?
Hi Ramya, To learn the SQL there is multiple step & way's. Start learn basic queries and RDBMS Database concept. Than Installing, Configuring, and Managing Microsoft SQL Server, Sample Databases...
Ramya
0 0
7

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

SQL Server Row Count for all Tables in a Database
ProblemI am a database consultant and one of my tasks involves getting the row counts from all the tables in the source database and comparing it against the corresponding table row counts in the target...

Amitava Majumder

0 0
0
What Are Olap, Molap, Rolap, Dolap, Holap?
1. OLAP: On-Line Analytical Processing: Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal...

Itech Analytic solutions

0 0
0
R programming language
R is a programming language and software environment for statistical computing and graphics supported by the R Foundation for Statistical Computing. The R language is widely used among statisticians and...

Itech Analytic solutions

0 0
0
MS-SQL Database
1. Select: 01-Select All Given a City table, whose fields are described as: +-------------+----------+ | Field | Type | +-------------+----------+ | ID | int(11) | | Name ...

Prashant Kumar

0 0
0
SQL Statements
SQL SELECT Statement The SELECT statement is used to select data from a database. The SQL SELECT Statement The SELECT statement is used to select data from a database. The result is stored in a result...

Ajeet Singh

0 0
0

Recommended Articles

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Find MS SQL Training near you
MS SQL Training in Bangalore
MS SQL Training in Hyderabad
MS SQL Training in Mumbai
MS SQL Training in Pune
MS SQL Training in Delhi
MS SQL Training in Chennai
MS SQL Training in Gurgaon
MS SQL Training in Noida
MS SQL Training in Faridabad
MS SQL Training in Ghaziabad

Looking for MS SQL Training?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you