tag:blogger.com,1999:blog-67391075097083824462024-03-05T11:10:27.384+02:00ExtremeDev: Development SolutionsJavascript, JQuery, CSS, HTML, ASP.NET, XML, XSLT, C#, SQL and others: <b>Tips, Code Snippets & How To's</b>. Plus Consulting Services in Programming. Hacks & Solutions.Unknownnoreply@blogger.comBlogger56125tag:blogger.com,1999:blog-6739107509708382446.post-71721611361856476472020-03-25T17:53:00.002+02:002020-03-25T17:53:21.294+02:00Coronavirus or Covid-19 affects USA and EuropeBritish Prime Minister Boris Johnson on Monday decided to limit the displacement of the UK population for at least three weeks to stop the spread of the new coronavirus pandemic, which has killed more than 300 people in the country.<br />
<br />
In France, the Prime Minister decided to limit exits to a maximum of 1 km from home, for a maximum of one hour.<br />
<br />
The IMF is preparing to mobilize its full lending capacity of $ 1 billion.<br />
<br />
The head of the World Health Organization, Tedros Adhanom Ghebreyesus, says that the Covid-19 pandemic is "accelerating", as more than 350,000 cases worldwide have been registered so far. "It was necessary to:<br />
🔘 67 days from the first reported case to reach 100,000 cases<br />
🔘 11 days for the next 100,000 cases<br />
🔘 4 days for another 100,000 cases ”, Ghebreyesus told a press conference.<div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6739107509708382446.post-29418190482256729792017-06-20T10:30:00.000+03:002017-06-20T10:30:12.409+03:00Skype is not working as from 20 June 2017It looks like microsoft did it again - another update and skype is not working properly again. What is with this guys? aren't they testing their software? Some simple unit tests would avoid such things once and forever.<br />
BTW - updating windows - does not help as well, it looks like we will have to stay without skype a few days.<br />
<br />
Microsoft, since you bought skype - you made it worse.<br />
<br />
I could help with reorganizing the work in Skype department :)<div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6739107509708382446.post-49896709461058103392014-11-19T16:52:00.000+02:002014-11-19T16:52:57.291+02:00X-Frame-Options & SAMEORIGIN<h3>
Refused to display 'http://extremedev.example.com' in a frame because it is set 'X-Frame-Options' to 'SAMEORIGIN'</h3>
<div>
This is an error that can appear when you want to display a site through an iframe of another site. It will not allow for the site within the iframe to be displayed.</div>
<div>
<br></div>
<div>
<b>So what to do in this case?</b></div>
<div>
<b><br></b></div>
<div>
There are several articles on the internet that are suggesting that you need to add some headers that will allow the display of the site through the iframe from different domains. For example: <a href="https://developer.mozilla.org/en-US/docs/Web/HTTP/X-Frame-Options" rel="nofollow">https://developer.mozilla.org/en-US/docs/Web/HTTP/X-Frame-Options</a></div>
<div>
<br>
</div><a href="http://extremedev.blogspot.com/2014/11/x-frame-options-sameorigin.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com5tag:blogger.com,1999:blog-6739107509708382446.post-65955136293833179872014-10-22T13:44:00.000+03:002014-12-23T08:13:18.578+02:00Generic Method for wrapping around any codeHey all,,<br>
We often need to run something before some code logic and after it was executed.<br>
<br>
As a simple example we can take the try-catch block, everybody has this in their application and is using it more then two times for sure.<br>
<br>
What we can do in this case is to write a generic method that will allow to run our code inside a try-catch statement. This method will look like this:<br>
<br>
<br>
<div class="csharpcode">
Code:<br>
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; color: black; overflow-x: auto; overflow-y: hidden; padding: 0px; text-align: left; word-wrap: normal;"><span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">void</span> TryDo(<span class="type">Action</span> action, <span class="type">ILogger</span> logger, <span class="keyword">string</span> messageDescription)
{
<span class="keyword">try</span>
{
action();
}
<span class="keyword">catch</span> (<span class="type">Exception</span>)
{
<span class="comment">// Do some logging stuff here</span>
}
}<!--[if IE]>
<![endif]--></pre>
</div>
<br>
<a href="http://extremedev.blogspot.com/2014/10/generic-method-for-running-wrapping.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-6739107509708382446.post-51339975155396940542014-01-05T23:10:00.001+02:002014-01-05T23:10:41.481+02:00IE 11 first impressionsHi all,<br />
<br />
Several weeks ago I tried saw an update in my windows 7, it was Internet Explorer 11. I said, great, maybe this version of IE will be a good one, but unfortunately it wasn't it.<br />
<br />
The first problems that I have encountered, even before opening IE 11 was when I tried to install it. I selected it to be installed as an update, it required other updates also, so I waited for it to download, and finally Windows says: "You need to restart windows for changes to apply". WHAAT?<br />
<br />
Why when installing a browser I need to restart windows? Microsoft -> that is not good, not good at all.<br />
<br />
But wait, that's not all, after I agreed with the restart, it was restarting around 15 times, with a message failure to install updates. Then finally after one hour, yes this is truth ONE hour, my desktop appeared, however unfortunately I could not start any application, I couldn't even go to control panel through the start menu.<br />
<br />
In order to make my computer work again, I had to go to control panel through explorer, and uninstall, manually all the updates installed on that day - that was a very very long process. And guess what windows says to me after each update uninstall: "You need to restart....", Ough noooo, again???<br />
After doing that my windows was ok again, but without IE 11, I tried above procedure several times, because I wanted to see IE 11 but it looks like it was not possible to do that on that computer, so I tried on another.<br />
<br />
First impression about IE 11 was that there is not big difference, but then I opened Developers Tools, I was impressed, but then after starting to use it I was getting disappointed, more and more.<br />
<br />
It was really really buggy.<br />
<br />
The thing is that I am a developer that is working with sites that are updating HTML content a lot of times per second, which as you understand requires good rendering capabilities from browser, but also requires a good Developer Tools that can handle these changes in HTML source.<br />
<br />
Well IE 11 Developer Tools is not good enough to handle this, so it crashed, and even after I closed Dev Tools and reopened it did not start again, so I had to close and reopen the entire browser again.<br />
<br />
For me it was impossible to work with this browser + it was sometimes failing even on sites that are not updating the content so many times.<br />
<br />
However there is something that I like and that is that Microsoft has finally decided to include automatic updates in this browser, which in my opinion they had to do a long time ago.<br />
<br />
So guys, how do you like the new IE 11?<br />
<br />
Regards,<br />
Roman<div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com4tag:blogger.com,1999:blog-6739107509708382446.post-81869415953573603532013-05-17T15:19:00.001+03:002013-05-17T15:20:17.437+03:00IE9 and console.log problemsHello everyone,<br>
<br>
I have found that Internet Explorer 9 has some problems when you want to use console.log in your sites.<br>
If you have for example:<br>
<br>
<div class="csharpcode">
Code:<br>
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; color: black; overflow-x: auto; overflow-y: hidden; padding: 0px; text-align: left; word-wrap: normal;">console.log(<span class="string">'www.extremedev.blogspot.com'</span>);</pre>
</div>
<br>
then in IE9 without the Developer Tools open it will throw an exception (but you will not be able to see it because the Developer tools is not opened).<br>
This happens because IE does not find the console object.<br>
<br>
There is a small fix for this - you have to<br>
<a href="http://extremedev.blogspot.com/2013/05/ie9-and-consolelog-problems.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6739107509708382446.post-43321184205936466752012-12-06T19:32:00.000+02:002012-12-06T19:32:15.853+02:00Visual Studio 2012Hello,<br>
<br>
Well, as everybody know Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft.<br>
<br>
I've started from using the Visual Studio 2003, this was many years ago and at that time it seemed amazing. But the technologies are developing very fast and we have to keep the pace together with it, by at least having the latest IDE.<br>
<br>
At a first look at any new IDE it is hard to use it, and as I noticed - especially for Senior Developers with more than 5 years of experience. They seem very hard to be convince to use a new technology, application and IDE. <br>
<a href="http://extremedev.blogspot.com/2012/12/visual-studio-2012.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-6739107509708382446.post-28471880961735173882012-11-13T19:21:00.003+02:002012-11-13T19:21:55.150+02:00HTML5: audio tagHello everybody,<br>
<br>
We will discuss about the audio tag in this post.<br>
This tag is available in HTML 5.<br>
You can play an audio file right in browser, and you can do that without using flash.<br>
<br>
A note that I did not find anywhere is that not all browsers support mp3 files and not all browsers support wav files. This is why you need to have both mp3 and wav files.<br>
<br>
So a cross browser solution - that will work on IE, Chrome, Firefox and Safari will be something like this:<br>
<br>
<a href="http://extremedev.blogspot.com/2012/11/html5-audio-tag.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-6739107509708382446.post-71824564340468747992012-11-13T18:48:00.000+02:002012-11-13T18:48:25.634+02:00Orchard: Change Page TitleHello,<br />
<br />
Here is how make so that you have a custom title for a custom page (View).<br />
<br />
Open the View (.cshtml) file that you want with a custom title and add this code at the top of the file:<br />
<br />
<div class="csharpcode">
Code:<br />
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; color: black; overflow-x: auto; overflow-y: hidden; padding: 0px; text-align: left; word-wrap: normal;">@{
<span class="type">Layout</span>.Title = T(<span class="string">"Custom Title | EXTREMEDEV"</span>).<span class="type">Text</span>;
}<!--[if IE]>
<![endif]--></pre>
</div>
<div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-6739107509708382446.post-8638778024225239722012-10-29T21:51:00.003+02:002012-10-29T21:51:57.115+02:00Orchard: Change faviconHello,<br />
<br />
As you all probably know Orchard is a free, open source, community-focused project aimed at delivering applications and reusable components on the ASP.NET MVC platform.<br />
<br />
So, now about the favicon, to change the default Orchard's favicon you need either to install the Favicon module, which I think is too complicated for this case, or to override the location of the favicon by overriding the default Document.cshtml template - just copy/paste to your theme.<br />
<br />
You will find something like below in Document.cshtml:<br />
<br />
<div class="csharpcode">
<div class="csharpcode">
Code:<br />
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; color: black; overflow-x: auto; overflow-y: hidden; padding: 0px; text-align: left; word-wrap: normal;">RegisterLink(<span class="keyword">new</span> <span class="type">LinkEntry</span> {<span class="type">Type</span> = <span class="string">"image/x-icon"</span>, Rel = <span class="string">"shortcut icon"</span>, Href = <span class="type">Url</span>.Content(<span class="string">"~/.../FavIcon.ico"</span>)});<!--[if IE]>
<![endif]--></pre>
</div>
</div>
<br />
Change the path of the href attribute to where your favicon is, and here it is you have your own favicon.<br />
<br />
Happy coding!!!<div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6739107509708382446.post-13991031417634356812012-05-21T23:18:00.001+03:002012-05-21T23:19:23.305+03:00SSIS on SQL Server 2008 R2Hi all,<br>
<br>
These days I had a chance to take a look at SQL Server Integration Service 2008 R2 (SSIS) and do you know what? it is a really good thing when you need to Extract, Transform and Load (ETL) data from a DataBase to another.<br>
<br>
However, unfortunately it is very buggy and is still like something that is not fully implemented, like not all the functionality was implemented till the end.<br>
What I've found during several days of investigations on SSIS is:<br>
1) it is very hard to maintain;<br>
<br>
<a href="http://extremedev.blogspot.com/2012/05/ssis-on-sql-server-2008-r2.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-6739107509708382446.post-39633228659754860022012-03-07T14:59:00.000+02:002012-03-07T14:59:03.139+02:00Remove Skype haha foto virus / wormHello,<br />
<br />
Remember my post about <a href="http://extremedev.blogspot.com/2012/02/skype-haha-foto-httpgooglfacebookcom.html" target="_blank">Skype haha foto http://goo.gl/...?Facebook.com-IMG....JPG</a><br />
<br />
After several days, I have found on the internet how to <b>remove </b>this worm. Read below:<br />
<br />
<b>Try locate in processlist file called mdm.exe, and kill the process,
Then download any startup program management utilities - for example Nirsoft Startup.cpl and look for "Windows Firevall engine" that references the "c:/windows/mdm.exe". Delete or disable those in startup and delete the file itself under c:/windows/mdm.exe</b><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6739107509708382446.post-5737925514219728712012-03-07T14:43:00.000+02:002012-03-11T17:13:49.097+02:00YouTube Service sent you a message: Your video has been approvedHello,<br>
<br>
Here is an interesting email that is being sent to many people.<br>
<br>
<hr style="width: 40%;">
<br>
<b>From</b>: YouTube Service <service@youtube.com></service@youtube.com><br>
<b>To</b>: someEmail@someDomain.com<br>
<b>Sent</b>: Wednesday, March 7, 2012 11:56 AM<br>
<b>Subject</b>: YouTube Service sent you a message: Your video has been approved<br>
<br>
<a href="http://extremedev.blogspot.com/2012/03/youtube-service-sent-you-message-your.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com15tag:blogger.com,1999:blog-6739107509708382446.post-53665557637968640182012-02-17T16:13:00.001+02:002012-02-17T16:13:59.721+02:00Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = %ld, Current count = %ldSuch an error has appeared these days to me in SQL using SPROC in another SPROC where these are using transactions:<br>
<br>
<br>
Msg 266, Level 16, State 2, Procedure SPROC_NAME2, Line 0<br>
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2.<br>
<br>
So what is that???<br>
I will explain.<br>
<br>
<a href="http://extremedev.blogspot.com/2012/02/transaction-count-after-execute.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-6739107509708382446.post-89836775063515785692012-02-13T10:43:00.002+02:002012-02-13T15:55:57.165+02:00Carousel with variable item-sizes<span style="font-size: large;"><b>Carousel with variable item-sizes</b></span><br>
<span style="font-size: large;"><b><br></b></span><br>
I have implemented a Javascript / jQuery + CSS Carousel which is auto-scroll-able, but also has the possibility to manually scroll the items.<br>
<br>
The biggest advantage of this carousel is that you can have items of different size and the carousel is not changing its size.<br>
<br>
Here is the how you define the items that will be displayed in the Carousel:<br>
<br>
<div class="csharpcode">
Code:<br>
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; color: black; overflow-x: auto; overflow-y: hidden; padding: 0px; text-align: left; word-wrap: normal;"><li><<span class="type">a</span> href=<span class="string">"#"</span>><<span class="type">img</span> src=<span class="string">"./img/item5.png"</span>></<span class="type">a</span>></li>
<li><<span class="type">a</span> href=<span class="string">"#"</span>><<span class="type">img</span> src=<span class="string">"./img/item3.png"</span>></<span class="type">a</span>></li></pre>
</div>
<br>
To configure the speed of scrolling when auto-scrolling you need to amend this line of code:<br>
<br>
<a href="http://extremedev.blogspot.com/2012/02/carousel-with-variable-item-sizes.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-6739107509708382446.post-44077723210379971022012-02-12T18:18:00.000+02:002012-03-07T22:51:02.154+02:00Skype haha foto http://goo.gl/...?Facebook.com-IMG....JPGMany of my friends have sent me some "photos". Something like: haha foto http://goo.gl/...?Facebook.com-IMG....JPG<br>
<br>
All these messages were sent through skype groups.<br>
This of course is something like virus.<br>
<br>
Because when you click on that link it is being opened in browser and there is no photo in it, however it looks like it is installing something on your computer and from now and on you are also sending group messages through skype :) with the message: haha foto http://goo.gl/...?Facebook.com-IMG....JPG<br>
<br>
I very much believe that it's purpose is not only to send that link, but it should also do something in the background, I still don't know what, maybe some key logging of your credentials to email/skype/facebook and others.<br>
<br>
<a href="http://extremedev.blogspot.com/2012/02/skype-haha-foto-httpgooglfacebookcom.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com8tag:blogger.com,1999:blog-6739107509708382446.post-63596798097730625012012-01-26T22:52:00.000+02:002012-02-03T15:41:15.137+02:00How to check your site speed and performanceHi all,<br>
<br>
In this post I will give a short list of sites and tips that will help you to improve your site's speed and performance.<br>
<br>
First a list of sites:<br>
1) <a href="https://developers.google.com/pagespeed/" target="_blank">Google's Page Speed Online</a>, <span style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 13px; line-height: 21px;">Page Speed Online analyzes the content of a web page, then generates suggestions to make that page faster. Reducing page load times can reduce bounce rates and increase conversion rates; Note: you can also find a Google Chrome Extension for this tool, here on <a href="http://code.google.com/speed/page-speed/" target="_blank">this page</a>.</span><br>
<a href="http://extremedev.blogspot.com/2012/01/how-to-check-your-site-speed-and.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-6739107509708382446.post-14854477958890862492012-01-23T18:09:00.000+02:002012-01-23T18:09:18.359+02:00SQL: Concatinate Rows into a string without using variablesHi All,<br>
<br>
Here is a small SQL script which allows you to concatenate the values from all rows into a single row/value.<br>
<br>
<code style="font-size: 12px;"><span style="color: black;"><br></span><span style="color: blue;">SELECT </span><span style="color: black;">T.value </span><span style="color: grey;">+ </span><span style="color: red;">',' </span><span style="color: blue;">AS </span><span style="color: black;">[text()]</span></code><br>
<code style="font-size: 12px;"><span style="color: blue;">FROM </span><span style="color: black;">myTable T</span></code><br>
<code style="font-size: 12px;"><span style="color: blue;">FOR XML </span><span style="color: black;">PATH </span><span style="color: grey;">(</span><span style="color: red;">''</span><span style="color: grey;">)</span></code><br>
<br>
<a href="http://extremedev.blogspot.com/2012/01/sql-concatinate-rows-into-string.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6739107509708382446.post-66036849987074127302012-01-23T15:49:00.001+02:002012-01-23T16:02:25.288+02:00Override jQuery.val() and jQuery.val(value)Hi all,<br>
<br>
Sometimes there are cases when you need to do something when $.val() and $.val(value) from jQuery is called, but then you still want the default behavior to be kept. Here is an example of how you could do that:<br>
<br>
Code:<br>
<div class="csharpcode">
<pre style="background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; color: black; overflow-x: auto; overflow-y: hidden; padding: 0px; text-align: left; word-wrap: normal;"><span class="type">var</span> originalVal = <span class="keyword">this</span>.originalVal = $.fn.val;
$.fn.val = function(<span class="keyword">value</span>) {
<span class="keyword">if</span> (<span class="keyword">typeof</span> <span class="keyword">value</span> == <span class="string">'undefined'</span>) {
alert(<span class="string">'Getting the value'</span>);
<span class="keyword">return</span> originalVal.call(<span class="keyword">this</span>);
}
<span class="keyword">else</span> {
alert(<span class="string">'Setting the value'</span>);
<span class="keyword">return</span> originalVal.call(<span class="keyword">this</span>, <span class="keyword">value</span>);
}
};
</pre>
</div>
<br>
<br>
I for example have used it for a jQuery widget, I wanted to override the default behavior of the val() function when this is performed on the element for which a widget was used. So what I have done is I have added a custom attribute to the element for which I am using the widget and then in the val() I am checking the presence of that attribute - just like below:<br>
<br>
<a href="http://extremedev.blogspot.com/2012/01/override-jqueryval-and-jqueryvalvalue.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-6739107509708382446.post-21340203491415197932012-01-11T12:35:00.001+02:002012-01-11T12:35:48.765+02:00SQL: Rename Column/Table NameHi All,<br>
<br>
We all sometimes need to rename a column/table from our database, however we do not want to drop all our records from the table where the column is renamed or the name of that table is changed.<br>
<br>
For that there is such a nice SPROC in MS SQL: sp_rename.<br>
<br>
This SPROC can be used to rename any user-created object in current DB.<br>
<br>
<b>However there is also a caution:</b><br>
<br>
<a href="http://extremedev.blogspot.com/2012/01/sql-rename-columntable-name.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6739107509708382446.post-28269719000582449302012-01-10T08:52:00.000+02:002012-01-10T08:59:12.848+02:00What's New in ASP.NET 4.5 and Visual Web Developer 11 Developer Preview<span style="color: #44525e; font-family: 'Segoe UI', Tahoma, Arial, Helvetica, sans-serif; font-size: large; line-height: 1.2em;">What's New in ASP.NET 4.5 and Visual Web Developer 11 Developer Preview</span><br>
<div>
<br></div>
<div>
This document lists features and enhancements that are being introduced in ASP.NET 4.5. It also lists improvements being made for web development in Visual Studio (Visual Web Developer).
<br>
<br>
</div><a href="http://extremedev.blogspot.com/2012/01/whats-new-in-aspnet-45-and-visual-web.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6739107509708382446.post-24274866679026427892011-12-14T12:25:00.001+02:002012-01-05T15:02:48.863+02:00SQL Performance Tips 5Hello,<br>
<br>
Another SQL Performance tip, which will help you to determine the exact execution time of your sql statements. The simplest way of doing that is to save the time before running your statement and then compare that value with current time. Here is a sample SQL statement:<br>
<a href="http://extremedev.blogspot.com/2011/12/sql-performance-tips-5.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6739107509708382446.post-46751250360637512372011-11-25T14:59:00.001+02:002012-02-09T16:53:20.985+02:00ANTS Memory Profiler 7.1 without licenseHi All,<br>
<br>
The trial period of 14 days of your ANTS Memory Profiler has passed.<br>
<br>
You are now searching for a license for ANTS Memory Profiler?<br>
Or are you searching for a crack for ANTS Memory Profiler?<br>
Or are you searching for a keygen for ANTS Memory Profiler?
<br>
<br>
No need to do that anymore because there is an easy way to use it without having a license, crack or keygen (Note: the version that I am using is 7.1).<br>
<br>
So what to do?<br>
<br>
<a href="http://extremedev.blogspot.com/2011/11/ants-memory-profiler-71-without-license.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com12tag:blogger.com,1999:blog-6739107509708382446.post-67556471370640730562011-11-23T16:59:00.000+02:002011-11-24T10:22:32.138+02:00SQL Performance Tips 4Hi All,<br />
<br />
Again me with some more SQL Performance Tips.<br />
<br />
If you have a lot of tables with which you have to join and those tables are big then pay attention to the order of how you join those tables because the order matters.<br />
<br />
Why the order of the tables in joins matters?<br />
<br />
It is because even if the result of your query returns only a few of records, lets say 7 records, it doesn't mean that it will run fast, and it will not run fast because during the first joins your tables can "return" thousands, millions or even more records with which the SQL Server will be working further.<br />
<br />
So the idea is that you have to use the Actual Execution Plan to see what is Estimated Number of Rows with which the SQL Server will be working with.<br />
<br />
Try to filter the data using the joins, so that less data remains to be processed, and less time it takes to the SQL Server to return the result to you.<br />
<br />
Good luck,<br />
Roman<div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6739107509708382446.post-70201522219509895422011-11-18T06:00:00.000+02:002011-11-24T10:20:56.641+02:00SQL Performance Tips 3Hi All,<br>
<br>
Me again with another SQL Performance tip.<br>
<br>
Another way to optimize a query is using the Actual Execution Plan.<br>
<br>
Well, first of all by using it you will see what indexes are missing, what table or join is causing the performance issue, which join is returning a lot of rows and many more.<br>
<br>
It worth learning how to use the Actual Execution Plan.<br>
<br>
Now about indexes, you must keep in mind that not all indexes that are suggested to be created by Actual Execution Plan are good to be created, and this is for several reasons:<br>
<br>
<a href="http://extremedev.blogspot.com/2011/11/sql-performance-tips-3.html#more">........ »</a><div class="blogger-post-footer">www.extremedev.blogspot.com</div>Unknownnoreply@blogger.com0