jQuery Ajax helper method

//Helper method to call page methods with AJAX function PageMethod(fn, paramArray, successFn, errorFn) { var pagePath = window.location.pathname; //Create list of parameters in the form: //{“paramName1″:”paramValue1″,”paramName2″:”paramValue2″} var paramList = ”; if (paramArray.length > 0) { for (var i = 0; i < paramArray.length; i += 2) { if (paramList.length > 0) paramList += ‘,’; paramList […]

Find largest tables in db

from : http://stackoverflow.com/questions/2094436/how-to-find-largest-objects-in-a-sql-server-database use SELECT t.NAME AS TableName, i.name as indexName, sum(p.rows) as RowCounts, sum(a.total_pages) as TotalPages, sum(a.used_pages) as UsedPages, sum(a.data_pages) as DataPages, (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB, (sum(a.used_pages) * 8) / 1024 as UsedSpaceMB, (sum(a.data_pages) * 8) / 1024 as DataSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id […]

SQL server express w/ profiler

http://stackoverflow.com/a/13612052/410622   You can activate the SQL Server Express Error Log in a way that it monitors all statements runned agaist every database. To do so you must run the following on an elevated command prompt (that is, a command prompt runned as administrator): net stop MSSQL$SQLEXPRESS net start MSSQL$SQLEXPRESS /T4032 Now, using the SQL […]

Start IIS Express from the command line

http://www.freqly.com/faq/net/question/520/how-can-i-run-iis-express-from-the-command-line http://www.iis.net/learn/extensions/using-iis-express/running-iis-express-from-the-command-line   eg. – IISEXPRESS /path:C:\Workspace\OffersTracking\OffersTracking\src\BugNET_WAP /port:59847