Viewing 15 posts - 1 through 15 (of 43 total)
Hello Sue-H, it was my mistake, your answer woke up me, I put the correct certificate (there was a confusion) and all Works fine.
June 18, 2019 at 1:17 pm
Hello Sue_H, of course, for that I don't understand.
June 13, 2019 at 6:33 am
Hello sgmunson, hello Jeff Moden, thanks for yours answers.I wrote the new function 4-5 days ago and i didn't use the CTE recursive and it is faster than the ...
December 20, 2018 at 4:56 am
Hello Thomas, thanks, i didn't know that, I will rewrite the function, i don't want but...
I try this (in 2008 I do...):I have a table with the...
December 11, 2018 at 8:48 am
I will follow yours recommendations, wait stats in extended event and to rewrite de code.Grant,...
September 10, 2018 at 7:33 am
Hello Grant.I use a extended event sqlserver.rpc_completed and the DMV sys.dm_exec_procedure_stats because the application executes procs, never adhoc. A lot of procs use sp_executesql.I don't need a perfect match for...
September 10, 2018 at 6:13 am
Jeff, thank you very much.
June 27, 2018 at 8:25 am
NorthernSoul, Sue_H, thanks for yours answers.Then i can suppose that the best option is to control engine, applications, etc, etc to determine the best space for tempdb and to...
June 26, 2018 at 1:01 am
Anthony Green, now yes, i had a little confusion because, i thought that for to set READ_COMMITTED_SNAPSHOT,...
April 3, 2018 at 9:31 am
Hello Jeff, thank you for yours recommendations.There is an error in the second proc, is "id>=@id", not "@id>=@id"In the first, if you pass null on @Id, return all...
February 7, 2018 at 7:37 am
Thanks for all, yours opinions are importants for me.
February 2, 2018 at 12:52 am
Hello, thanks for yours answers.The idea is that procedures return one row or all, simple idea for a simple example.The table is a simple and little table, with...
February 1, 2018 at 8:59 am
Hello Steve.I understand and i don't have problems with to put sets in the code. I only said that i would like to know if i can to change...
January 30, 2018 at 1:17 am
John, why not?We have definied a default value for user options of 5496 and i don't understand why the job changes it. I would like to know how...
January 29, 2018 at 9:54 am
John, Sue, thanks for all answers.I knew that Sets in code are above sp_configure values.It isn't a problem.With a trace, I detected a curious thing: With the...
January 29, 2018 at 9:41 am