Aleksandar's computer workshop

Let's see what Aleksandar was fixing today.
My findings, tips & tricks related to computers, internet, programming and other stuff I was working with.

Optimizing SQL Server Query Performance

When optimizing your database server, you need to tune the performance of individual queries. This is as important as—perhaps even more important than—tuning other aspects of your server installation, that affect performance, such as hardware and software configurations.

Even if your database server runs on the most powerful hardware available, its performance can be negatively affected by a handful of misbehaving queries. In fact, even one bad query, sometimes called a "runaway query," can cause serious performance issues for your database.

Conversely, the overall performance of your database can be greatly improved by tuning a set of most expensive or most often executed queries. In this article, I will look at some of the techniques you can employ to identify and tune the most expensive and worst performing queries on your server.

* Analyzing execution plans
* Optimizing queries
* Estimated Cost of Execution
* Analyzing an Execution Plan
* The Covering Index
* Indexed Views
* Identifying Which Queries to Tune
* Customer Order Query Exercise

http://www.microsoft.com/technet/technetmag/issues/2007/11/SQLQuery/default.aspx

SMTP tar pit feature for Microsoft Windows Server 2003

Tarpitting is the practice of deliberately inserting a delay into certain SMTP communications that are associated with spam or with other unwanted traffic. To be effective, these kinds of communications typically rely on generating a high volume of traffic. By slowing an SMTP conversation, you can dramatically reduce the rate at which automated spam can be sent or at which a dictionary attack can be conducted. Legitimate traffic may also be slowed by tar pitting.

The tar pit feature is available in Microsoft Windows Server 2003 and in several third-party SMTP servers. The tar pit feature in Windows Server 2003 works by slowing all responses that contain SMTP protocol 5.x.x error codes. An administrator can configure the delay that is introduced by the tar pit feature.

Tar pitting affects only anonymous SMTP connections. Authenticated sessions are exempt. Therefore, if you regularly exchange lots of SMTP mail with another organization,
and you find that tar pitting is affecting that traffic, you can bypass tar pitting for that organization by authenticating SMTP communications.

More details you can find here:
http://support.microsoft.com/kb/842851

cdonts on Windows 2003

Server object error 'ASP 0177 : 800401f3'

Server.CreateObject("CDONTS.NewMail") Server.CreateObject failed windows 2003

I am working on IIS 6...and I cannot even find the dll smtpsvg.dll when I run regsvr32...
My createobject fails everytime :(.
I first started dickering around with permissions, then I realized the dll isn't even on the server. What mind-bogglingly basic error am I making here?Set Msg = server.createobject("CDONTS.Newmail")Thanks for any guidance! :)

you're using Windows 2003 Server you need to use Server.CreateObject("CDO.Message")")CDo runs on Windows 2003, CDONTs does not.Here is the code I use:  I wouldn't screw around with the configuration as mentioned...alwasy seems to mess it up.  All default should work fine with your host:Code below works, I use it: uses port 25, no configuration. Had problem with configuration on local machine.strTo = "toemail@yourdomain.com"    'Make sure the From field has no spaces.strFrom = "fromemail@yourdomain.com"strSubject = "Your Subject"strBody = "The content of email"' Create an instance of the NewMail object.Set objCDOMail = Server.CreateObject("CDO.Message")' Set the properties of the objectobjCDOMail.Sender = StrFromobjCDOMail.To = strToobjCDOMail.Subject = strSubjectobjCDOMail.TextBody = strBody' Some of the more useful ones I've included samples of here:'objCDOMail.Cc = "mailto:sschofield@aspfree.com;steve@aspfree.com"   Notice this sending to more than one person!'objCDOMail.Bcc = "sschofield@aspfree.com;steve@aspfree.com"'objCDOMail.Importance = 1'objCDOMail.AttachFile "c:\path\filename.txt", "filename.txt"' Send the message!objCDOMail.Send' Set the object to nothing because it immediately becomes' invalid after calling the Send method + it clears it out of the Server's Memory.Set objCDOMail = Nothing


: I am getting the error "Server.CreateObject Failed": on the following line of code on a Windows Server 2003 box::: 
Set oCDONTS = Server.CreateObject("CDONTS.NewMail"):: Is CDONTS no longer included with Server 2003?: Any advice on how to address this problem would: be most welcome.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~CDONTS (CDO for NT Server) is deprecated. It was included with Windows 2000for backwards compatibility.Options:a) Use CDOSYS instead (CDO for Windows 2000). Joshua posted a link, or youcan use:http://msdn.microsoft.com/library/?url=/library/en-us/exchanchor/htms/msexchsvr_cdowin2000.asp?frame=trueto get to the home page/b) Get a copy of CDONTS off an old machine and register it on your WIndows2003 Server. I would only recommend doing this if you have a lot of oldercode already that uses CDONTS and you have moved the site over to a Windows2003 Server. Since CDONTS is not supported on Windows 2003 Server you don'tknow how long it'll keep working.