Forum Replies Created

Viewing 15 posts - 41,941 through 41,955 (of 49,552 total)

  • RE: User Defined Function: order by won't work

    tfifield (1/6/2009)

    Gail,

    Wow! I never thought about the parallel problem. It gets uglier all the time. I'd have to tweak MAXDOP in order to guarantee that it was...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 11:27 am

    #921996

  • RE: USING SUBQUERY IN INSERT STATEMENT

    Franco_1 (1/6/2009)

    VALUES (@ProjectName,@Description,@RequestedBy,(select deptID from Department where Department=@Dept) as @DeptID)

    The source for an insert can be either VALUES or SELECT, not a combination.

    Try this:

    INSERT INTO tblProject...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 11:21 am

    #921993

  • RE: Is using triggers the only way of auditing updates of table rows?

    Lowell (1/6/2009)

    you need to track changes in the TEMPDB? maybe you mentioned the wrong db?

    In 2005/2008, the inserted and deleted tables are materialised from the row version store that's...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 11:14 am

    #921987

  • RE: Transaction log grows fast

    branovuk (1/6/2009)

    Gail, for me time is not crucial, most important is valid restoration to the point of time. So, I think to go with full + (often) diff backup.

    In that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 11:13 am

    #921984

  • RE: Is using triggers the only way of auditing updates of table rows?

    Marios Philippopoulos (1/6/2009)

    DECLARE @ActionType char(1)

    SELECT @ActionType = CASE

    ...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 10:22 am

    #921947

  • RE: Verifying that a primary key exists for a table through script

    SELECT OBJECTPROPERTY(Object_ID('TableName'),'TableHasPrimaryKey')

    Or, if you want to check all the tables.

    SELECT name, OBJECTPROPERTY(Object_ID,'TableHasPrimaryKey') FROM sys.tables

    It's hard to recommend a script to auto-generate primary keys, because the question is, what does the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 10:07 am

    #921937

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/6/2009)

    I used to have a 100-sided die. Great novelty, but the stupid thing would roll across the street before it stopped and it was hard to tell which...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 9:13 am

    #921884

  • RE: Are the posted questions getting worse?

    Greg Edwards (1/6/2009)

    At some point, I have to ask the dumb question to Gail :w00t: - the more sides, the more precise the answer? or the more likely to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 8:59 am

    #921869

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/6/2009)

    I must be old, D&D used lots (and lots and lots) of six-sided dice. Now, Traveller, there were the decimal dice at work.

    Which edition was that? I know...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 8:55 am

    #921865

  • RE: stored insert staements in a table and cursor

    Please post table definitions and sample data. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 8:50 am

    #921858

  • RE: SQL Server Options to Avoid - SQL School Video

    mark (1/6/2009)

    Or do something sane and calculate the maximum amount of wait time your users are willing to tolerate, determine the amount of space Sql Server can initialize in that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 7:39 am

    #921787

  • RE: "Items is not a recognized table hints"

    What compatibility mode is your database in?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 7:27 am

    #921772

  • RE: Transaction log backup failed message

    Can you get the full message?

    Go to the SQL job, open the job step that's failing. On the 'Advanced' page you can enter a file name for the full output...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 7:26 am

    #921771

  • RE: Are the posted questions getting worse?

    Chris Morris (1/6/2009)

    GilaMonster (1/6/2009)

    I recommend a 20-sided dice.

    Six is sufficient...http://en.wikipedia.org/wiki/The_Dice_Man

    Maybe for you. 😉 I play D&D. The 20-sided dice is the most important one.

    I have 4, 6, 8, 10 and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 7:15 am

    #921763

  • RE: database crash

    Is the database in full recovery?

    Do you have regular transaction logs?

    Can you do a final log backup before you restore the backup?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 6, 2009 at 7:14 am

    #921761

Viewing 15 posts - 41,941 through 41,955 (of 49,552 total)