Forum Replies Created

Viewing 15 posts - 766 through 780 (of 3,061 total)

  • RE: DEADLOCK problem in our production DB

    Suresh Kumar-284278 (11/8/2011)

    I am facing below issue in our production DB and would like to understand the reason behind this.

    Transaction (Process ID 297) was deadlocked on lock resources with another...

    November 8, 2011 at 2:34 pm

    #1404856

  • RE: Really large LDF file

    mbender (11/8/2011)

    awesome information, being that we have a simple recovery model would it be safe then to shrink the ldf? its 50gb which seems really large especially based on the...

    November 8, 2011 at 12:52 pm

    #1404795

  • RE: SQL conundrum

    SQL Kiwi (11/8/2011)

    PaulB-TheOneAndOnly (11/8/2011)

    Not in the sense of over-booking partial flight legs like this system does

    Fair enough. Booking part of a flight is an intriguing idea though - parachutes...

    November 8, 2011 at 12:10 pm

    #1404761

  • RE: How you do Databse Refresh and how Often?

    logicinside22 (11/8/2011)

    Like to know stretagy for Database Refresh from Production to Other enviornment.

    it all depends of business requirements which usually include:

    1- Frequency - is once a month Okay?... twice...

    November 8, 2011 at 11:03 am

    #1404732

  • RE: Full Text Search

    prashant-507002 (11/8/2011)

    I have to do the full text search in SQL server 2008.

    Can any one help me out for doing

    1.Specific Word or Phrase

    2.Fuzzy Search

    3.Multi Search (And,Or,Near,And Not).

    Is there anything...

    November 8, 2011 at 7:20 am

    #1404519

  • RE: Partitioning a table with 50 million records - What should be the strategy ?

    TheSQLGuru (10/3/2011)

    Partitioning is an ADVANCED feature and you will very likely get yourself into unfortunate situations/scenarios if you ask for a few pointers on a forum, read a blog post...

    November 8, 2011 at 7:16 am

    #1404515

  • RE: Something you could never do in sql server

    GSquared (11/8/2011)

    PaulB-TheOneAndOnly (11/5/2011)

    GSquared (11/4/2011)

    ... I had a rollback command once that took over a week to finish. On a command that had been running for about 30 seconds.

    Most probably...

    November 8, 2011 at 7:05 am

    #1404505

  • RE: Fastest way to update DM data from DW?

    erikpoker (11/8/2011)

    Ok. This was a bit more complex than I first realized.

    The job that will update our DM from the DW is not a full update.

    It will only select a...

    November 8, 2011 at 6:49 am

    #1404488

  • RE: Auto generated Key

    EasyBoy (11/8/2011)

    Actually this table has already few rows for Primary key

    Let say from 1 to 20,000.

    Could you please clarify? this is kind of confusing - a table has...

    November 8, 2011 at 6:26 am

    #1404458

  • RE: Creating a new column based on stated criteria

    matt_scott1984 (11/8/2011)

    Hello all,

    I'm having trouble trying to get the required results with the following SQL code:

    SELECT bh_bildat, bh_bilnum, bh_biltot, bh_type, bh_payamt, bh_biltot - bh_payamt AS 'Amount...

    November 8, 2011 at 6:20 am

    #1404448

  • RE: SQL conundrum

    SQL Kiwi (11/8/2011)

    PaulB-TheOneAndOnly (11/8/2011)

    Never seen a system designed to overbook resources on purpose before

    Don't airlines do this routinely on the basis that some people will cancel at the last minute...

    November 8, 2011 at 6:13 am

    #1404437

  • RE: SQL conundrum

    What do you have so far in terms of the query? You may want to consider a temporary table where to slice the proposed meeting time in let's say...

    November 8, 2011 at 6:05 am

    #1404427

  • RE: Tables without Primary Keys???

    MuraliKrishnan1980 (11/8/2011)

    [font="Tahoma"]

    Hi Gail.. These tables are having foreign keys which are referencing other tables...These tables are not referred by other tables....[/font]

    What kind of tables are we talking about? are these...

    November 8, 2011 at 5:59 am

    #1404421

  • RE: weird - all my fk's disappeared?

    sqlguy-736318 (11/6/2011)

    I normally add my FK's through database diagrams.

    Just adding the popular outcry allow me to say that ALL and EVERY change to the database should be done using...

    November 8, 2011 at 5:54 am

    #1404414

  • RE: Fastest way to update DM data from DW?

    erikpoker (11/8/2011)

    Any suggestions?

    Any particular reason not to use the actual FACT table as the center point of your datamart? After all related DIM tables are related to it,...

    November 8, 2011 at 5:46 am

    #1404403

Viewing 15 posts - 766 through 780 (of 3,061 total)