Forum Replies Created

Viewing 15 posts - 37,441 through 37,455 (of 49,552 total)

  • RE: Database back up failed, but did it?

    No idea. Can you restore the backup file? That's the best way to see if the backup completed.

    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

    July 24, 2009 at 12:43 pm

    #1029976

  • RE: Database back up failed, but did it?

    dh (7/24/2009)

    1. Should I run the 'DBCC SHRINKFILE' command against the log file and/or 'BACKUP LOG name with TRUNCATE_ONLY' to get the log file down?

    Maybe and no. If you run...

    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

    July 24, 2009 at 12:15 pm

    #1029956

  • RE: Error with Syntax in Case statement

    Lynn, yours is not equivalent if MyField can be null.

    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

    July 24, 2009 at 12:11 pm

    #1029951

  • RE: Difference between Unique Clustered Index & Non Unique Clustered Index

    allen davidson (7/24/2009)

    I thought that it keeps rows with adjacent clustered index entries, subject to space being avaiable on the page, on the same leaf page.

    It does.

    Let's take an example...

    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

    July 24, 2009 at 11:14 am

    #1029911

  • RE: Are the posted questions getting worse?

    jcrawf02 (7/24/2009)

    By the way Gail, never officially thanked you (thank you, thank you, thank you!) for the link to Leigh's WOT Re-read.

    Pleasure. I love her writing style.

    I'm way behind,...

    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

    July 24, 2009 at 10:59 am

    #1029893

  • RE: Are the posted questions getting worse?

    Jeffrey Williams (7/24/2009)

    I wonder what it says about me that I actually enjoy reading all of these books that are supposedly targeted at teens? :hehe:

    I'm the same. I find...

    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

    July 24, 2009 at 10:57 am

    #1029891

  • RE: Difference between Unique Clustered Index & Non Unique Clustered Index

    allen davidson (7/24/2009)

    Because a clustered index determins the physical order of records on disk....

    Clustered index determines the logical order of the data, not the physical. Rows can be stored physically...

    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

    July 24, 2009 at 10:04 am

    #1029834

  • RE: Difference between Unique Clustered Index & Non Unique Clustered Index

    A clustered index has to be unique. It's the row's 'address'. If the clustered index is not declared as UNIQUE then, behind the scenes, SQL adds an integer column 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

    July 24, 2009 at 9:43 am

    #1029809

  • RE: fatal error 5243, possibily related to snapsnot

    Do you have the source code for that trigger?

    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

    July 24, 2009 at 9:20 am

    #1029779

  • RE: Can any of you optimize the SQL query..?

    Why do you say the cursor is unavoidable?

    Can you explain what this does?

    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

    July 24, 2009 at 8:37 am

    #1029735

  • RE: DB Trigger not running as user!

    Look up EXECUTE AS in Books Online. There are a lot more options than just EXECUTE AS OWNER.

    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

    July 24, 2009 at 8:26 am

    #1029719

  • RE: DB Trigger not running as user!

    jordon.shaw (7/24/2009)

    Is there a way in SQL to do like a runas?

    Look up EXECUTE AS

    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

    July 24, 2009 at 8:15 am

    #1029700

  • RE: Index scan hint

    Paul White (7/24/2009)

    There are at least four cases where a scan may be as fast or faster than a seek (over the same, or very similar, number of records):

    1. ...

    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

    July 24, 2009 at 8:05 am

    #1029693

  • RE: PASSWORD

    I keep running into people who have SQL 2005 on Vista, somehow missed the provisioning tool that launches at the end of the SP2 installation and then can't log into...

    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

    July 24, 2009 at 6:18 am

    #1029596

  • RE: MCDBA for sqlserver2000

    The exams for the MCDBA cert were retired a long time ago and there's no longer any way to get that cert. Rather look at getting MSTS and MCITP for...

    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

    July 24, 2009 at 6:13 am

    #1029592

Viewing 15 posts - 37,441 through 37,455 (of 49,552 total)