Viewing 15 posts - 106 through 120 (of 771 total)
We pass parameters into the procedure build by OLA, with this percentage and the job calculates what is low, medium or high. Default being 5% 30 % and above for...
October 25, 2017 at 11:46 am
I am thinking in using OLA scripts. Where he stated that if index is 5÷ or less then it is not needed. If between 5 and 30, properly try a...
October 25, 2017 at 11:39 am
I added the word indexstats.page_count as below but...
October 25, 2017 at 8:12 am
The one that I found is this:
SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName,
ind.name AS IndexName,
October 25, 2017 at 7:25 am
Sorry, did not undertood your answer. There is really a SQL Server 2017 version now? If it is the case, its strange, why? normally microsoft releases versions from 3 to...
October 25, 2017 at 3:48 am
Thank you very much. It seems very good.
I was readying and I don't understand one thing.
Normally, it I reorganize indexes I always do an update staticts....
October 25, 2017 at 3:45 am
Hello,
What is the link to find the OLA scripts?
October 25, 2017 at 3:12 am
Thank you very much for your answer and support. Vou are right. I dont know how but the signs were still there even with the replace function. I have re...
October 24, 2017 at 10:24 pm
Hello, thank you for your answer. This was already done. It does not seem to be that. I dont know if its the range of the number or something else.
October 23, 2017 at 12:00 pm
Hello,
Thank you very much for your reply. Yes. My column names are in 11 and worksheet name also ok.
There is only one thing. Colum names...
October 18, 2017 at 5:36 am
Thank you very much.
When I execute the query (first one) I get below errror:
Msg 229, Level 14, State 5, Line 7
The...
October 16, 2017 at 9:14 am
Sorry I just found. Its a simbol. thanks
October 13, 2017 at 2:54 am
Viewing 15 posts - 106 through 120 (of 771 total)