Viewing 15 posts - 15,766 through 15,780 (of 59,063 total)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 29, 2017 at 12:55 pm
That's because you changed the ORDER BY from "SortPath" to "t.hLevel
--Jeff Moden
Change is inevitable... Change for the better is not.
January 29, 2017 at 8:29 am
Denesh Naidoo - Thursday, January 26, 2017 10:14 PMThanks for the response.Will look into increasing Tempdb
A much better thing to do is...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 27, 2017 at 6:44 pm
I can't speak to the "managed code" side of the house but we review ALL database code. New code is reviewed head to toe for accuracy, possible performance problems, code...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 27, 2017 at 5:57 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
January 27, 2017 at 3:54 pm
Start off by running the "Upgrade Advisor".
--Jeff Moden
Change is inevitable... Change for the better is not.
January 27, 2017 at 10:38 am
Turn off the NO OUTPUT option and see if it really was a "Success".
--Jeff Moden
Change is inevitable... Change for the better is not.
January 27, 2017 at 10:23 am
BrainDonor - Friday, January 27, 2017 1:30 AM
Peeerrrfffeeccctttt! I'm gonna get me some. 😉 Then I'm going to have them make...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 27, 2017 at 8:46 am
--Jeff Moden
Change is inevitable... Change for the better is not.
January 27, 2017 at 8:23 am
--Jeff Moden
Change is inevitable... Change for the better is not.
January 27, 2017 at 8:15 am
If you want help on performance, please read and heed the article at the second link under "Helpful Links" in my signature line below.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 27, 2017 at 7:58 am
Hmmm... After reviewing the discussions, it seems that the flame wars have scared off a potentially good author since this is the only article he's published in 4 years.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 27, 2017 at 7:53 am
--Jeff Moden
Change is inevitable... Change for the better is not.
January 26, 2017 at 8:58 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
January 26, 2017 at 8:42 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
January 26, 2017 at 7:13 pm
Viewing 15 posts - 15,766 through 15,780 (of 59,063 total)