Forum Replies Created

Viewing 15 posts - 436 through 450 (of 3,061 total)

  • RE: Temporal Data

    JQAllen (2/29/2012)


    Have you experienced the need for analyzing data temporally in your business? Do your existing information management systems allow you to view historical data? Typically, when you update or...

  • RE: Database back up strategy

    It all depends on data volatility and business requirements.

    Two examples.

    #1 - If you have a production database that gets updates once a day then setting that database to...

  • RE: Design Question, Dictionary vs Many Fields

    You are correct, question is a bit generic and exposes very little backgroud on the specifications therefore is a bit hard to guess.

    Either way, is this an OLTP system?

    In the...

  • RE: SQL Like Clause

    marly (3/12/2012)


    ColdCoffee (3/12/2012)


    Bro, when u see a empty string in the Frist Name text box (or wherever the value for @FirstName comes from) , handle it. Tell the user that...

  • RE: Restoring a database.

    sufiyan.sarguroh (3/12/2012)


    Say i have db1 and db2 .

    I want the tables uder db1 to be availaible in db2. Import/Export is one option. Can restore db also be used in...

  • RE: Database file size 100% utilized?

    MSQLDBA (3/10/2012)


    After this result i increase the size of the database file, upto 2GB.

    Did you increase the datafile size or did you allow SQL Server to extend datafile up to...

  • RE: how to desgin useful partition table

    I agree with Jared. Partitioning is not intended to be a solution for query performance but for data administration, like helping during archiving and purging processes.

  • RE: To_Date Slow in Where Clause

    mupparaju78 (3/6/2012)


    I have Simple Oraclae query..

    its take long time while run the query if we Don't have any data in table beetween date.

    if we have data between dates.. got...

  • RE: SSMA v2 for Oracle

    robert.baird 2778 (2/28/2012)


    I am in the process of migrating from oracle 8.1.0.6 to sql server. I am trying to use the SSMA (version 2, I tried 4 and 5 and...

  • RE: Unique Key constraint Violation code

    Make and unique index in such a column then handle the exception properly so to return a more polite message to the user - an alternative would be to do...

  • RE: Derived Column Data Conversion

    Not sure if I got the specs right but, try this:

    (ISNULL(DT_I4) ? "" : DT_I4) + (ISNULL(DepartmentID) ? "Unknown" : DepartmentID)

  • RE: Lost data when restoring database from file

    Research Point-in-Time recovery which includes having the target database in Full Backup Model, taking both Full and Transaction Log backups.

    Also check tail-log backup.

  • RE: How to speed up Running Average View

    loki1049 (2/24/2012)


    I also thought maybe it was not using the index. Is there a way to force a view to use an index? I remember something about a HINT keyword...

  • RE: Need one row per teacher no matter how many schools they teach at.

    GilaMonster (2/24/2012)


    PaulB-TheOneAndOnly (2/24/2012)


    Opus (2/24/2012)


    That's what I was thinking should work but it didn't. I just come to find out some of the teacher names were entered with spaces. ...

  • RE: How to speed up Running Average View

    Check execution plan ... is it taking advantage of index on SamplingDate column?

    Are your performance statistics on base table up-to-date? if performance is decreasing as time goes by chances are...

Viewing 15 posts - 436 through 450 (of 3,061 total)