Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked



Upload Image Close it
Select File

My Experiments with SQLServer
Browse by Tags · View All
SQLServer 126
SQLServer 2008 R2 91
SQLServer 2008 86
SQLServer 2005 82
SQL 60
Database 59
Sql And Me 57
Tips & Tricks 28
SQL Server 27
SQL FAQ 26

Archive · View All
May 2011 25
June 2011 21
July 2011 21
August 2011 19
April 2011 16
January 2013 4
May 2012 3
April 2012 3
October 2011 3
February 2013 2

Vishal Gajjar's Blog

  • 0
    Liked

    Using Catalog Views – sys.database_principals

    While sys.server_principals contains all logins/roles created on the server. sys.database_principals contains all users/roles in the current database. Some of the columns returned by sys.database_principals are as below: 1. Name – name of the principal – user/role name, 2. Principal_id......

    Vishal Gajjar  Posted on Jun 23 2011 6:55AM
    Profile · Blog
  • 0
    Liked

    Using Catalog Views – sys.identity_columns

    sys.identity_columns contains a list of all identity columns in the database, some of the columns returned by sys.identity_columns are as below: 1. Object_id – object id of the parent table, 2. Name – column name for the identity column, 3. Column_id – id of the columns in the t......

    Vishal Gajjar  Posted on Jun 21 2011 7:06AM
    Profile · Blog
  • 0
    Liked

    Using Catalog Views – sys.computed_columns

    sys.computed_columns returns all columns that are computed in the database, below are some of the columns returned by sys.computed_columns: 1. Object_id – object id of the table to which the column belongs, 2. Name – name of the computed column, 3. Column_......

    Vishal Gajjar  Posted on Jun 20 2011 7:17AM
    Profile · Blog
  • 0
    Liked

    Using Catalog Views – sys.sql_modules

    sys.sql_modules returns a row for each function, procedure, trigger, view and rules defined in the database. Below are some of the columns returned by sys.sql_modules: 1. Object_ID – ID of the object in the database, 2. Definition – module text, 3. Uses_ansi_null – 1 if module w......

    Vishal Gajjar  Posted on Jun 16 2011 7:34AM
    Profile · Blog
  • 0
    Liked

    Using Catalog Views – sys.foreign_keys

    sys.foreign_keys contains a list of all FOREIGN KEYS in the database. It contains one row per FOREIGN KEY. Below is a list of some columns returned by this view: 1. Name – FOREIGN KEY name, 2. Schema_ID – Schema ID of the parent object, 3. Parent_Object_ID – ID of the object to ......

    Vishal Gajjar  Posted on Jun 14 2011 7:53AM
    Profile · Blog
  • 0
    Liked

    Using Catalog Views – sys.views

    sys.views returns a row for each view in the database, sys.views only returns rows for which the user owns or has been granted permission for. Below are some of the columns returned by sys.views. 1. Name – Give name of the view, 2. Schema_id – ID of schema to which the view belongs, 3......

    Vishal Gajjar  Posted on Jun 15 2011 7:46AM
    Profile · Blog
  • 0
    Liked

    Using SQL DMVs – sys.dm_db_file_space_usage

    You can use the sys.dm_db_file_space_usage dynamic management view to monitor the spaced used by tempdb for storing user/internal objects and version store. sys.dm_db_file_space_usage has following columns: 1. database_id – will always be 2, database id of tempdb. 2. unallocated_extent_page......

    Vishal Gajjar  Posted on Jun 6 2011 5:28AM
    Profile · Blog
  • 0
    Liked

    Using SQL DMVs – sys.dm_db_session_space_usage

    While you can use sys.dm_db_file_space_usage to get the free space available in tempdb. you can use sys.dm_db_session_space_usage to get the used space by each session. sys.dm_db_session_space_usage contains following columns: 1. session_id – session_id 2. database_id – will always be......

    Vishal Gajjar  Posted on Jun 7 2011 5:20AM
    Profile · Blog
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]