Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: EmilyPaterson
- Order by date
-
Simpler code to speed up process?
So I just ran the query on all 50 columns, and it actually took under 5 mins. (Not sure why it took 8 mins on 2 columns...) You guys are great! Thanks again.- EmilyPaterson
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Simpler code to speed up process?
Hi everyone, Thanks everyone for responding so quickly, and for helping out a newbie. I think I've got it sorted now. I created a new table and formatted the threshold columns as bits, and then combined all the update queries into one. I tested it out on 2 thresholds, and it took 8 mins to...- EmilyPaterson
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Simpler code to speed up process?
Hi all, I'm quite new to SQL, so please bear with me. I've managed to write some code which does what I want it to do, but it is taking a really long time to process. I don't fully understand the process SQL goes through to execute a query, so I was hoping that someone could help me...- EmilyPaterson
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
