Viewing 15 posts - 151 through 165 (of 2,458 total)
Not a complete list but some highlights...
Pro's:
1. Can be faster than on-disk tables because of there's no IO cost.
2. A bonus benefit of 2016 vs...
January 7, 2018 at 5:16 pm
Great article, very well done. You completely skipped over the era of magnetic tapes but I won't hold it against you.
January 4, 2018 at 6:21 pm
Can this be done for a whole table within a view...
January 4, 2018 at 6:16 pm
This is running much slower for you than it should. Your query is instantaneous on my laptop as well. I even created 10K rows of sample data and tested it. This...
December 27, 2017 at 2:17 pm
I remember reading DOS for Dummies in 1996 (studying for the A+ exam) and, in it, there is a discussion about how DOS is never going away. I thought the...
December 26, 2017 at 9:32 am
December 13, 2017 at 5:36 pm
It Depends.
It depends on how you're querying these tables, how you're joining them, what kinds of Aggregations you're performing, how your data is partitioned and stuff like that.
December 13, 2017 at 12:10 pm
I don't use OPENXML often but knowing XPath makes this sort of thing pretty easy. Here I'm using a variable for the XML so that you can copy/paste...
December 13, 2017 at 11:49 am
December 13, 2017 at 8:34 am
December 12, 2017 at 11:23 pm
December 12, 2017 at 3:14 pm
Thanks for the interest. Unfortunately, my scenario is rigidly as described as far...
December 12, 2017 at 3:01 pm
Do what you love and the money will come; nobody is awesome at stuff they don't like to do - regardless of how well it pays.
This has been...
December 12, 2017 at 1:51 pm
Viewing 15 posts - 151 through 165 (of 2,458 total)