Blog Posts - Sql Server



Difference between row_number(), rank() and dense_rank() in SQL Server, Oracle.

Though all three are ranking functions in SQL, also known as window function in Microsoft SQL Server, the difference between rank(), dense_rank(), and row_number() comes when you have ties on ranking i.e. duplicate records. For example, if you are ra...
by javarevisited on Jul 23, 2016

What Every Developer Should Know About SQL Server Performance

What Every Developer Should Know About SQL Server Performance English | Size: 640.69 MB (671,816,262 Bytes)Category: CBTs This course is designed to teach developers the fundamentals of SQL Server performance, showing you the tools you will need...
by Tutorials For Download on Jul 18, 2016

How to remove duplicate rows from a table in SQL

There are a couple of ways to remove duplicate rows from a table in SQL e.g. you can use a temp tables or a window function like row_number() to generate artificial ranking and remove the duplicates. By using a temp table, you can first copy all uniq...
by javarevisited on Jul 7, 2016

Difference between close and deallocate cursor in SQL

Cursor in a database is used to retrieve data from the result set, mostly one row at a time. You can use Cursor to update records and perform an operation on a row by row. Given its importance on SQL and Stored procedure, Cursor is also very popular...
by javarevisited on May 12, 2016

Difference between Oracle SQL Query vs Microsoft SQL Server 2008 or Sybase

Oracle and Microsoft SQL Server are two of the most popular database but they are very different with each other and if you are migrating SQL queries or database, tables from Oracle 11g database to Microsoft SQL Server 2008 then you are bound to face...
by javarevisited on Apr 10, 2016

How to Convert Result of SELECT Command to Comma Separated String in SQL Server

Sometimes, you need the result of SQL SELECT clause as a comma separated String e.g. if you are outputting ids of white-listed products. By default, the SELECT command will print each row in one line and you get a column of names or ids. If you need...
by javarevisited on Apr 3, 2016

UDEMY – T-SQL FOR BEGINNERS LEARN TO QUERY SQL SERVER DATABASES

T-SQL FOR BEGINNERS LEARN TO QUERY SQL SERVER DATABASES Size: 490.4 MB Welcome everyone to the T-SQL course. T-SQL is also popularly referefered to as T-Sequel . In this course you will learn all the basics of T-SQL. We will discuss the T-SQL feature...
by tutgfx on Mar 31, 2016

How to increase length of existing VARCHAR column in SQL Server

You can increase the length of a VARCHAR column without losing existing data in SQL Server. All you need to do is that execute following ALTER TABLE statements. Though, you need to specify NULL or NOT NULL constraint explicitly, depending upon your d...
by javarevisited on Mar 27, 2016

How to delete from table using JOIN in SQL Server

It's a little bit tricky to delete from a table while using any type of JOIN in SQL e.g. Inner Join, Left Outer Join, or Right Outer Join. The obvious syntax doesn't work as shown below:delete from #Expired e INNER JOIN Deals d ON e.DealId =...
by javarevisited on Mar 20, 2016

SQL SERVER – Free SQL Server Formatting Add-in

This article describes the ways in which you can format SQL code using ApexSQL Refactor features and options. ApexSQL Refactor is a free add-in with over 200 formatting options and nearly 15 code refactors. You can qualify object names, expends wild...
by What is web development on Mar 16, 2016

SQL SERVER 2014 – BACKUP AND RECOVERY

SQL SERVER 2014 – BACKUP AND RECOVERY Size: 191.2 MB Being able to perform a database backup-and recover data when something goes wrong-is a key skill any database administrator should have. In this focused course, author Martin Guidry covers t...
by tutgfx on Mar 16, 2016

SQL SERVER – 2016 – Check Value as JSON With ISJSON()

I have been wanting to write about the various operators that govern using JSON and my first shot has been with: SQL SERVER – Getting started and creating JSON using SQL Server 2016. That was like a primer and as I see the subsequent releases of SQ...
by What is web development on Mar 14, 2016

Angular2 OpenID Connect Implicit Flow with IdentityServer4

This article shows how to implement an OpenID Connect Implicit Flow client in Angular2. The Angular2 client is implemented in Typescript and uses IdentityServer4 and an ASP.NET core 1.0 resource server. The OpenID Connect specification for Implicit F...
by What is web development on Mar 14, 2016

#SQL – SQL Server Loves #Linux (no, no es el día de los santos inocentes!)

Hola ! Pensaba que cuando tuviese internet en casa tendría más tiempo para ponerle al día con los posts, pero no, todos los días me aparece algo nuevo que hacer en casa y no doy a basto. Por eso, medio que he abandonado los posts sobre mis experi...
by El Bruno on Mar 9, 2016

Lock Escalations and Execution Plan shapes

Lock Escalations are really, really bad, because you end up with an Exclusive or Shared Lock at the table level. And placing such restrictive locks at the table level reduces your concurrency and the throughput of your database. I don’t want to ta...
by What is web development on Mar 8, 2016

How to Retrieve Configuration of Server

I have observed this question in the interview question few days ago. I had a fun time to see candidates failing to answer this question. The most common answer candidate gave us was that they will right click on the server and see the properties. We...
by What is web development on Mar 7, 2016

Extent Management in SQL Server

I today’s blog posting I want to talk about Extent Management in SQL Server, because this is a very important topic, especially when it comes to TempDb. On a very high level an extent is just a group of 8 pages of 8kb. An extent is therefore always...
by What is web development on Mar 7, 2016

Table Replication Error on Synchronization in Ax 2012

Getting this error on data dictionary synchronization..Error Synchronise database Cannot execute a data definition language command on  ().The SQL database has issued an error.Info Synchronise database SQL error description: [Microsoft][SQL Serv...

Table Replication on Synchronization in Ax 2012

Getting this error on data dictionary synchronization..Error Synchronise database Cannot execute a data definition language command on  ().The SQL database has issued an error.Info Synchronise database SQL error description: [Microsoft][SQL Serv...

SQL SERVER 2016 – InMemory OLTP support for Foreign Key

When InMemory OLTP was introduced in SQL Server 2014, there were a number of limitations that restricted customers to effectively use the capability. One of the most commonly asked capability was around the ability to create Foreign Keys. On first lo...
by What is web development on Mar 3, 2016


Trending Topics

Close