Speed up query or Stored procedure in sql server 2005 or 2008

Speed up query or Stored procedure in sql server 2005 or 2008

Way to optimize your query or stored procedure:

1. We can use Sql perfomance tuner under Tool's in menu bar. we just need to provide script file or database object like sp to get suggestion from sql server 2005.
Mostly it will ask to add index and statistics into tables.

2. We can also use Estimated Plan to check if our query missing any index or statistics on a table.


Happy Living...
Happy Coding...
Happy Concepts...

    

Open Modal Popup in different Browsers

In Windows Internet Explorer supports a direct method to open a modal pop using

window.showModalDialog("popupModel.html") ;

method.

To get more information on window.showModalDialog(xxxxxxxxxxx)  visit:
 http://fromdotnet.blogspot.com/2011/09/call-parent-window-methods-form-dialog.html

We have one advantage with showModalDialog that we can pass arguments to Modal popup.

But other Browser doesnt support it and they have there own way to implement it by passing an additonal property model=yes with Window.Open() method.

window.open('popupModal.html','name',
'height=255,width=250,toolbar=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no ,modal=yes');

Example:
function popupModalWin() {
if (window.showModalDialog) {
var
window.showModalDialog("popupModelWindow.htm",,"popupModelWindowName",
"dialogWidth:255px;dialogHeight:250px");
}
else {
window.open(popupModelWindow.htm','popupModelWindowName',
'height=255,width=250,toolbar=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no ,modal=yes');
}
}



Happy Living...
Happy Coding...
Happy Concepts....

"HTTP Error 404 - File or Directory not found" error with windows server 2003 message when you request dynamic content with IIS 5.0 and IIS 6.0

"HTTP Error 404 - File or Directory not found" error message when you request dynamic content with IIS 6.0

Changes required in webExtension for to allow Activeserverpage and other page based on our application for example for asp.net its ActiveServerPage. Just allow to access these pages through server.
And magically its done :).
Use Below link for more information:

http://support.microsoft.com/kb/315122

By default only static content HTML is enabled in windows server 2003 family when IIS is installed on any version of the its family.

So enable web server extensions.

Happy Living....
Happy Coding.....
Happy Concepts .....