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

Request Friendship



Upload Image

39 years old
Ahmedabad, India
Male
Jacob Sebastian
1 · 100% · 32235
  • sql help

    Jacob Sebastian Commented 1 Years ago through Ask | 10 Points
    A simple `SELECT state, city FROM city ORDER BY State, City` can give you the desired result set. If the challenge you are trying to solve is the 'horizontal line' after each state and removing duplicate values from being displayed in the 'state' co...
    anuvarshini
    350 · 0% · 117
  • sql order by class

    Jacob Sebastian Commented 1 Years ago through Ask | 10 Points
    The data is little weird. Ideally, it should be stored in a more structured manner. Assuming that this is the data we need to deal with, the following code works if you are on SQL Server 2008. In case you are on an earlier version, a similar techniq...
    anuvarshini
    350 · 0% · 117
  • How much Time Duration for Release table lock in SQL SERVER -- (To Avoid Deadlock)

    Jacob Sebastian Commented 1 Years ago through Ask | 10 Points
    I have not tried it this way, but all our applications are using stored procedures to access the data. Each of those stored procedures have a SET XAC_ABORT ON at the beginning which will ensure an automatic roll-back if something unexpected goes wrong. ...
    ajmeri.jahid
    126 · 1% · 402
  • Transaction Log File Issue in SQL SERVER

    Jacob Sebastian Commented 1 Years ago through Ask | 10 Points
    It is possible to set a limit to the TRN log size. However, if you do that, you need to ensure that the log does not grow beyond that, else you will end up with a problem. For serious applications we need to be careful with this type of limits. Most ...
    ajmeri.jahid
    126 · 1% · 402
  • Hardware Requirement of Sql server 2008r2

    Jacob Sebastian Commented 1 Years ago through Ask | 10 Points
    This MSDN [article][1] gives a basic idea about the hardware/software requirements for SQL Server 2008, which may be a good starting point. [1]: http://msdn.microsoft.com/en-us/library/ms143506(v=sql.100).aspx...
    Alok Chandra Shahi
    69 · 3% · 810
  • Hardware Requirement of Sql server 2008r2

    Jacob Sebastian Commented 2 Years ago through Ask | 10 Points
    Agreed with Nakul. This is very much challenging when you are on a new project and you do not have much idea about the exact work load expected. I think you should do some stress test with the expected work load on a test server with basic configura...
    Alok Chandra Shahi
    69 · 3% · 810
  • Need your suggestion / Feedback regarding - automation of database rebuild / reorganize indexes

    Jacob Sebastian Commented 2 Years ago through Ask | 10 Points
    I do not have a ready list, however, I have invited a few DBAs that I know who may want to step in and share their thoughts on this. I generally skip tables having less than 1000 pages from the index rebuild/reorganize operation. I also ignore fragme...
    krish
    137 · 1% · 362
  • Need your suggestion / Feedback regarding - automation of database rebuild / reorganize indexes

    Jacob Sebastian Commented 2 Years ago through Ask | 10 Points
    Assume that you have a table with a clustered index on a `UNIQUEIDENTIFIER` column. Now, if the inserts are not generating a sequential GUID, the fragmentation will be too high on this table. So to fix that one might want to generate a sequential GUID (...
    krish
    137 · 1% · 362
  • Need your suggestion / Feedback regarding - automation of database rebuild / reorganize indexes

    Jacob Sebastian Commented 2 Years ago through Ask | 10 Points
    I see no problem in automating such a process. In fact some of our applications do have weekly automated defrag jobs. It is also important to manually review the tables that builds a lot of fragmentation and there are chances that you fix the excessive ...
    krish
    137 · 1% · 362
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.