Viewing 10 posts - 1 through 10 (of 10 total)
I use a similar approach (converting the statement to XML), but slightly different. I've seen this method in various open-source scripts, most notably in Adam's Machanic sp_WhoIsActive and I've seen...
May 7, 2019 at 6:50 pm
Nice article. What I usually do, is use what I call SQL snippets and placeholders which I later use to replace / inject what I need. For example:
SQL snippet:
April 29, 2019 at 11:43 am
Hi folks
I just came across this script and one thing that puzzled me was this piece of code:
(CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.user_seeks)+CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.unique_compiles))*CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.avg_total_user_cost)*CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.avg_user_impact/100.0) AS Score
I usually saw the seeks added up...
July 9, 2014 at 6:42 am
I agree and I found the name... Was saying to make it public in their apology letter, although, now that thinking it out loud, it would create more publicity for...
June 23, 2014 at 6:31 am
Also, would be beneficial to make the name of the "author" public so other sites will be aware of him and his practices.
June 23, 2014 at 4:44 am
I'm using that as well, in conjuction with what I already mention, but this is still internal and relies on SQL server services to be successfully brought online.
October 6, 2011 at 2:49 am
I am using a similar approach, but outside the monitored clustered SQL Server. I have added an external application (a .CMD file) as a clustered resource. It uses a SQLCMD...
October 6, 2011 at 1:42 am
Working on that... Will keep you all posted. Thank you, all, so far.
February 24, 2011 at 6:25 am
Yes, it does. All SQL Services run as a local user account with read privilleges on the local folder. I have already checked that. I'm stuck...
February 24, 2011 at 5:58 am
Thank you, guys.
The DelayValidation did the trick. I don't know how I overlooked it. Thanks again.
But.... 🙂
Still got errors. When I assign the local path to the LocalPath property, I...
February 24, 2011 at 5:26 am
Viewing 10 posts - 1 through 10 (of 10 total)