Viewing 15 posts - 3,271 through 3,285 (of 22,214 total)
Here is the link to the GoFundMe for Robert's family in case you're interested.
April 3, 2018 at 3:50 pm
No details yet, but word has been spread that Robert Davis has died. I'm so very sorry to be the one to pass this on to you all. However, I...
April 3, 2018 at 3:00 pm
April 3, 2018 at 5:42 am
April 3, 2018 at 4:43 am
April 2, 2018 at 5:24 pm
Assuming you mean remove either unnecessary or unwanted data when you say "purge" (although I'm with everyone else, what do you mean?).
Normally, a properly structured database will foreign...
April 2, 2018 at 9:05 am
Thanks Grant and appreciate the response! Oddly enough, I tested on two different dev boxes...
March 29, 2018 at 7:45 am
Thanks Grant and appreciate the response! Oddly enough, I tested on two different dev boxes...
March 29, 2018 at 7:43 am
In your situation, you need to be using UPDATE STATISTICS, not sp_update_stats. The latter is just a shortcut to performing the former. You can look at the code. All it...
March 29, 2018 at 7:20 am
March 29, 2018 at 7:16 am
March 29, 2018 at 7:13 am
Nesting functions, even inline functions, leads to all sorts of performance problems.
March 28, 2018 at 4:49 am
So, if we have to have linked queries (and eliminating these ought to be a goal), then we should at least push the filtering down to the linked servers. See...
March 28, 2018 at 4:36 am
Things like this destroy the possibility of performance enhancement
March 28, 2018 at 4:30 amON LTRIM(RTRIM(WP.ITEMID))
saptek9 - Tuesday, March 27, 2018 9:51 AMThank you. What about creating view instead table variables?
A view is nothing but a...
March 28, 2018 at 4:27 am
Viewing 15 posts - 3,271 through 3,285 (of 22,214 total)