Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

My Badges

Request Friendship



Upload Image

31 years old
Ahmedabad
Male
Chintak Chhapia
40 · 5% · 1477

Chintak Chhapia's Home

My name is Chintak Chhapia. I live in Ahmedabad, India. I work as Database Lead at Synaptic Digital. I blog at .  +Chintak Chhapia
  • Preventing the usage of SELECT *

    Chintak Chhapia Commented 6 Months ago through Blogs
    Yes Very true. Also people who use "select *" may be also using "Insert" without mentioning columns....
    Madhivanan JR
    2 · 40% · 13039
  • Preventing the usage of SELECT *

    Chintak Chhapia Commented 6 Months ago through Blogs
    Nice Tip Madhivanan. The same concept can be applied to tables by use of computed columns. create table t1 ( c1 int , c2 nvarchar(100) , c3 as cast(c2 as int)) insert into t1 (c1,c2) select 1,'test' -- th...
    Madhivanan JR
    2 · 40% · 13039
  • Preventing the usage of SELECT *

    Chintak Chhapia learned 6 Months ago through Blogs
    ...
    Madhivanan JR
    2 · 40% · 13039
  • Preventing the usage of SELECT *

    Chintak Chhapia Liked 6 Months ago through Blogs
    ...
    Madhivanan JR
    2 · 40% · 13039
  • Question of the month November 2014 - What is the result of CAST(1001 as CHAR(3))?

    Chintak Chhapia Commented 7 Months ago through Blogs
    Madhivanan, Not sure, but think that this is done to preserve the value where digit loss can be a significant data change specially in case of some critical measurement or money. Also, interesting thing to lookout for is this behavior SELECT ...
    Madhivanan JR
    2 · 40% · 13039
  • Where clause

    Chintak Chhapia Commented 1 Years ago through Ask
    Ideally, you should not use in cause for such large number of values. You should populate data into temp table and then do inner join. In some builds of SQL Server there is some catastrophic bug for large number of values in IN clause. Also in clause...
    mannu2010
    598 · 0% · 61
  • #0300 - SQL Server - Table Hints - WITH (NOLOCK) does not propagate through computed column expressions

    Chintak Chhapia Liked 2 Years ago through Blogs
    There are many myths related to performance tuning in SQL Server. One of the top-ranking myths is that using the WITH (NOLOCK) table hint is a silver bullet to 80% of the performance problems that an application might be facing. However, the WITH (NOLOC...
    Nakul Vachhrajani
    4 · 36% · 11648
  • #0299 - SQL Server - Myths - Using WITH (NOLOCK) also works on INSERT/UPDATE/DELETE statements

    Chintak Chhapia Liked 2 Years ago through Blogs
    We know that using the WITH (NOLOCK) table hint in SELECT statements minimizes locking in the SQL Server database by acquiring a Schema stability (Sch-M), the highest level non-invasive lock. But does this hold true for INSERT/UPDATE and DELETE statemen...
    Nakul Vachhrajani
    4 · 36% · 11648
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.