The ‘Database’ Archives
Posted August 22, 2014 by

Working with NULL Values in SQL Server

feature-sql

We cannot predict values for most future data points while working with database systems. For example, tables used for customer information often have a mobile number column. It is possible that a customer does not hold a mobile number, or for reasons of privacy, he does not want to share his mobile number. In such […]

Category Database, SQL Server

Posted August 20, 2014 by

Finding Duplicate Records Using GROUP BY in SQL Server

feature-sql

There are various times when we need to find duplicate records in SQL Server. It is possible to find duplicates using DISTINCT, ROW NUMBER as well as the GROUP BY approach.

Category Database, SQL Server

Posted August 18, 2014 by

Is_ms_shipped Property in SQL Server

feature-sql

Most of the time, we need to search for objects using metadata (data about data) to get information about SQL Server. For example, we use a query to find which version of SQL server is running on a particular machine. Metadata helps us to find settings and configurations for various objects in our database.

Category Database, SQL Server

Posted July 22, 2014 by

View and Edit Two Files Side By Side in SQL Server and Notepad++

notepad-plus-plus and sql server

Notepad++ is the editor that programmers prefer most because it is fast and lightweight. It is also bundled with tons of features and smart plugins. Notepad++ can be downloaded for free and is available on Windows as well as other operating systems. There are various tips and tricks that you can use to increase your […]

Posted July 21, 2014 by

Select Text Columns or Boxes Vertically in Notepad++ and SQL Server 2012

notepad-plus-plus and sql server

In any source code, we frequently need to select a piece of text vertically (column mode). This is not possible with typical editors such as Notepad or Wordpad. Vertically selecting text columns or boxes is one of the coolest tricks everyone should know in order to save time and increase productivity. This tutorial explains how […]

Category Database, SQL Server

Posted February 2, 2014 by

Inner and Left Outer Join with Where Clause vs ON Clause

database join featured article

Filtering results with the [ON] clause and the [Where] clause using LEFT OUTER JOIN and INNER JOIN is a very powerful technique.

Posted January 1, 2014 by

11 Keyboard Shortcuts Every SQL Server Geek Should Know

front_image_sql_server_keyboard_shortcuts

A smart programmer knows the ins and outs of the IDE in which he works. Keyboard shortcuts save a lot of time and can improve productivity as well. SQL server Management Studio has included over 100 keyboard shortcuts. Here, we will explore the most essential shortcuts which will make our daily programming life more easy […]

Category Database, SQL Server

Posted December 20, 2013 by

A Beginner’s Guide to the OUTPUT Clause in SQL Server

database featured admin

T-SQL supports the OUTPUT clause after the inception of SQL server 2005 and later editions. We can use the OUTPUT clause with DML statements (INSERT, DELETE, UPDATE) to return information from modified rows.

Category Database, SQL Server

Posted December 13, 2013 by

SQL Server: Browser Service Started and Then Stopped

The SQL Server Browser service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

This error message is commonly encountered: “The SQL Server Browser service on your local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.” This is how explore and fix this SQL Server issue.

Category Database, SQL Server

Posted October 19, 2013 by

SQL Server: Coding the After Delete Trigger in SQL Server

feature sql delete

A trigger is special type of stored procedure that is executed when an INSERT, DELETE or UPDATE statement modifies data in a table.

Category Database, SQL Server