Forum Replies Created

Viewing 15 posts - 40,921 through 40,935 (of 49,552 total)

  • RE: Trigger Help

    brekher (2/19/2009)

    If anyone can be of any help I would greatly appreciate this as this was handed down to me tonight and needs to be completed asap.

    What have...

    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

    February 19, 2009 at 9:59 pm

    #947312

  • RE: How to interprete the name of a temporary table?

    SQL ORACLE (2/19/2009)

    Now, looking at SSMS, I can see the name of this temporary table has a long attached characters at its end.

    Does anyone know how to interprete the attached...

    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

    February 19, 2009 at 9:58 pm

    #947311

  • RE: HELP PLS :( What does "Error: 644, Severity: 21, State: 3" means and how can I fix it?

    elay (2/19/2009)

    Server: Msg 8933, Level 16, State 1, Line 1

    Table error: Object ID 1654296953, index ID 50. The low key value on page (1:548364) (level 0) is not >= 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

    February 19, 2009 at 9:56 pm

    #947310

  • RE: Database restore wanings and error messages

    madhu.arda (2/19/2009)

    In the scenario, upgrade from sql 2000 to 2005, droping the statistics in SQL 2005 and run all the dbcc commands to make sure these in no corruption might...

    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

    February 19, 2009 at 9:52 pm

    #947309

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (2/19/2009)

    GSquared (2/19/2009)Nobody knows everything about SQL.

    [font="Verdana"]...except for Gail. :D[/font]

    Nope. There's several areas I know little about, have very little interest in and don't post about.

    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

    February 19, 2009 at 1:52 pm

    #947127

  • RE: Are the posted questions getting worse?

    Roy Ernest (2/19/2009)

    I want to know how much patience Grant and Gail has. They have entered that OPs thread. 🙂

    I'm done and he's now on my blacklist. Sorry, but....

    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

    February 19, 2009 at 1:50 pm

    #947124

  • RE: Database restore wanings and error messages

    madhu.arda (2/19/2009)

    INDEXPROPERTY ( 2017546371 , _WA_Sys_stdAQSKey_78415083 ,IsAutoStatistics )

    But Iam getting an error :

    Did you see how I used INDEXPROPERTY above? Did you look at the examples of its use...

    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

    February 19, 2009 at 1:47 pm

    #947117

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/19/2009)

    Lynn Pettis (2/19/2009)

    Put down the keyboard and back away slowly and noone will get hurt...

    How do you think this OP would do in our mock interview?

    I'm going 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

    February 19, 2009 at 1:14 pm

    #947081

  • RE: how to transfer data of each column from multiple table and calculate sum for each column

    josephptran2002 (2/19/2009)

    The error message is: Invalid Column name 'DDS' but there is a column name in each table.

    Are you sure that all the tables have a column with 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

    February 19, 2009 at 1:10 pm

    #947073

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/19/2009)

    Back to your question about changes to SSC. Not sure, but someone else may have mentioned this, but knowing who started a thread in the Active Threads...

    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

    February 19, 2009 at 12:56 pm

    #947063

  • RE: how to transfer data of each column from multiple table and calculate sum for each column

    josephptran2002 (2/17/2009)

    I am new to SQL 2005, Please help me

    May I suggest a good introductory SQL site?

    http://www.w3schools.com/sql/sql_intro.asp

    Or perhaps a good book on T-SQL fundamentals?

    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

    February 19, 2009 at 12:37 pm

    #947041

  • RE: DELETE locks UPDATE

    Leo Leong (2/19/2009)

    well, here is a simplified version of my scripts:

    Table Structure (Actual table consists of > 100 columns and 20 mil records)

    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

    February 19, 2009 at 12:27 pm

    #947024

  • RE: Database restore wanings and error messages

    madhu.arda (2/19/2009)

    Iam not sure that somebody manually created these statistics with exacltly the same form(Excep sqlserver admin) nobody has access though).If some body created them how can we know?

    Use INDEXPROPERY...

    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

    February 19, 2009 at 12:26 pm

    #947018

  • RE: Are the posted questions getting worse?

    Be nice. He's new at this. (apparently)

    Edit: Or maybe not. How have I managed to not notice this guy so far?

    Alvin Ramard (2/19/2009)

    Meanwhile, watch out for that SQL Biible approaching...

    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

    February 19, 2009 at 12:08 pm

    #947002

  • RE: Deleting Table taking very long time

    SanjayAttray (2/19/2009)

    SQL Server is by default is set to page lock.

    SQL will use row, page, extent or table as necessary depending on the number of rows been affected...

    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

    February 19, 2009 at 11:58 am

    #946988

Viewing 15 posts - 40,921 through 40,935 (of 49,552 total)