Viewing 15 posts - 21,946 through 21,960 (of 22,197 total)
I'd move this kind of processing into SSIS. You've really stepped outside what TSQL is meant to do with all the file I/O. You'll probably get the same or better...
April 4, 2007 at 7:04 am
Thank you. Yes, that is on the list as a possibility. I'm just trying to explore the space and I'm not finding much in the way of documented approaches.
April 3, 2007 at 11:04 am
True, and it's something I'm looking into, but it makes me even more nervous. As the article you link to states, if the app isn't processing this information as fast...
April 3, 2007 at 9:21 am
That would eliminate any chance of holding locks, but it will put more of a load on tempdb since table variables are stored there.
I'm not really looking to radically...
April 3, 2007 at 5:19 am
I doubt this will give you everything you might need, but it will certainly get you started. These are Microsoft's Best Practices as implemented by their own consultants.
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx
April 2, 2007 at 12:13 pm
We probably could use BCP and realize some performance improvements, definately. However, we're finding the performance is more than adequate, we've got it in Production as well as having tested...
April 2, 2007 at 5:19 am
From this, you should try adding an index to the temp table, [#ProducedHour]. The first one I'd try, and you will need to test anything you do, would be to...
March 30, 2007 at 6:51 am
#6Df65D3E is probably a statistic added to one of the tables because an index is needed for the query you're running and that index isn't there. The worktables are usually...
March 29, 2007 at 10:39 am
Regarding books, if you're interested in a little work to get the book for free, the book review SIG over at SQL PASS will have a host of new books...
March 29, 2007 at 5:15 am
I've been pretty disatisfied with all the Quest products that we have licensed with two exceptions. Quest Data Factory and Quest Benchmark Factory are darned good products. I'm using the...
March 28, 2007 at 6:51 am
Steve, you are absolutely wrong on this one... depending.
March 28, 2007 at 6:24 am
I was just going to look this up and I saw your response. Thanks for the assist.
I'll look into updating the article, but if I can't, at least your comments...
March 27, 2007 at 11:18 am
No, unfortunately, you're probably after the right stuff hitting the system tables. There just isn't as much information available in 2000 as is presented in 2005. You should post in...
March 27, 2007 at 9:44 am
Since you're working in 2005, there are reports and dynamic management views for getting this information. For example, the report Disk Usage by Table returned this data from AdventureWorks: