June 30, 2017 at 8:59 am
How did the water cooler get derailed into a technical solution? Are the hippos on vacation?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 30, 2017 at 9:12 am
Sean Lange - Friday, June 30, 2017 8:59 AMHow did the water cooler get derailed into a technical solution? Are the hippos on vacation?
Dunno about the hippos, but I am (only 2 days unfortunately)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2017 at 9:29 am
GilaMonster - Friday, June 30, 2017 9:12 AMSean Lange - Friday, June 30, 2017 8:59 AMHow did the water cooler get derailed into a technical solution? Are the hippos on vacation?Dunno about the hippos, but I am (only 2 days unfortunately)
Starting a 4 day weekend here in the U.S. as we celebrate our Independence on Tuesday. I am actually leaving the office about 11am today to go to Scout camp and help tear down the huge tents and such after the boys get all their stuff out.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 30, 2017 at 9:41 am
Sean Lange - Friday, June 30, 2017 9:29 AMGilaMonster - Friday, June 30, 2017 9:12 AMSean Lange - Friday, June 30, 2017 8:59 AMHow did the water cooler get derailed into a technical solution? Are the hippos on vacation?Dunno about the hippos, but I am (only 2 days unfortunately)
Starting a 4 day weekend here in the U.S. as we celebrate our Independence on Tuesday. I am actually leaving the office about 11am today to go to Scout camp and help tear down the huge tents and such after the boys get all their stuff out.
Nice. I'm done at noon, which is the same time because you're in Central and I'm in Eastern.
I've got a pork shoulder and a pork loin ready to go in the smoker this weekend. I'll do the loin to temperature, but I'm going to go 14 hours on the shoulder so all that collagen in the connective tissue breaks down into gelatin. To me, it's completely worth the time. I'm using 100% apple wood.
June 30, 2017 at 9:49 am
Ed Wagner - Friday, June 30, 2017 9:41 AMSean Lange - Friday, June 30, 2017 9:29 AMGilaMonster - Friday, June 30, 2017 9:12 AMSean Lange - Friday, June 30, 2017 8:59 AMHow did the water cooler get derailed into a technical solution? Are the hippos on vacation?Dunno about the hippos, but I am (only 2 days unfortunately)
Starting a 4 day weekend here in the U.S. as we celebrate our Independence on Tuesday. I am actually leaving the office about 11am today to go to Scout camp and help tear down the huge tents and such after the boys get all their stuff out.
Nice. I'm done at noon, which is the same time because you're in Central and I'm in Eastern.
I've got a pork shoulder and a pork loin ready to go in the smoker this weekend. I'll do the loin to temperature, but I'm going to go 14 hours on the shoulder so all that collagen in the connective tissue breaks down into gelatin. To me, it's completely worth the time. I'm using 100% apple wood.
Awesome!!! My smoker is on hiatus at the moment. :crying: I tore out the deck earlier this spring because it was literally falling off the house. I am replacing it with a pave stone patio. I just got a pallet of stones delivered Wednesday so I think we know what my "vacation" weekend is going to entail. I am thinking I may just set up the smoker on the driveway on Tuesday anyway and throw on some ribs. They don't take too long so I can still get some work done.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 30, 2017 at 9:49 am
Sean Lange - Friday, June 30, 2017 8:59 AMHow did the water cooler get derailed into a technical solution? Are the hippos on vacation?
Who are you calling a hippo?
I mean, I'm know I'm... big... but that's uncalled for!
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 30, 2017 at 9:56 am
Sean Lange - Friday, June 30, 2017 8:59 AMHow did the water cooler get derailed into a technical solution? Are the hippos on vacation?
My fault I suppose, I wasn't really looking for help, but everyone here is so generous! 😀
June 30, 2017 at 10:14 am
Chris Harshman - Friday, June 30, 2017 9:56 AMSean Lange - Friday, June 30, 2017 8:59 AMHow did the water cooler get derailed into a technical solution? Are the hippos on vacation?My fault I suppose, I wasn't really looking for help, but everyone here is so generous! 😀
And we can't resist, especially when it is one of our own that needs help.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 30, 2017 at 10:49 am
Chris Harshman - Friday, June 30, 2017 9:56 AMSean Lange - Friday, June 30, 2017 8:59 AMHow did the water cooler get derailed into a technical solution? Are the hippos on vacation?My fault I suppose, I wasn't really looking for help, but everyone here is so generous! 😀
First thing I will say, is that cursors may be evil but they also have their place. If that is what works best, nothing wrong with using it, I just like to explore all options.
I may still look at other options just because I want to see what other alternatives exist.
June 30, 2017 at 10:51 am
Chris Harshman - Friday, June 30, 2017 9:56 AMSean Lange - Friday, June 30, 2017 8:59 AMHow did the water cooler get derailed into a technical solution? Are the hippos on vacation?My fault I suppose, I wasn't really looking for help, but everyone here is so generous! 😀
Well, I guess the Guard Hippo thought it was okay since I started asking questions.
😀
June 30, 2017 at 5:32 pm
Chris Harshman - Friday, June 30, 2017 8:51 AMOK, I've even tried using XCOPY /L /S /D to try to limit the filenames returned by date, so I only get a few thousand instead of the millions and millions of files, but this command still seems to take 3 or 4 minutes to just get this list. Thanks again to everyone who tried to look at this, but the cursor based approach runs entirely in under a minute for me, so I'm sticking with this:
Agreed. If you know the full path to a file, then that would be equivalent to an "Index Seek" rather than a scan across millions of rows in a hierarchical fashion.
However, if you really do have millions of files in a relatively unstructured folder structure, it might be time to add some structure. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
June 30, 2017 at 11:15 pm
I would check how many unique location are stored in the table.
If there are no too many of them then I'd create a cursor for DIR each of them, no /S option.
I'd also consider extension filter. You must be looking for files of a specific type. Must be speeding up the process as well.
_____________
Code for TallyGenerator
July 4, 2017 at 1:21 am
Happy holidays to our wonderful neighbours across the water, celebrating Brexit 1776!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
July 4, 2017 at 10:17 am
ChrisM@Work - Tuesday, July 4, 2017 1:21 AMHappy holidays to our wonderful neighbours across the water, celebrating Brexit 1776!
BWAAA-HAAA!!! Now that's just funny! Thanks, Chris. You made my day. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2017 at 1:10 pm
Some people are kinda getting on my nerves.
People who are the excellent at something usually don't have to go around proclaiming that fact.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 59,086 through 59,100 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply