Top 5 new features of Visual Studio 2010 and .NET 4
There lots of improvement in Visual Studio 2010 over past version. Below are some new great features of Visual Studio 2010 – Better code intellisense Visual Studio 2010 has better code intellisense support which make it easier for look for methods…
DELETE From SELECT Statement – Using JOIN in DELETE Statement – Multiple Tables in DELETE Statement
DELETE From SELECT Statement It is totally possible to use JOIN and multiple tables in the DELETE statement. Let us use the same table structure which we had used previously. Let us see the following example. We have two tables Table 1 and Table 2. --…
Reasons for Statement Recompilation
What is recompilation in SQL Server? Recompilation is the same process as a compilation, just executed again. If the database structure or data changes significantly, a recompilation is required to create a new query execution plan that will be optimal…
RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds
Identity Column in Database Syntax DBCC CHECKIDENT ( table_name [, { NORESEED | { RESEED [, new_reseed_value ] } } ] ) [ WITH NO_INFOMSGS ] table_name Is the name of the table for which to check the current identity value. The table specified must…
Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT in SQL Server 2012 onwards
CONCAT_NULL_YIELDS_NULL will be always ON in the future so avoid setting it off. What this function essentially does is that when it is on it will return a null value when any other value is connected it with using + operator.…
A New Approach to Scale .NET Applications
A typical scale-out architecture might look like this: Each process in the NuoDB architecture represents a virtual or physical cloud resource but the database as a whole continues to represent itself as a single logical database to any client that’s…
SQL SERVER – Solution to Puzzle – REPLICATE over 8000 Characters
Just quick to summarize the puzzle. Here is the quick recap of the same. Now let us run following script. DECLARE @FirstString VARCHAR(MAX) DECLARE @SecondString VARCHAR(MAX) DECLARE @ThirdString VARCHAR(MAX) SET @FirstString = REPLICATE('A',4000) SELECT…