Viewing 15 posts - 42,916 through 42,930 (of 59,063 total)
I dunno... SAN snapshots work really well.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 19, 2009 at 3:56 pm
Why would anyone think that INTERSECT is easier than INNER JOIN?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 19, 2009 at 3:51 pm
Mansfield (7/19/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 19, 2009 at 3:50 pm
And, yes... Gail has absolutely the right idea for the main table.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 19, 2009 at 9:06 am
awp (7/18/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 19, 2009 at 8:48 am
You bet, Mahesh. Thank you for the feedback.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 19, 2009 at 8:42 am
I had similar feelings when PIVOT came out. Proves that "new" or "different" is frequently not better, faster, or easier to read. ๐
Good article David. Thanks for taking...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2009 at 5:11 pm
awp (7/18/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2009 at 4:56 pm
In fact, take a look at the following article so you can see more of what I mean... these types of reports can be made to run very fast and...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2009 at 4:03 pm
awp (7/18/2009)
I canโt understand...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2009 at 4:01 pm
First of all, that table is setup for CDR's (Call Detail Records). Rather I should say it's set up incorrectly for CDR's. Almost all of the columns are...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2009 at 12:18 pm
Gosh... even though this is just a reporting table, I still wouldn't add the 10 columns to it unless it were trully normalized data. What is in the 10...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2009 at 11:51 am
Let me come right out and say it... don't use CONVERT to strip the time... it's at least ten times slower than just about any other method.
So far as testing...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2009 at 11:44 am
Thanks for the feedback, TJ.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2009 at 8:11 am
Absolutely, Lynn. Nicely done.
As a side bar, I used to believe that correlated sub-queries were a form of RBAR and, in many cases, they absolutely are and will have...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 18, 2009 at 7:28 am
Viewing 15 posts - 42,916 through 42,930 (of 59,063 total)