Home / Technology

Disable code analysis at solution level in Microsoft Visual Studio 2012

8.03.2016   gyanendra   No comments

You can use a little trick to disable the static code analysis for a whole Visual Studio instance as described here: Open a Developer Command Prompt for VS2012 type set

Delete all rows from all tables in a SQL Server database

I have seen most of the time Developer asked me this question .. Following below is solutio   Set nocount on Exec sp_MSForEachTable ‘Alter Table ? NoCheck Constraint All’ Exec

Very Easy Validation jquery ever used

jQuery Form Validator is a feature rich jQuery plugin that makes it easy to validate user input while keeping your HTML markup clean from javascript code. Even though this plugin

Count your Inodes/Files on your Cpanel Using PHP code

Are you struggling or looking for a inodes blasting issue on your server , I feel the same, After failed on many point. An inode is a data structure used

Top Most Responsive HTML/HTML5 Framework

BootStrap     Bootstrap is one of the most popular modern front-end web development framework. It’s full feature-packed with many component and js liabraries,validation and other things which you may

Hosting Of Website with the FileZilla

Hosting of Website with the FileZilla.. Introduction:- This article covers all the phase of  web Hosting of a website. Description: I have done a simple project in Asp.Net MVC 4.Here

Delete Duplicate row in SQL Server

Following below query help you to delete duplicate row in sql sever DELETE A FROM table1 A where %%physloc%% > ( SELECT min(%%physloc%%) FROM table1 B WHERE A.ID= B.ID) In

Improve backend / Admin performance of Umbraco

27.06.2014   gyanendra   Umbraco   No comments

How do you check what version of SQL Server for a database using TSQL?


Get All Databases Size in SQL Server

SELECT, ROUND(SUM(mf.size) * 8 / 1024, 0) Size_MBs FROM sys.master_files mf INNER JOIN sys.databases d ON d.database_id = mf.database_id WHERE d.database_id > 4 — Skip system databases GROUP BY