MySQL client ran out of memory
Error Message : Open Database Connectivity (ODBC) error occurred. state: ‘HY000’. Native Error Code: 2008. [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.5-10.1.22-MariaDB]MySQL client ran out of memory This error is caused due to large number of rows that are stored in client machine memory. If you are reading data from MYSQL and not performing any seek operation, then you… (0 comment)

DECLARE @LastmonLastBusinessDay date, @inputdate date SET @inputdate = '05/25/2014' SELECT @LastmonLastBusinessDay = DATEADD(ms,-3,DATEADD(mm,DATEDIFF(mm,0,@inputdate),0)) - CASE DATENAME(dw,DATEADD(ms,-3,DATEADD(mm,DATEDIFF(mm,0,@inputdate),0))) WHEN 'SUNDAY' THEN 2 WHEN 'SATURDAY' THEN 1 ELSE 0 END print @LastmonLastBusinessDay… (0 comment)

Deleting duplicate rows in SQLServer is very simple. Example : Check this table let me call it as Sample, order number 1,2 & 3  have identical values. Now we need to delete the duplicate rows.   Step 1 : Insert another column in table Sample called  Dup of type Integer. Step 2 : Execute this Query… (0 comment)

How to Save and Schedule SSIS Packages using SQL Server 2008 R2 for Non Administrators Step 1 Upgrade SQLServer 2008 R2 with latest SP Step 2 Saving Package from Business Intelligence (.dtsx) to SQL Server EXEC sp_addrolemember 'db_ssisltduser', '<<user/group>>' EXEC sp_addrolemember 'SQLAgentUserRole', '<<user/group>>' Step 3 Follow this step for Connecting to a Remote Integration Services… (0 comment)

There are many Free and Better alternatives for list mentioned below. I like them because they make my life simple. Microsoft 1. Windows 2. Office (Word, Excel, Outlook, Power point, Access) 3. Visual Studio 4. Notepad 5. Microsoft Shared View 6. Microsoft Security Essentials 7. Snipping Tool 8. SQLServer Google 1. Search 2. Gmail 3.… (0 comment)