Search This Blog
Sunday, October 23, 2011
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.
•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'
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'
Subscribe to:
Posts (Atom)