tag:blogger.com,1999:blog-41406412024-03-14T13:05:51.289+11:00JoeJoeInc.comAutomate and Standardise. Keep It SimpleJoejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.comBlogger563125tag:blogger.com,1999:blog-4140641.post-2814586337652376742021-07-20T16:47:00.003+10:002022-05-25T13:12:26.236+10:00Citrix Indirect Display Adapter crashes external monitor<div>I found my monitor would crash and reset on various websites that used rich streaming media like netflix. I found it was my external monitor that crashed.</div><div><br /></div><div>Check if you have Citrix workspace installed. Uninstall it.</div><div><br /></div><div>If you need to reinstall it then reinstall it from the command prompt using </div><div><br /></div><div>CitrixWorkspaceApp.exe ADDLOCAL=ReceiverInside,ICA_Client,AM,SELFSERVICE,DesktopViewer,Flash,Vd3d,WebHelper,BrowserEngine</div><div><br /></div><div>YAY no more citrix indirect display adapter. this fixed my issue. </div><div><br /><br /></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://lh3.googleusercontent.com/-laRtijq2nNk/YPZxSJ4r7XI/AAAAAAAB9hg/9vMLLvmRqGga7fjQMXF1FCTkI_-90efLQCNcBGAsYHQ/image.png" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="79" data-original-width="273" height="93" src="https://lh3.googleusercontent.com/-laRtijq2nNk/YPZxSJ4r7XI/AAAAAAAB9hg/9vMLLvmRqGga7fjQMXF1FCTkI_-90efLQCNcBGAsYHQ/image.png" width="320" /></a></div><br /><br /></div><div><br /></div><div><br /></div>If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-59226076336258428032020-09-14T08:18:00.003+10:002020-09-25T11:29:02.055+10:00Pixel 2 XL reboots when plugged into charger (or shortly after being plugged in) <div>So my trusty Pixel 2 XL started resetting whenever plugged into a charger. It would reset and then show the charging battery logo on the screen along with a small bunch of white lines at the top of the screen. </div><div>It also turns out my phone would reset with any charger I tried, be it the one next to the bed, the one in the car, or the USB C power plug in the kitchen. So with every charger now being an issue, I suspected the phone was at fault. </div><div><br /></div><div>As always If you attempt this fix it's at your own risk. If you try this and break your phone further it's not my fault.</div><div><br /></div><div>Here is what I did to fix this issue on my Pixel 2 XL: </div><div>- Start by turning the phone off. We are going to clean the charging port. </div><div>- Use a pin or a needle to remove the gunk jammed into the charging port. Get out all that lint from putting your phone in your pocket. Be careful not to break anything in the port as you'll then have other issues to deal with.</div><div>- Next, grab an alcohol wipe and gently use the needle and the wipe to clean the internal contacts inside the charging port. I had to use the needle very gently to push a small part of the wipe into the charging port and then used the needle to push the wipe around and clean the contacts. A surprising amount of black gunk was wiped off the contacts. </div><div>- Allow your phone charging port to dry out before turning your phone back on. </div><div>- When ready turn your phone back on and use it until the battery runs completely flat (0%) </div><div>- Now put it on charge and leave it to charge for a full cycle (from 0% to 100%). Turn your phone on and see how you go</div><div><br /></div><div><br /></div><div>two-week update, after two weeks the issue came back on a wet camping weekend. So I took the drastic step of backup and factory reset. This has seemed to work but I will monitor it again for the next few weeks. </div><div><br /></div><div><br /></div><div>If you find this article useful please leave me a comment.</div>Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-72079268543387207282020-01-31T11:01:00.000+11:002020-01-31T11:01:12.752+11:00How to move/switch XBOX's in the Google assistantSo you replaced an Xbox with a new one and now you can't get the google assistant to work?<br />
<br />
1. Logon to your New Xbox and then go to settings > Devices & Streaming > Digital assistants > Enable Digital assistants.<br />
2. Now, set up a new device in Google home on your phone (link your Xbox service)<br />
3. Profit.<br />
<br />
How to remove the old device?<br />
Turn your old Xbox back on, disable the digital assistant instead of enabling it.<br />
<br />
What do I do if I don't have my old Xbox?<br />
NFI? Pray to Microsoft? Call for support?<br />
<br />
<br />Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-68582154951039197972019-01-09T13:38:00.000+11:002019-01-09T13:38:01.449+11:00Possible scam - Consumer Projects Group AustraliaToday received a call asking if I would like to be paid money for doing surveys from a Consumer Projects Group Australia. They wanted to send someone to my house to interview me and show me a matrix and ask for feedback on this matrix. they promised for 20 minutes of my time I would get $35. They then asked If I was free to have someone come around within the next few days.<br />
<br />
I agreed to today or tomorrow as a test and they asked for an address straight away. I then changed my mind and said I was busy on those days. The lady on the phone then said "in that case, I will call you back" then promptly hung up on me without a goodbye.<br />
<br />
The number the call came from was<br />
02 7713 3179<br />
<br />
If you call that number it appears as disconnected Optus mobile number. and there isn't a clear domain or business called 'Consumer Projects Group Australia'<br />
<br />
as of now, I wouldn't trust this caller. it just didn't sound right.<br />
<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-91716709264011989622018-08-03T09:33:00.000+10:002018-08-03T09:33:38.159+10:00How to Tell If Your Users are Connecting to the Availability Group ListenerPatrick over at <a href="http://www.patrickkeisler.com/">http://www.patrickkeisler.com</a> explains this nicely<br />
<br />
<a href="http://www.patrickkeisler.com/2013/08/how-to-tell-if-your-users-are.html" target="_blank">How to Tell If Your Users are Connecting to the Availability Group Listener</a><br />
<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-15970279571376063032018-04-10T11:11:00.002+10:002018-04-10T11:11:29.808+10:00Why is Powershell blocking scripts from UNC paths? If you are seeing errors and warnings trying to execute Powershell scripts from UNC paths on Windows 2012 and you have the IE enhanced security turned on Powershell won't' automatically execute your scripts.<br />
<br />
You will get a prompt like so; 'Run only scripts that you trust'.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-Lx5yL-3nogo/WswNmd3CD6I/AAAAAAABS_c/V4PEWOyF-uEIskASr4PK9rdgcoKHWGZ2QCLcBGAs/s1600/SECWARN.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="87" data-original-width="662" height="52" src="https://4.bp.blogspot.com/-Lx5yL-3nogo/WswNmd3CD6I/AAAAAAABS_c/V4PEWOyF-uEIskASr4PK9rdgcoKHWGZ2QCLcBGAs/s400/SECWARN.jpg" width="400" /></a></div>
<br />
The reason for this is that Windows treats the UNC paths as being from the internet and therefore doesn't trust anything on the UNC path<br />
<br />
There are two solutions to this issue.<br />
<br />
1. Add the UNC paths to the trusted sites list (either Via Regedit or GUI)<br />
or<br />
2. Turn off the Enhanced security<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-bT5JAAiMHNE/WswOdT9jM5I/AAAAAAABS_o/i7iIdY3spiIByyiPpS2UfrG91-amSWctgCLcBGAs/s1600/enhance.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="475" data-original-width="1291" height="117" src="https://2.bp.blogspot.com/-bT5JAAiMHNE/WswOdT9jM5I/AAAAAAABS_o/i7iIdY3spiIByyiPpS2UfrG91-amSWctgCLcBGAs/s320/enhance.jpg" width="320" /></a></div>
As a side note; some sites recommend using the unblock-file cmdlet but I've found that it doesn't address the issue of trusting the UNC paths.<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-45970152634048721572018-03-21T10:56:00.000+11:002018-03-21T10:56:52.294+11:00Why haven't we automated trains yet? It seems it would be easier to automate trains before we automate cars. what's the holdup Sydney?<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-3844101652495686832018-03-16T10:15:00.000+11:002018-03-16T10:15:26.893+11:00Android Wear changing to WearOSSo Google is changing the name of Android Wear into WearOS. big whoop.<br />
<br />
<br />
https://wearos.google.com/<br />
<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-62292864244863954912018-03-08T12:02:00.001+11:002018-03-08T12:02:37.988+11:00SQL Server – Check Index Fragmentation on ALL Indexes in a Database | My Adventures in Coding<a href="https://myadventuresincoding.wordpress.com/2013/05/27/sql-server-check-index-fragmentation-on-all-indexes-in-a-database/">SQL Server – Check Index Fragmentation on ALL Indexes in a Database | My Adventures in Coding</a>: "Check Index Fragmentation on ALL Indexes in a Database"<br />
<br />
<br />
<br />
I found this quite useful. Only thing I wish I had taken a before screenshot before rebuilding the indexes using <a href="https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html" target="_blank">Ola Hallgren</a> scripts.<br />
<br />
<br />
<br />
<a href="https://chrome.google.com/webstore/detail/pengoopmcjnbflcjbmoeodbmoflcgjlk" style="font-size: 13px;">'via Blog this'</a> If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-26818175111836467602018-02-26T10:29:00.001+11:002018-02-26T10:29:35.607+11:00Carnival Legend: How to make cruises great again<a href="http://www.news.com.au/travel/travel-updates/incidents/how-to-make-cruises-great-again/news-story/be6b1b72d5cfc92b8444238a5e95e9fb">Carnival Legend: How to make cruises great again</a>:<br /><br />
<br /><br />
Dear Scott,<br /><br />
<br /><br />
I believe your opinion of Carnival is gravely misplaced.<br /><br />
<br /><br />
Personally, I can think of plenty of other things worse than a cruise holiday. I travelled on the Carnival Spirit last year and I did not find our family of 5 packed into like sardines at all. I found my holiday pleasant and the staff friendly and the island hopping was a fantastic experience.<br /><br />
<br /><br />
I travelled safe and sound throughout my whole holiday. Yes, I had seen plenty of news reports about gastro outbreaks on cruise ships. I must have been one of the lucky ones that escaped without a gastro incident just like the 1000's of others that travelled with me last year. <br /><br />
<br /><br />
I've also been to Airlie Beach and I can see the two holidays are completely different and simply can't be related to anything but saying they are both holidays.. one is mostly on land where the other is mostly on the sea.<br /><br />
<br /><br />
During my travels with Carnival, I found most people nice and friendly or had travelled from overseas just to cruise. Most of the time it was just families, couples and singles wanting to have a good time and create some great memories.<br /><br />
<br /><br />
Simply put if you get on a ship looking for a fight you shouldn't be there in the first place. but unfortunately, there will be dickheads no matter where we go on this planet.<br /><br />
<br /><br />
<a href="https://chrome.google.com/webstore/detail/pengoopmcjnbflcjbmoeodbmoflcgjlk" style="font-size: 13px;">'via Blog this'</a> If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-19418957962446201172018-02-14T10:40:00.000+11:002018-02-14T10:40:08.391+11:00Maybe don't set your database to 100% growth. It's not a good idea to set your databases to % growth anyway but setting them to 100% is just horrible. Every time your database has to grow when setting to 100% it will double in size a couple of those growth cycles and you'll be out of storage real soon.<br />
<br />
Better to set to an actual MB limit based on the size of your HDD. I.e if your Database drive is 1000MB only set it to 64MB or 128MB growth. that way you can see your DB grow over time<br />
<br />
<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-82670478237219771412018-01-08T16:39:00.000+11:002018-01-08T16:39:01.255+11:00Remove SQL 2012 performance dashboard <div class="tr_bq">
Microsoft in a recent update to SSMS put the Performance Dashboard directly into SSMS so you no longer need to manually install it on remote servers. Microsoft hasn't included a script to remove it, the easiest way to remove it is to manually edit the original script and rerun it</div>
<br />
Lucky for you I can save you 5 minutes of editing<br />
<br />
<br />
<blockquote>
<span style="font-family: Courier New, Courier, monospace;">USE [MSDB]</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.tblConfigValues'), 'IsUserTable') = 1</span><span style="font-family: Courier New, Courier, monospace;">drop table MS_PerfDashboard.tblConfigValues</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_CheckDependencies', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_CheckDependencies</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if not exists (select * from sys.schemas where name = 'MS_PerfDashboard')</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>exec('create schema MS_PerfDashboard')</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_WaitTypeCategory'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_WaitTypeCategory</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_QueryTextFromHandle'), 'IsTableFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_QueryTextFromHandle</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_hexstrtovarbin'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_hexstrtovarbin</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_DatediffMilliseconds'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_DatediffMilliseconds</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_Main_GetCPUHistory', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_Main_GetCPUHistory</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_Main_GetMiscInfo', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_Main_GetMiscInfo</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_Main_GetSessionInfo', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_Main_GetSessionInfo</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_Main_GetRequestInfo', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_Main_GetRequestInfo</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_Main_GetRequestWaits', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_Main_GetRequestWaits</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_GetPageDetails', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_GetPageDetails</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.usp_GetPlanGuideDetails'), 'IsProcedure') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_GetPlanGuideDetails</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.usp_TransformShowplanXMLToTable'), 'IsProcedure') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_TransformShowplanXMLToTable</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildColumnReference'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildColumnReference</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildColumnReferenceList'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildColumnReferenceList</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildDefinedValuesList'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildDefinedValuesList</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildOrderBy'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildOrderBy</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildRowset'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildRowset</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildScalarExpression'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildScalarExpression</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildScalarExpressionList'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildScalarExpressionList</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildScanRange'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildScanRange</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildSeekPredicates'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildSeekPredicates</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildSeekPredicatesNew'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildSeekPredicatesNew</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildSeekPredicate'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildSeekPredicate</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildObject'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildObject</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanBuildWarnings'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanBuildWarnings</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatAssert'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatAssert</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatBitmap'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatBitmap</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatComputeScalar'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatComputeScalar</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatConcat'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatConcat</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatCollapse'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatCollapse</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatConstantScan'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatConstantScan</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatDeletedInsertedScan'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatDeletedInsertedScan</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatFilter'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatFilter</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatHashMatch'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatHashMatch</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatMerge'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatMerge</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatNestedLoops'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatNestedLoops</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatParallelism'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatParallelism</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatSimpleUpdate'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatSimpleUpdate</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatRemoteQuery'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatRemoteQuery</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatRemoteScan'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatRemoteScan</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatRemoteModify'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatRemoteModify</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatSort'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatSort</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatSplit'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatSplit</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatStreamAggregate'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatStreamAggregate</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatSegment'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatSegment</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatSpool'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatSpool</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatTableScan'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatTableScan</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatTop'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatTop</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatTVF'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatTVF</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatUDX'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatUDX</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatUpdate'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatUpdate</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatRIDLookup'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatRIDLookup</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanFormatGenericUpdate'), 'IsScalarFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanFormatGenericUpdate</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if OBJECTPROPERTY(object_id('MS_PerfDashboard.fn_ShowplanRowDetails'), 'IsTableFunction') = 1</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop function MS_PerfDashboard.fn_ShowplanRowDetails</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_DatabaseOverview', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_DatabaseOverview</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_LargeIOObjects', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_LargeIOObjects</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_DBFileIO', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_DBFileIO</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_DmOsWaitStats', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_DmOsWaitStats</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_MissingIndexes', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_MissingIndexes</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_QueryText', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_QueryText</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_MissingIndexStats', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_MissingIndexStats</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_QueryAttributes', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_QueryAttributes</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_ShowplanAttributes', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_ShowplanAttributes</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_PlanParameters', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_PlanParameters</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_QueryStatsTopN', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_QueryStatsTopN</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_QueryStatsTopN1', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_QueryStatsTopN1</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_QueryStatsRecentActivity', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_QueryStatsRecentActivity</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_SessionRequestActivity', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_SessionRequestActivity</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_RequestDetails', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_RequestDetails</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_SessionData', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_SessionData</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_SessionRequests', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_SessionRequests</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_LastBatchForIdleSession', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_LastBatchForIdleSession</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_SessionDetails', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_SessionDetails</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_TraceEventColumns', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_TraceEventColumns</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_Blocking', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_Blocking</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_RequestIoWaits', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_RequestIoWaits</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_LargestIoRequests', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_LargestIoRequests</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_RequestWaits', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_RequestWaits</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_LatchStats', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_LatchStats</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_RequestsWithLatchWaits', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_RequestsWithLatchWaits</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_XEventSessions', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_XEventSessions</span><span style="font-family: Courier New, Courier, monospace;">go</span><span style="font-family: Courier New, Courier, monospace;"><br /></span><span style="font-family: Courier New, Courier, monospace;">if object_id('MS_PerfDashboard.usp_QueryStatsDetails ', 'P') is not null</span><span style="font-family: Courier New, Courier, monospace;"><span style="white-space: pre;"> </span>drop procedure MS_PerfDashboard.usp_QueryStatsDetails </span><span style="font-family: Courier New, Courier, monospace;">go</span></blockquote>
<br />
<br />
<br />
<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-43618543308795360072018-01-02T10:47:00.002+11:002018-01-02T10:49:57.866+11:00Sky Viper v2450GPS quadcopterPROs:<br />
<br />
<ul>
<li>Small and light </li>
<li>Works</li>
<li>Responsive </li>
<li>Come home feature(untested at this time) </li>
</ul>
<div>
<br /></div>
<div>
Con's:</div>
<div>
<ul>
<li>Inflight Video and pictures are blurry (camera has no gimble). </li>
<li>In random situations, the flight throttle has locked on to 100% (lucky I was indoors and there was a roof). This has happened twice now. </li>
<li>Android app crashes all the time</li>
<li>Video feed from drone to the phone is next to useless as it's choppy and lags behind quite a lot. (<a href="https://support.skyrocketon.com/hc/en-us/articles/115012253528-Sky-Viper-Supported-Mobile-Phones" target="_blank">Pixel 2 XL</a>) </li>
</ul>
</div>
<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-65012088394494749592017-12-15T14:28:00.004+11:002017-12-15T14:28:57.456+11:00Pixel 2 XL - Screen goes black when making calls<b>Issue: </b><br />
Screen goes black once you press the dial button to make a call. You then have to lock and unlock the phone to be able to hang up.<br />
<br />
<b>Fix: </b><br />
Open Settings > Apps & Notifications > All Apps > Phone > Storage<br />
<br />
Clear Cache<br />
Clear Data<br />
<br />
This fixed the issue for me (also big thanks to google support [shoutout to Paul.A])<br />
<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-54298941318844587542017-12-14T22:01:00.000+11:002018-04-03T14:53:03.712+10:00Pixel 2 XL screen flashing bright white on lock AKA the 'Pixel Flashbang'After updating to OREO 8.1 my screen started flashing when I lock the phone (one really bright white flash) and then the ambient display kicks in. in a dark room, this is very noticeable.<br />
<br />
Suspected issue:<br />
I'd say it's almost a race condition when the screensaver is turned on. Kind of like the screen is being told to turn on and then the instructions on what to show are just slightly slower and therefore the screen assumes you want all pixels full brightness until the instructions for the ambient screen are sent through. BUT I'm not a Google engineer so don't take my word for it.<br />
<br />
Workaround:<br />
Turn off ambient display<br />
<br />
Fix:<br />
Wait for Google to patch this (send them lots of bug reports)<br />
<br />
Notes: After disabling the ambient screen and rebooting, I then turned ambient display back on and now the issue isn't occurring anymore (more testing required)<br />
<br />
If you find this article useful please leave me a comment.<br />
<br />
Update:<br />
It's now 24 hours later and the phone has started to flash white again on locking and sometimes when waking up It's now slightly random it will flash when the screen has to wake up. I am now even more sure that this is probably a software bug in the ambient display software.<br />
<br />
Update2: 15/12/2017<br />
I found that there is a software called 'Pixel Ambient Services' in the apps. I cleared the 'cache' and the 'data' from this app/service. Currently, my screen isn't flashing on lock or wake now. I will continue to monitor and report on the issue here.<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-YJBoUcDeufU/WjRVnLRG35I/AAAAAAABOrk/I9zIqz1wEhUNvHAVsrHl9H3rppnQqAItgCLcBGAs/s1600/Screenshot_20171216-100456.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1600" data-original-width="800" height="320" src="https://4.bp.blogspot.com/-YJBoUcDeufU/WjRVnLRG35I/AAAAAAABOrk/I9zIqz1wEhUNvHAVsrHl9H3rppnQqAItgCLcBGAs/s320/Screenshot_20171216-100456.png" width="160" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://1.bp.blogspot.com/-f6L0cmJyBaQ/WjRVnRr3uJI/AAAAAAABOrg/EjXR4Mo7k5A05Lr-uh1ezcMSJJJQ_1T-gCLcBGAs/s1600/Screenshot_20171216-100543.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1600" data-original-width="800" height="320" src="https://1.bp.blogspot.com/-f6L0cmJyBaQ/WjRVnRr3uJI/AAAAAAABOrg/EjXR4Mo7k5A05Lr-uh1ezcMSJJJQ_1T-gCLcBGAs/s320/Screenshot_20171216-100543.png" width="160" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Update 3: 18/12/2017</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
The issue is back again. I'm going to call this a 'Pixel Flashbang' from now on as that's what it's like at 6 AM in the morning when I wake up and look at my phone. Clearing the above app cache stops it for awhile but it comes back and the issue is now intermittent. </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Update 4: 20/12/2017</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
I chatted with Google support and they said that there is no known fix yet but engineers are looking into it.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Update 5: 03/01/2018</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Still the same issue no matter which workaround is applied.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Rebooted in safe mode and still the same issue flashbangs on wake up of the screen.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Update 6: 05/01/2018 No update from Google about this. </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
More info </div>
<div class="separator" style="clear: both; text-align: left;">
http://www.redmondpie.com/is-your-pixel-2-xl-screen-flashing-while-locking-unlocking-youre-not-alone/</div>
<div class="separator" style="clear: both; text-align: left;">
http://www.androidpolice.com/2017/11/08/pixel-2-xl-screens-flashing-locking-unlocking/</div>
<div class="separator" style="clear: both; text-align: left;">
https://9to5google.com/2017/11/08/google-pixel-2-xl-screen-flashing/</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Final update: </div>
<div class="separator" style="clear: both; text-align: left;">
The Feb 2018 firmware update seemed to have resolved this issue. </div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br />Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-67420888443211213162017-11-24T12:22:00.000+11:002017-11-24T12:22:20.365+11:00Amaysim EnergyI thought this might be a good deal until I saw the price fact sheet.<br />
<br />
https://www.amaysim.com.au/energy/energy-price-fact-sheets/ausgrid/solar-2/2<br />
<br />
My bills would go up around 30% if I took this offer. What a rip off. TOU Peak, Shoulder, Off Peak, CL1, supply charges are all higher than what Red energy currently offer (best offer so far for me has been Energy Australia)<br />
<br />
This is a great example of you don't do the sums you'll be worse off.<br />
<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-83054016813786409922017-11-21T12:00:00.000+11:002017-12-15T14:29:42.057+11:00Pixel 2 XL - Boot loop issueMy wife's brand new Pixel 2 XL (2 weeks old) decided it would be really fun to get itself stuck in a boot loop. Wife looked down at phone to see it rebooting and thought that was odd. left it alone for an hour while stayed stuck on the 'G' boot screen with a scrolling progress bar.<br />
<br />
About an hour later I got to look at it and talk to google support. they just advised to get into the recovery screen and try a 'shutdown'. This didn't fix the issue. Google then offered to replace the device saying there was a hardware issue.<br />
<br />
I ended up resolving the issue before having to replace the phone. I had to wipe all the user data and do a factory reset from the recovery bootloader and this allowed the phone to boot correctly.<br />
<br />
Total damage:<br />
- Lost some photos and videos from that day<br />
- Had to reload EVERYTHING again.<br />
- Major pain in the ass.<br />
- Confidence has been lost in this google product. Will this issue happen again?<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-33058401596588795602017-11-02T14:36:00.002+11:002017-11-02T14:36:36.403+11:00SQL Reporting Services (SSRS) prompting for credentials when using a service accountI found what might be a bug in SSRS when using a service account and a custom installation folder. I found that when loading report builder is would prompt for credentials trying to connect to the web service URL. doesn't matter what you put in, it wouldn't let me through.<br />
<br />
Looking at the security logs would show that the authentication was successful but then looking at the application logs I could see an issue with ASP.NET 4.0.30319.0 when trying to read the 'ReportService2010.asmx' file in the SSRS installation folder.<br />
<br />
Turns out the service account was missing rights to 'read' files in the SSRS install directory. It couldn't read the folder or the files within the folder. <br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-87877926262914414182017-10-30T10:22:00.001+11:002017-10-30T10:22:35.894+11:00Right to repair: Should we tolerate hard-to-fix devices for better phones? | AndroidAuthority<a href="https://www.androidauthority.com/device-repairability-807585/">Right to repair: Should we tolerate hard-to-fix devices for better phones? | AndroidAuthority</a>: "<br /><br />
<br /><br />
But what do you do when the manufacturer refuses to acknowledge the issue? 6 of the 7 Nexus 6P's I've come across have failed batteries within a year or two of purchase. yet the manufacturer will continually tell me it's a software issue, not a battery issue.<br /><br />
<br /><br />
BTW of the 7 Nexus 6P devices I've seen 4 had a replacement battery fitted that addressed the issue 2 were returned for a refund and 1 is still working (although it had not been used for at least 6 months in between the purchase and recent use)<br /><br />
<br /><br />
<a href="https://chrome.google.com/webstore/detail/pengoopmcjnbflcjbmoeodbmoflcgjlk" style="font-size: 13px;">'via Blog this'</a> If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-64015874758031005472017-10-16T07:50:00.001+11:002017-10-16T07:50:17.176+11:00Nexus 6P battery issueI had two active Nexus 6P's that were used daily and then over a course of about two weeks the batteries started dying and the phone would turn off at 70% and then wouldn't turn back on until a charger was plugged in. a quick google search for the issue showed I wasn't the only one.<br />
<br />
I returned both phones for service only to be told that the phones are fine and that it's a software issue, not a battery issue. I was told the next update would fix the issue. I hardly see how the next SECURITY update is going to address a physical battery defect. Especially since this phone was at the end of it's supported update cycle from google.<br />
<br />
I ended up using my consumer guarantee to get full refunds because the batteries only lasted a year and bit.<br />
<br />
The funny things were this had been the best phone I'd ever used. They were perfect for my use and just worked and worked until the battery issue.<br />
<br />
I'd put this down to a case of a great product with crap company service.<br />
<br />
Now I'm on to the search for a new android phone<br />
<br />
RIP Nexus 6P where you end up. (probably resold after someone manually changes the battery)<br />
<br />
This is also a perfect case for why we should have user changeable batteries<br />
<br />
If you find this article useful please leave me a comment.<br />
<br />
<br />Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-79227371238783730552017-09-30T10:17:00.000+10:002017-10-03T11:20:52.573+11:00Going back in time in AndroidSo my Nexus 6P crapped out with the same fault all other nexus 6P's have been having (battery dead). This means I had to borrow a loaner phone from someone to stay connected over the weekend. I've now switched to a Samsung Note 1<br />
<br />
Things I miss or that have improved since the Note 1:<br />
- Fast 4G.<br />
- A notification light<br />
- Camera night photos<br />
- The speed of the phone (it takes 2 minutes to load Google Maps)<br />
- Being able to say OK Google, do my bidding.<br />
- Being able to load several apps at a time without the phone slowing to a crawl.<br />
- Newer OS<br />
- NFC<br />
- USB C<br />
- Fingerprint reader<br />
<br />
After 3 days with the Samsung Galaxy Note 1, I am ready to microwave the damn thing.<br />
<br />
3G is very slow and the phone was even slower.<br />
<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-33686371510510249202017-09-15T13:40:00.001+10:002017-09-15T13:40:34.900+10:00Could we land a Raspberry PI on the moon? There you go. Don't just launch it into space hit the big cheese the sky. Land a fricken Raspberry PI on the moon.<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-26106818585629745872017-09-06T14:20:00.000+10:002017-09-28T18:01:57.577+10:00The setup time myth of Camper Trailers "It only takes around 40 minutes from start to finish" is what I was quoted when I asked before buying my first soft floor camper. In reality, it can take from 1-2 hours from arrival to comfort.<br />
<br />
I would imagine the setup process for a Jayco Camper would be different. If you do have a Jayco camper please detail the setup process I would like to compare the two as I am looking to upgrade to something faster<br />
<br />
This is how I imagine the speeds of setup would go if placed in order from slowest to fastest setup<br />
<br />
- Softfloor Tent<br />
- Hardfloor Camper<br />
- Jayco Style Camper<br />
- Regular Tent (for long stay)<br />
- PopTop caravan<br />
- Regular Caravan<br />
- Trailer home.<br />
<br />
Let's go through the actual process for a typical setup. Arriving at 4 PM summer (night fall at 7-8PM)<br />
<br />
<br />
Stage 1 Arrival:<br />
<br />
- Arrive at the site, get out of the car and stretch after being in the car for hours. Wife is assigned to manage the 3 kids while I plan out the site configuration.<br />
- Unpack bikes and scooters to occupy the kids<br />
- Survey the site to find where to setup camper.<br />
- Reverse camper into position with assistance.<br />
- Jockey wheel down and disconnect trailer.<br />
- Shuffle trailer into final position, then apply the handbrake.<br />
- Rear stabilizers down and locked in<br />
- ensure trailer is level.<br />
<br />
Stage 2 Unpacking:<br />
- Unzip tent cover from the camper.<br />
- Drag the Tent Poles, Tent pegs and guy ropes, Side and front Annex canvas, Annex floor, fly cover and ladder off the top of the trailer. place items in a logical area for use later<br />
- Layout tent poles logically (Inside poles and Annex poles and outside poles)<br />
- Get hammer out<br />
<br />
Stage 3 Setup Main Tent: (After this part, you should be sweating)<br />
- Start pulling the tent off the trailer and climb inside and start setting up poles and spreader bars.<br />
- Peg down the tent<br />
- Pull Annex cover down off the roof (we leave it attached to save time)<br />
<br />
Stage 4 Setup Annex Roof:<br />
- Start finding the support pole locations and install<br />
- Find vertical support poles and spreader bars (with the flat ends) and start constructing the annexe<br />
- Install spreader bars across the annexe<br />
<br />
Stage 5 Annex Floor and walls:<br />
- Drag Annex floor into place<br />
- Connect Velcro walls.<br />
<br />
Stage 6 Peg down tent and annexe<br />
<br />
Stage 6 Upack kids sleeping area:<br />
- Unpack and setup kids beds.<br />
- Unpack sleeping bags and place on bed along with the pillows<br />
<br />
Stage 7 Adult bed:<br />
- Unpack sheets and sleeping bags and pillows. Make Bed<br />
<br />
Stage 8 Lighting:<br />
- Turn battery ON<br />
- Unpack LED Lights and wire up the camper.<br />
<br />
Stage 9 Dinner & Chairs and Fridge:<br />
- Unpack BBQ and GAS and setup for dinner.<br />
- Unpack Chairs and Fridge.<br />
- Unpack food and dinner plates cutlery etc.<br />
- Cook and eat<br />
<br />
Finally, relax until you need to pack up.<br />
<br />
There are a few tweaks and tips to make this setup process faster.<br />
<br />
- Sort your Poles into 3 bags, Inside Outside and Other. Label the bags with texta<br />
- Sort the other poles away from tent (PVC pipe holder or in the tray)<br />
- Get some additional help to set up. The division of labor always helps.<br />
- Not going to use the canvas walls for the annexe? get a tub and store them inside the tray.<br />
<br />
<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-41273167695794276742017-08-10T15:01:00.001+10:002017-08-14T15:15:43.589+10:00Electricity plans are just like Mobile phone plans from the early 2000's when data came alongHere you go, for the next 3 months use as much electricity as you want and then we'll send you the bill (and only give you 2 weeks to pay it). What if I want to see how much electricity I'm consuming per day? You can't do that.<br />
<br />
Seems a little unfair to me.<br />
<br />
I can look up my mobile data plan at any time and see how much data I have left. Why can't we do the same with our electricity plans?<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0tag:blogger.com,1999:blog-4140641.post-27139977252076195792017-08-10T13:42:00.002+10:002017-08-10T13:42:30.727+10:00How to calculate percent increaseIncrease = New Number - Original Number<br />
<br />
% Increase = Increase / Original number * 100<br />
<br />
For example;<br />
<br />
So if your train journey takes 26 minutes and a slower train takes 42 minutes<br />
<br />
Increase = 42-26<br />
Increase = 16 / 26*100<br />
Increase = 61%<br />
<br />
If you find this article useful please leave me a comment.Joejoeinchttp://www.blogger.com/profile/01067422259699391738noreply@blogger.com0