Viewing 15 posts - 31 through 45 (of 154 total)
One possible explanation, assuming identical parameter values, is that a plan recompile occurred. The execution from Profiler was in one plan and the execution from SSMS was in a...
July 29, 2021 at 3:38 pm
I read your question a little differently than Grant and Jeff, so I just wanted to confirm what you were looking to do.
If I understand your question correctly, you...
July 14, 2021 at 2:23 pm
Even Grant will tell you that's just scratching the surface on such things. Before you use one of them, you really need to study the documentation.
well noted,Than you Jeff...
July 9, 2021 at 12:23 am
Thank you Grant Fritchey!
July 8, 2021 at 2:52 pm
I notice that even if we don't restart SQL Service, the data of sys.dm_exec_query_stats( sys.dm_exec_sql_text() and sys.dm_exec_query_plan() ) will be reset or removed/refreshed. when the data of sys.dm_exec_query_stats...
July 8, 2021 at 4:26 am
The DMVs are completely dependent on the cache. That's where the information comes from. So, anything that affects the cache, will affect the data in the DMVs. For example,...
July 8, 2021 at 4:24 am
Good day!
anyone can help me the said question? thanks!
June 24, 2021 at 1:08 am
So your saying that the following code that you posted took over 5 hours?
SELECT sm.Object_ID, Definition = ls.LongString FROM sys.SQL_Modules sm CROSS APPLY dbo.ShowLongString(sm.Definition) ls
I just ran that code...
June 9, 2021 at 7:47 am
Considering that my last name contains only 5 letters and you couldn't even spell that right, I suspect a PICNIC problem on your part. The code runs nasty fast...
June 9, 2021 at 1:46 am
I had published an article for doing such a thing and a fellow by the name of Orlando Colamatteo gave me the idea of the following...
June 8, 2021 at 1:20 am
when you get really big strings like that, and want to visualize them in SSMS, you can TRY_CONVERT to xml; then when you click it , it opens in...
June 4, 2021 at 12:37 am
anyone help me with the said question, thanks so much!
June 3, 2021 at 6:14 am
SSIS is fairly rigid in how it works, so you have to be wary of DDL/Schema drift.
You can easily create a SSIS package which will copy ServerA TableA...
April 22, 2021 at 7:44 am
What do you mean by "Dynamically" here? You can define the sources/destinations with expressions, yes, but the data flow part of SSIS has to be well defined so...
April 22, 2021 at 7:38 am
EXCEPT is great. But to be clear, it doesn't require that the tables have identical structures, it compares the results of two queries. You can select a...
April 21, 2021 at 2:09 am
Viewing 15 posts - 31 through 45 (of 154 total)