COUNT_BIG : Aggregate Function – TSQL Tutorial

COUNT_BIG function returns the number of items in a group.

COUNT_BIG works like the COUNT function. The only difference between the two functions is their return values.

COUNT_BIG always returns a bigint data type value. COUNT always returns an int data type value.

COUNT_BIG Syntax

COUNT_BIG ( { [ ALL | DISTINCT ] expression } | * )
OVER ( [ partition_by_clause ] order_by_clause )

COUNT : Aggregate Function – TSQL Tutorial

COUNT function returns the number of items in a group.

COUNT works like the COUNT_BIG function. The only difference between the two functions is their return values.

COUNT always returns an int data type value. COUNT_BIG always returns a bigint data type value.

COUNT Syntax

COUNT ( { [ [ ALL | DISTINCT ] expression ] | * } )
OVER ( [ partition_by_clause ] order_by_clause )

COUNT Example

ID Salary
1 300
2 500
3 700

SELECT COUNT(e.id) AS CountEmployees FROM employee e

CountContracts
3
Sony_motionshot_ported_2

How to install Xperia Z1 MotionShot Camera in any Android 4.0+ device

Sony has released a MotionShot camera app, which actually captures a short movie and makes it as a single image. Currently this app is only available for Sony Xperia Z1. But XDA Forum Member xperiaz2 ported this app to all the android phones which run on android 4.0+. The app is reported to be stable and working without any issues.

Sony in it’s Google Play app page describes that this app is also perfect for creating animated gif images. This MotionShot camera can be used in any action scenes involving sports, animals, kids, friends, vehicles, airplanes and moving objects.

This app also includes variety of effects (fade-in/fade-out), and you can also chose set the number of animation sequences, and specify other settings to create a original expression.

How to install Xperia Z1 MotionShot Camera in any Android 4+ device :

Sony_motionshot_ported

gmail logo

How to Enable Desktop Notifications in Gmail

The Gmail desktop notifications are available for Google Chrome, Firefox, and Safari. These notifications display new emails in a pop-up. This feature becomes convenient if Gmail is not in a active tab. You should have opened Gmail in one of the tabs of you browser for this feature to work.

How to Enable Desktop Notifications in Gmail

  • Open Gmail and Click the gear icon in the top right corner of the Gmail interface.
  • Select Settings.
  • In the General (default) tab scroll down to the section named “Desktop Notifications“.
  • You can choose one of the options given below:
  • New mail notifications on: If you use inbox categories, you’ll only be notified about messages in Primary.
  • Important mail notifications on: You’ll be notified about every incoming messages marked as important.
  • Mail notifications off.
  • Click on “Save Changes” button at the bottom of the page.

Gmail Desktop Notification

Ubuntu

How to Disable Remote Login in Ubuntu 13.10

The Ubuntu login screen contains options for Remote Login along with the guest session. The remote login feature allows the users to connect remote workstations and remote servers, right from the login screen itself. If you want to disable this feature follow the below given procedure.

How to disable Remote Login feature

  • Open the terminal by pressing Ctrl + Alt +T or searching for “Terminal” in the Ubuntu dash menu.
  • Copy and paste the below given command into the terminal and press enter.

sudo gedit /etc/lightdm/lightdm.conf

  • Add the following line at the end

greeter-show-remote-login=false

  • Save and close the conf file
  • You need to restart your computer for the changes to take effect

Disable Remote Login

Ubuntu

How to Disable Guest Login Account in Ubuntu 13.10

You can login into a guest account in Ubuntu. This account does not need any login credentials. It is a very useful feature for those who regularly share their computer with others, but if you think this feature is not for you and you want to disable it, follow the below given procedure.

How to disable Guest Login account

  • Open the terminal by pressing Ctrl + Alt +T or searching for “Terminal” in the Ubuntu dash menu.
  • Copy and paste the below given command into the terminal and press enter.

sudo gedit /etc/lightdm/lightdm.conf

  • Add the following line at the end

allow-guest=false

  • Save and close the conf file
  • You need to restart your computer for the changes to take effectDisable Guest Login Account
Ubuntu

How To Mount Hard Disk Partitions Automatically in Ubuntu 13.10

Partitions which are created when installing Ubuntu and removable storage devices like external hard disks USB Pen Drives are auto mounted in Ubuntu. But those hard disk partitions which are created before the installation are not auto mounted.

There are many ways to auto mount the hard disk partitions in Ubuntu like manually editing fstab file, GUIs like Pysdm, Arios Automount etc. But you can auto mount partitions without installing any software, Ubuntu includes a program called disks, a gnome disk utility, for managing hard disk partitions.

How to mount partitions automatically in Ubuntu 13.10

  • Open the “Disks” program by searching for disks in the Ubuntu menu.
  • Select the partition by clicking on it, Click on the Gears icon to open the options menu, and click on the “Edit Mount Options
  • Change the on button to turn off automatic management, and switch on auto mounting.
  • You can also name the partition.

Mount Hard Disk Partitions Automatically 1
Mount Hard Disk Partitions Automatically 2Mount Hard Disk Partitions Automatically 4

Ubuntu

How to Quickly Disable Global Menu in Firefox on Ubuntu 13.10

The Ubuntu Unity user interface tries to optimizes space and places the menu bar ( menu bar is the bar with menus file, edit, view etc) on top system bar instead of placing it on every individual window. This behavior applies to Firefox also. To quickly disable this feature for Firefox follow the below procedure.

How to Quickly Disable Global Menu in Firefox on Ubuntu 13.10

    • Open the Firefox Web Browser.
    • Type in about:config in the location bar.
    • Click on the I’ll be careful, I promise button.
    • Search for the below phrase in the search box

ui.use_unity_menubar

  • Double click on search result to set it to false.

Quickly Disable Global Menu in Firefox
How to Disable Global Menu bar in Ubuntu 13.10

Ubuntu

How to Disable Global Menu bar in Ubuntu 13.10

Unity is a very modern user interface and tries to optimizes space for all windows. The Unity interface places the menu bar ( menu bar is the bar with menus file, edit, view etc ) on top system bar instead of placing it on every individual window.

This feature become annoying and confusing when you use multiple monitors. It also gets confusing when you use multiple window mode in GIMP. Eclipse IDE has some issues with global menu.

How to Disable Global Menu bar in Ubuntu 13.10

    • Open the terminal by pressing Ctrl + Alt + t or searching for “Terminal” in the Ubuntu dash menu.
    • Copy and paste the below given command into the terminal and press enter.

sudo apt-get autoremove appmenu-gtk appmenu-gtk3 appmenu-qt

  • Restart the individual application to get the menu bar on window itself.

How to Disable Global Menu bar in Ubuntu 13.10