No announcements
Found 1641578 threads
-
2 VotesEnhance a SQL query with update of millions of rows
DECLARE @x INT SET @x = 1 WHILE @xAnswered | 4 Replies | 1132 Views | Created by SQL Kitchen - Monday, December 30, 2013 8:40 AM | Last reply by Taherul673 - Monday, December 30, 2013 3:52 PM
-
0 Votes
Update million plus Rows...
After the complex query to pull 1 col save the data to one temp table.Answered | 3 Replies | 3757 Views | Created by Suresh SSIS - Friday, August 21, 2009 6:30 PM | Last reply by Sudeep Raj - Friday, August 21, 2009 6:47 PM -
2 Votes
SQL Tuning for 50 million rows--- Group by
Optimization bible: http://www.sqlusa.com/articles/query-optimization/ Kalman Toth Database & OLAP ...Answered | 7 Replies | 4242 Views | Created by czarvk - Tuesday, August 20, 2013 6:11 PM | Last reply by DIEGOCTN - Wednesday, August 21, 2013 2:11 PM -
0 Votes
Enhancment T-SQL query
The case which you have shown here predicts the best plan SQL can come across for "Update Table001 Set Status=6 where ID=123456".Answered | 3 Replies | 856 Views | Created by SQL Kitchen - Thursday, April 16, 2015 1:05 PM | Last reply by Anuj Tripathi - Friday, April 17, 2015 3:55 PM -
1 Votes
Update Synatx (Enhancment)
I did all enhancements I can No, you forgot one very important aspect.Answered | 7 Replies | 712 Views | Created by SQL Kitchen - Wednesday, January 29, 2014 7:42 AM | Last reply by Gert-Jan Strik - Wednesday, January 29, 2014 11:38 AM -
0 Votes
Updating table with more than 50 million records
also these shud ...Answered | 1 Replies | 956 Views | Created by Eswararao C - Friday, February 7, 2014 3:15 PM | Last reply by Jayakumaur (JK) - Friday, February 7, 2014 3:26 PM -
0 Votes
Few millions rows of data
I would suggest someone look at the queries involved and check the actual completion time.Answered | 2 Replies | 1396 Views | Created by Vikas Awasthi India - Friday, April 25, 2014 6:15 AM | Last reply by Sean Gallardy - Friday, April 25, 2014 4:04 PM -
0 Votes
Average calculation on 200 millions rows
If possible and you are able to share, please report your SQL Server query performance numbers to this thread.Answered | 5 Replies | 1396 Views | Created by DIEGOCTN - Saturday, March 22, 2014 11:32 PM | Last reply by CarnegieJ - Monday, March 24, 2014 5:33 PM -
0 Votes
Accessing 3 million rows of table
So in summary UltraDev, If you point your Excel 2007 workbook to a view instead of a table you will prevent 3 million rows being accessed everytime the user of ...Answered | 11 Replies | 1165 Views | Created by UltraDev - Friday, October 3, 2014 5:48 AM | Last reply by Kieran Patrick Wood - Friday, October 3, 2014 12:37 PM -
3 Votes
Alter a table with 800 million rows
Only when you want to add a new not nullable column, then you have to define a default value for it and then all 800 mio data rows will be updated; that will take ...Answered | 5 Replies | 2005 Views | Created by deppsos - Friday, November 23, 2012 4:48 PM | Last reply by Olaf Helper - Friday, November 23, 2012 5:31 PM -
0 Votes
Best way to transfer millions of rows
Hello, What is the best way to transfer more than 100 million rows from source to destination.Answered | 9 Replies | 1192 Views | Created by srikanth.kasu - Tuesday, April 7, 2015 5:04 PM | Last reply by Harry Bal - Wednesday, April 8, 2015 6:05 PM -
1 Votes
How to Quickly Delete Millions of Rows
Because in this issue performance and speed of removing 80 million Row is important.Answered | 4 Replies | 44564 Views | Created by Matthanielcm - Wednesday, September 19, 2012 10:56 PM | Last reply by Phadix - Thursday, September 20, 2012 6:58 AM -
0 Votes
Updating a Table with 25 Million rcords SQL Server 2000
I have modified the query a little bit and looks like this now : UPDATE SD SET SD.WEEK_NO=C.WEEK_NO_NEW FROM sourcing.SCHEDULE_DET_HIST_TEMP SD ...Answered | 2 Replies | 3996 Views | Created by tharindu Jayawardene - Monday, April 12, 2010 12:10 AM | Last reply by tharindu Jayawardene - Monday, April 12, 2010 1:17 AM -
0 Votes
What's the most effecient way to update part of a string column for millions of rows
--This will affect update speed 2.Answered | 8 Replies | 2359 Views | Created by Dannol Liu - MSFT - Thursday, June 14, 2012 6:44 AM | Last reply by Dannol Liu - MSFT - Friday, June 15, 2012 1:40 AM -
0 Votes
Data Load for 330 Million rows
tip=1185 Madhu MCITP, MCTS, MCDBA,MCP-- Blog : http://experiencing-sql-server-2008.blogspot.com/Answered | 1 Replies | 5752 Views | Created by ISAL_F - Tuesday, May 19, 2009 5:08 PM | Last reply by Madhu K Nair - Tuesday, May 19, 2009 5:18 PM -
0 Votes
Single SQL query update multiple rows
An UPDATE is a statement, not a query.Answered | 5 Replies | 2830 Views | Created by swivan - Friday, October 17, 2014 10:16 AM | Last reply by --CELKO-- - Friday, October 17, 2014 6:28 PM -
3 Votes
Enhance merge query performance
By the way, have you check the Execution Plan of your query?Answered | 3 Replies | 831 Views | Created by Bhushan Gawale - Friday, August 3, 2018 10:06 AM | Last reply by Xi Jin - Monday, August 6, 2018 5:52 AM -
0 Votes
Inserting million of rows with help of while loop
--create data source, 10 sample value which will duplicate, i insert 3 value for this sample declare @table table(row int,Name varchar(20),address varchar(100)) insert into @table ...Answered | 4 Replies | 26988 Views | Created by D S S - Friday, July 19, 2013 11:21 PM | Last reply by Soonyu - Monday, July 22, 2013 2:57 AM -
0 Votes
Optimize query Searching 15 million Records
<Answered | 8 Replies | 3864 Views | Created by Sonic.Jessy - Sunday, September 27, 2009 1:44 AM | Last reply by Adam Haines - Monday, September 28, 2009 2:25 AM -
0 Votes
Updating 50 million entries of a varchar(4000) field
In your case, you can just monitor during the UPDATE.Answered | 12 Replies | 5097 Views | Created by Abid H - Tuesday, March 1, 2011 3:01 PM | Last reply by Kalman Toth - Wednesday, March 2, 2011 1:33 PM - Items 1 to 20 of 1641578 Next ›
No announcements
