Loading
Jignesh Trivedi's contributions
Delayed Transaction Durability in SQL Server 2014 (CTP2)
SQL server 2014 (CTP2) introduced Delayed Durability. It helps reduce the IO contention for writing to the transaction log.
Creating Entity Key in Entity Framework
This article exlains how to create an Entity Key in the Entity Framework.
IDENTITY Vs SEQUENCE Object in SQL Server
This article describes the differences between an IDENTITY property and SEQUENCE object.
EXECUTE Statement Enhancement WITH RESULT SETS in SQL Server 2012
This article explains the EXECUTE atatement enhancement in SQL Server 2012, WITH RESULT SETS.
“LOG” function enhancement in SQL Server 2012
This blog explains the LOG function in SQL server 2012.
OFFSET and FETCH in SQL Server 2012
SQL Server 2012 has introduced two new keywords for doing pagination of the result sets: OFFSET and FETCH.
Lead and Lag Function in SQL Server 2012
This article explains the SQL Server 2012 two new analytical functions LEAD and LAG.
Entity Framework Error: The Relationship Could Not be Changed Because One or More of the Foreign-key Properties is Non-nullable
I am currently working on a MVC and Entity Framework based project in which I encountered a problem with Entity Framework when trying to delete an entity from a related data collection and one or more of the foreign-key properties is non-nullable.
Exception or Error Handling in ASP.Net MVC Using HandleError Attribute
Exception handling may be required in any application either it is web application or window form base application.
Anonymous Types In C#
Anonymous types allow us to create new types without defining them. In this article, you'll learn how to use Anonymous Types in C#.
Caching in MVC Application With Entity Framework Using Query Notification
This article explains caching in a MVC web application with Entity Framework using Query Notification (SqlDependency).
Controlling Parameter Sniffing in SQL Server
Learn how SQL Server parameter sniffing affects cached execution plans and explore workarounds using recompilation, query hints, dummy variables, and decision-tree procedures.
Parameter Sniffing in SQL Server
This article explains how to avoid unnecessary compilations by reducing the number of ad hoc query in the cache plan using parameter sniffing in SQL Server.
Throw in SQL Server 2012
Throw keyword is introduced with SQL server 2012. Throw is used to raises exception and transfers execution to a CATCH block in SQL server.
New Conversion Function in SQL Server 2012
SQL Server 2012 introduced the four new conversion functions: TRY_CAST, TRY_CONVERT, PARSE and TRY_PARSE.
SET Vs SELECT When Assigning Values to Variables in SQL Server
There are two ways to assign a value to a local variable created previously: SET and SELECT. We can usually use SET and SELECT alternatively without any effect.
New Logical Function in SQL Server 2012
SQL Server 2012 introduces two new logical functions: CHOOSE and IIF.
New Date Functions in SQL Server 2012
This article explains 7 new date functions in SQL Server 2012..
New String Function in SQL Server 2012
SQL Server 2012 introduced two new string functions: Concat and Format.
Surrogate Key in SQL Server
This article explains what Surrogate Keys in SQL Server are. A Surrogate Key in SQL Server is a unique identifier for each row in the table.
Cursor Alternative in SQL Server
In this article I am trying to explain the alternatives for Cursors. We shall use a Cursor when there is no other option than Cursor.
Set Trigger Firing Order in SQL Server
Learn how to control the firing order of SQL Server AFTER DML triggers with sp_settriggerorder, including its limitations for multiple triggers.
