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

Liked



Upload Image Close it
Select File

My experiences and references in SQL server
Browse by Tags · View All
SQL Server 14
#SQLServer 14
SQL Scripts 13
#TSQL 6
TSQL 6
SQL Serevr - Issues and Resolutions 3
SQL Server - Best Practises 3
SQL server - Misconceptions 3
SQL server - Statistics 2
SQL Server - Wait stats and Queues 2

Archive · View All
October 2011 8
March 2011 7
April 2011 4
May 2011 3
November 2011 3
December 2010 3
December 2011 2
June 2008 2
February 2011 2
February 2012 1

SQLZealot's Blog

  • 0
    Liked

    Common Best Practises

    1. Never ever use Select * in your query. - If you use *, the engine has to get all the column information from the table. If your table is huge and the column contain huge data, it may lead to IO bottleneck. - There is a good prone to break your code if some one adds a column to the table when y......
    Latheesh NK  Posted on Apr 27 2011 7:06AM
    Profile
  • 0
    Liked

    Index size on a table

    It is often a requirement to understand the size of indexes on a table. Here is a script shared by one of my friend at my workspace... looks very useful!!! DECLARE @OBJECT_NAME VARCHAR(255) = 'trn_defect_tracking_history'; DECLARE @temp TABLE ( indexID BIGINT, ......
    Latheesh NK  Posted on Apr 14 2011 8:01AM
    Profile
  • 0
    Liked

    Table Information

    The below script provides a complete possible information on a table. /* First Resultset(Table Information) Table Name ObjectId Table Type Is replicated table or not Row count of the table Second Resultset(Column information) Third Resultset(Index Information) Name, Id, Seeks, scans, upda......
    Latheesh NK  Posted on Apr 14 2011 7:02AM
    Profile
  • 0
    Liked

    Dead lock Information from XML to Table Format

    Here with a script to convert the XML dead lock file to a table format as we DBA love the table fundamentally... SELECT QUOTENAME(SCHEMA_NAME(t.schema_id)) + '.' + QUOTENAME(t.name) AS TableName, c.name AS ColumnName, TYPE_NAME(c.system_type_id) AS 'DataType', IDENT_CURRENT(SCHEMA_NAME(t.sc......
    Latheesh NK  Posted on Apr 1 2011 7:59AM
    Profile
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]