OFFSET and FETCH NEXT ROWS in SQL Server 2012?
OFFSET provides a starting row from which SQL Server needs to start fetching rows and FETCH provides the number of rows we want to fetch from the result set (or in a query). OFFSET and FETCH can be used only with an order by clause. Offset row count: It…
Generate New GUID (uniqueidentifier) in SQL Server
What is new GUID? The New-GUID cmdlet creates a random globally unique identifier (GUID). If you need a unique ID in a script, you can create a GUID, as needed. What is Uniqueidentifier datatype in SQL Server? The globally unique identifier (GUID) data…
Top New Features in Visual Studio 2012
1-Opening VS2010 Projects and Not Breaking Things Remember when VS2010 came out? Remember wanting to use it on your team? Remember how projects were incompatible so you had to wait forer the whole team to upgrade? Yea, that sucked. Oh wait. Remember…
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…
SQL SERVER – Azure SQL Databases Backup Made Easy with SQLBackupAndFTP
Azure SQL database backup used to be a difficult task. Not any more. With SQLBackupAndFTP with Azure it became trivial. Here’s what you basically need to do: Once SQLBackupAndFTP with Azure is installed, click at “Connect to SQL Server /…
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…