Factory pattern and abstract factory both can be used in the scenarios where you need to have dynamic object creation. Every scenario where you can use factory pattern, you can use abstract factory instead and vice versa. The difference between these 2 patterns are in approach, not in scenarios. Some like to have all the object creation methods separated in another class, they use abstract factory. Some things, I dont want to create another class, so they just create the objection creation methods in the same class. But to me, if you need to ha... [More]

How to Copy SQL Server Database Data Files (.mdf and .ldf) [More]

USE [GSK_DATA_DB] GO /****** Object: StoredProcedure [dbo].[SP_Impersonate] Script Date: 06/28/2010 15:45:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[SP_Impersonate] with execute as 'bd\islamaw1' as begin exec [SP_REIM_REPORT_DATA] '', 'LC', '2010-01', 'PTW', 'All' end

function InfoByDate(sDate, eDate){ var divToBeWorkedOn = '#AjaxPlaceHolder'; var webMethod = 'http://MyWebService/Web.asmx/GetInfoByDates' var parameters = "{'sDate':'" + sDate + "','eDate':'" + eDate + "'}" $.ajax({ type: "POST", url: webMethod, data: parameters, contentType: "application/json; charset=utf-8", dataType: "json", success: function(msg) { $(divToBeWorkedOn).html(msg.d); }, error:     function(e){ $(divToBeWorkedOn).html("Unavailable"); } }) ;   }   $.get("http://doman.com/webservice.asmx", { name: "Joh... [More]

with   member [GEO].[Hierarchy].[TOTALE ITALIA] as [GEO].[Hierarchy].[Level4 Name].&[10858]   select {       [GEO].[Hierarchy].[TOTALE ITALIA], [GEO].[Hierarchy].[Level4 Name].&[10858].children } on rows, {       crossjoin(  tail([Period].[Hierarchy].[Month Name].members,2),                         {        &n... [More]

Sometimes in sqlserver, we need to kill the processes that are running in a specific database. There might be several reasons for this. Sometimes lock request time out error occurs. Sometimes backup or restore cannot be done due to some connections that is not released and so on. We can use this simple procedure to kill all the processes that will resolve these problems. We need to create this procedure in the master database and run this procedure while selecting/using the master database. The procedure takes the database name for which we ... [More]

[No text]