Forum Replies Created

Viewing 15 posts - 29,776 through 29,790 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    george sibbald (10/24/2010)

    GilaMonster (10/23/2010)

    Personally I learnt SSIS with almost no reference to the docs (other than some of the SSIS expression 'language' and some error handling practices)

    I did, however, play...

    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

    October 24, 2010 at 11:17 am

    #1241342

  • RE: SSRS Question NLB

    Thread continues here: http://www.sqlservercentral.com/Forums/Topic1009319-1632-1.aspx

    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

    October 23, 2010 at 3:38 am

    #1241257

  • RE: Are the posted questions getting worse?

    Personally I learnt SSIS with almost no reference to the docs (other than some of the SSIS expression 'language' and some error handling practices)

    I did, however, play around with it...

    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

    October 23, 2010 at 3:32 am

    #1241255

  • RE: what makes people learn new languages?

    bitbucket-25253 (10/22/2010)

    Not one of those guys .. that is straight out of college, but have been around long enough to know, that if you are not learning new technologies, you...

    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

    October 23, 2010 at 3:30 am

    #1241254

  • RE: Stumped

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/FindPost1009289.aspx

    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

    October 23, 2010 at 3:13 am

    #1241252

  • RE: Create a policy to avoid backups withou copy_only option

    Wildcat (10/22/2010)

    If you issue a FULL backup C without COPY_ONLY between A and B, then, you break the previous log chain A to B.

    Right?

    Wrong.

    Full backups do not and never...

    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

    October 23, 2010 at 3:11 am

    #1241251

  • RE: Stumped

    rgreenva (10/22/2010)

    Apologies on posting this in the SQL Server 2005 forum. I missed the header when I started the thread. I have opened a post in the SQL...

    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

    October 23, 2010 at 3:06 am

    #1241250

  • RE: Average Salary

    Please note: 2 year old thread.

    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

    October 22, 2010 at 10:15 am

    #1241038

  • RE: Stumped

    What's the exact output of DBCC OPENTRAN?

    Please post SQL 2000 questions in the SQL 2000 forums in future. Posted in the 2005 forums and you'll get answers that use 2005...

    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

    October 22, 2010 at 9:32 am

    #1241010

  • RE: Are the posted questions getting worse?

    I love this reply from one of the regulars over at SQLTeam

    Have a look at your post and then think about if we can understand what you want...

    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

    October 22, 2010 at 9:12 am

    #1240993

  • RE: time difference the rows in the same table...

    The second half of that is a CTE, which is not available in SQL 2000. You're going to have to rewrite this section to not use the CTE

    with k 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

    October 22, 2010 at 8:57 am

    #1240984

  • RE: Automatically check results of DBCC CHECK DB

    SwayneBell (10/22/2010)

    (I'm working on determining how often "often enough" is, but we can set that aside for the moment).

    How long do you retain your backups for?

    If you retain full 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

    October 22, 2010 at 8:42 am

    #1240965

  • RE: Create a policy to avoid backups withou copy_only option

    Correct. No full backup (with or without copy_only) breaks the log chain.

    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

    October 22, 2010 at 8:24 am

    #1240950

  • RE: Need to change the order of columns in the primary key nonclustered index

    Drop any foreign keys referencing this table

    Drop the primary key

    Recreate the pk in the desired order

    Recreate the foreign keys

    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

    October 22, 2010 at 3:18 am

    #1240779

  • RE: MCITP without MCTS Certification

    You can take the MCITP exams without writing the MCTS (I did for one) but you won't have the certification until you also write and pass the MCTS.

    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

    October 22, 2010 at 3:15 am

    #1240778

Viewing 15 posts - 29,776 through 29,790 (of 49,552 total)