Search This Blog

Sunday, October 23, 2011

http://www.ajaxload.info/#preview

http://www.ajaxload.info/#preview

why does an AutocompleteExtender get refreshed at given interval?

AutocompleteExtender get refreshed at given interval when its EnableCaching is set to false.Set it to true to stop it.

Wednesday, October 5, 2011

how to use Sql Server Profiler

Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring T-SQL Statements of Database Engine. We can save and reuse the state at a later point of time.

•We can do the following using SQL Server Profiler
    ◦Create a trace
    ◦Watch the trace results as the trace runs
    ◦Store the trace results in a table
    ◦Start, stop, pause, and modify the trace results as necessary
    ◦Replay the trace results
•Use SQL Server Profiler to monitor only the events in which you are interested

How To Start SQL Profiler
>In Sql Server 2000
    Start | Run | profiler | OK
>In Sql Server 2005
    Start | All Programs | Microsoft SQL Server 2005 | Performance Tools | SQL Server Profiler.

Saturday, October 1, 2011

Integer Displaying as Hexadecimal When Debugging in Visual Studio.

If you Integers are displaying as hexadecimals (funny letters) then you've probably switched on the hexadecimal display option in your watch window.

You need to debug a project, open up the watch window: Debug > Windows > Watch 1 then right click on an entry and untick 'hexidecimal display'