Professional way to clear cache and buffer of SQL Server Stored Procedure for performance testing without restarting the server or recreating the procedure.
Clear Cache and Buffer of Stored Procedure in SQL Server
Author: Beaulin Twinkle
SP_WHO and SP_WHO2
SP_WHO and SP_WHO2 – Brief description about Microsoft system stored procedures SP_WHO and SP_WHO2. SP_WHO vs SP_WHO2 which one to use when.
What Is Oracle Database?
Response.Write vs Batch Inline Script: ASP.NET Performance Tips
Comparison between Response.Write and Batch Inline Script in ASP.NET and MVC, Performance tips on usage of Response.Write and Batch Inline Script.
NS (Network Simulator: NS-1, NS-2, NS-3)
Useful urls for NS (Network Simulator: NS-1, NS-2, NS-3)
Fix For: Remote Desktop Connection Error
Fixing the Remote Desktop Connection Error, when trying to remote desktop from a windows 7 pc to another pc or server. Solution for RDP connection error.
List of android apps in my Nexus 4
What is DBMS? What is RDBMS? DBMS vs RDBMS
What is DBMS? What is RDBMS? This article will give you a basic idea about SQL DBMS & RDBMS as wells as the difference between DBMS and RDBMS in tabular form.
What is SQL Server? How to get SQL Server?
Do you want to know about SQL Server and how to get it. Here is a brief article about SQL server. This article will provide you a basic understanding about SQL Server.
ASP.NET Caching with SqlCacheDependency
ASP.NET caching technology has various technique for specific caching requirements. SqlCacheDependency class is one among them.
Retrieve Files Deleted From Recycle Bin! Easy Way
Is it possible to retrieve files deleted from recycle bin? Yes, we will be able to retrieve the files deleted from recycle bin.
Solution for Query String Too Long Error
Query String Too Long – You may get a “414 – query string too long” error in internet explorer. Here is a solution for the error.
Using isnull in where clause is expensive in SQL Server
Using isnull in where clause is expensive in SQL Server. How to avoid useing isnull? Simple way to use case instead of isnull in where clause.