Viewing 15 posts - 18,286 through 18,300 (of 59,070 total)
dunno_developer (2/25/2016)
Have you considered partitioning your large tables?
Partitioning will allow you to maintain your larger tables as you can target only the partitions which are require maintenance.. (depends what...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2016 at 10:35 am
astrid 69000 (2/25/2016)
thanks!!!! :kiss:it worked
The question now is... do you understand it well enough to both maintain it and do it again for something else?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2016 at 8:51 am
ganapathy.arvindan (2/25/2016)
please suggest me reduce...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2016 at 8:45 am
Grant Fritchey (2/25/2016)
Jeff Moden (2/25/2016)
Markus (2/25/2016)
Is it possible to run profiler and see what userid is connecting and running that query?
Agreed. Setting it up to find the name of...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2016 at 8:39 am
Apparently, all that predictive analysis with a PB per day didn't do squat for Netflix. Their stock dropped from a high of ~131 on 4 Dec 2015 to ~83...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2016 at 8:36 am
Apologies... David's post reminded me that I didn't actually answer the question as to how to make the queries in the original post faster.
For these...
select gi.*
from tblGeneral gi
join...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2016 at 8:16 am
TeraByteMe (2/24/2016)
I started the job almost...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2016 at 7:55 am
kenksoftware (2/24/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2016 at 7:23 am
My first speech was at Instructor Training for the Navy. There was no preparation involved. It was simply to get our feet wet and all we had to...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2016 at 7:19 am
Markus (2/25/2016)
Is it possible to run profiler and see what userid is connecting and running that query?
Agreed. Setting it up to find the name of the proc in the...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2016 at 6:56 am
Lowell (2/24/2016)
i've found that some groups cannot be enumerated int he cases...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 24, 2016 at 8:41 pm
My suggestion would be to find out who's placed the limitations and see if they like high velocity pork chops. If they don't see the light, give the job...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 24, 2016 at 8:29 pm
Thanks for taking the time to "give back". Ola would probably love to hear about your improvements. You might want to stop by his site and drop the...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 24, 2016 at 8:22 pm
meajaykr (2/24/2016)
We moved 2 databases 2 some other servers and issue is resolved.
But we...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 24, 2016 at 8:09 pm
mario17 (2/24/2016)
They are not really mine, but yes - they are named sp_*, which is doesn't matter for my case I thought.
+ they have at the very top like below,...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 24, 2016 at 8:00 pm
Viewing 15 posts - 18,286 through 18,300 (of 59,070 total)