Posts
Friday, December 18, 2015
Monday, November 16, 2015
Javascript String.padLeft( len, leadingChar )
String.prototype.padLeft = function padLeft(length, leadingChar) {
if (leadingChar === undefined) leadingChar = "0";
return ( this.length < length )
? (leadingChar + this).padLeft(length, leadingChar)
: this;
};
Tuesday, September 22, 2015
FIX: Poor performance when you use table variables in SQL Server 2012 or SQL Server 2014 :: KB2952444
The performance issue with Table variables with many rows and then join it with other tables has ben fixed by as explained in KB2952444. Before the fix which applied to SQL Server 2012 SP2 and later, the query optimizer may choose an inefficient query plan, which may lead to slow query performance.
https://support.microsoft.com/en-us/kb/2952444
https://support.microsoft.com/en-us/kb/2952444
Tuesday, September 15, 2015
T-sql :: Change just DATE part of a DATETIME
DECLARE @dt DATETIME
SET @dt = GETDATE()
SELECT DATEADD(dd, DATEDIFF(dd, @dt, '2015-06-01'), @dt)
Tuesday, July 7, 2015
Set date to first day of the month and end day of the month
Set date to first day of the month:
Set date to end day of the month:
Set date to last day of the previous month:
Remove milliseconds from datetime:
SELECT DATEADD(m, DATEDIFF(m, 0, GETDATE()), 0)
Set date to end day of the month:
SELECT EOMONTH(GETDATE())
Set date to last day of the previous month:
SELECT EOMONTH(GETDATE(), -1)
Remove milliseconds from datetime:
DECLARE @now DATETIME
SET @now = GETDATE()
SELECT @now
SELECT DATEADD(ms, -DATEPART(ms, @now), @now)
Friday, February 27, 2015
Visual Studio Error List and Output Window shortcuts
To view the Error List window: CTRL + \,E inside the IDE.
To show the Output Window: CTRL + ALT + O.
To show the Output Window: CTRL + ALT + O.
Wednesday, February 11, 2015
Visual Studio Immediate Window shortcut
To get in the immediate window in Visual studio ::
Debug --> Windows --> Immediate
Ctrl + Alt + I
Debug --> Windows --> Immediate
Ctrl + Alt + I
Monday, September 8, 2014
Unable to update the EntitySet ‘Table’ because it has a DefiningQuery and no element exists in the element to support the current operation
Entity Framework tried to add a record to a table which had Clustered Index but it didn't have Primary Key.
Simple solution was adding the Primary Key.
the reason is treating the table as View, then the EDMX file keep the table as a view in StorageModel\EntitySet\DefiningQuery element. When there is a DefiningQuery the Entity becomes readonly unless you add modification functions, the other solution can be adding modification functions like Stored Procedures for Inserting, Updating, and Deleting.
Simple solution was adding the Primary Key.
the reason is treating the table as View, then the EDMX file keep the table as a view in StorageModel\EntitySet\DefiningQuery element. When there is a DefiningQuery the Entity becomes readonly unless you add modification functions, the other solution can be adding modification functions like Stored Procedures for Inserting, Updating, and Deleting.
Tuesday, August 19, 2014
Subscribe to:
Posts (Atom)
