Forum Replies Created

Viewing 15 posts - 31,771 through 31,785 (of 49,552 total)

  • RE: CXPACKET wait

    Please post new questions in a new thread. It's unlikely that many people will look at this because it looks, from the number of posts, as if it's answered.

    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 17, 2010 at 4:07 am

    #1194494

  • RE: all the type of indexes in MS-SQL Server

    You've forgotten two. Hit google and search for index SQL Server, you should be able to find the last two.

    Also, unique index is not as type of index. It's just...

    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 17, 2010 at 4:07 am

    #1194493

  • RE: SQL 2005 DB recovery

    Full recovery and completely lost both mdf and ldf?

    Only if there was a full backup at least, preferably full and log backups.

    Bottom line. No backups, no recovery.

    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 17, 2010 at 4:05 am

    #1194492

  • RE: Clustered Index & Non Clustered Index

    Have a read through this, see if it helps - http://www.sqlservercentral.com/articles/Indexing/68439/

    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 16, 2010 at 3:29 pm

    #1194396

  • RE: Are the posted questions getting worse?

    george sibbald (7/16/2010)

    As someone in the northern hemisphere that sounds seriously weird. to get the sun we face south. If I bought a house down there on spec I...

    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 16, 2010 at 3:16 pm

    #1194389

  • RE: REBUILDING LOG

    Please note: 4 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

    July 16, 2010 at 2:54 pm

    #1194371

  • RE: MCTS 2008 Training Kit Question

    hxkresl (7/16/2010)

    in the case of a column with FILESTREAM property the file is stored on the filesystem by human intervention.

    No. How you insert a document into a varbinary...

    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 16, 2010 at 2:43 pm

    #1194365

  • RE: Passed 70-442

    Duncan Pryde (7/16/2010)

    Ah, makes sense. I just couldn't see how you would want to sit, let alone expect to pass a SQL MCITP exam with no experience.

    Oh it wasn't...

    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 16, 2010 at 1:00 pm

    #1194313

  • RE: MCTS 2008 Training Kit Question

    http://msdn.microsoft.com/en-us/library/bb933993%28SQL.100%29.aspx

    http://msdn.microsoft.com/en-us/library/cc949109%28SQL.100%29.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

    July 16, 2010 at 12:59 pm

    #1194311

  • RE: Passed 70-442

    Duncan Pryde (7/16/2010)

    Wow, kudos to you!

    Not really. The thing was so incredibly easy I think anyone with a passing knowledge of sharepoint and logical deductions could have passed. I scored...

    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 16, 2010 at 12:38 pm

    #1194294

  • RE: Transaction Partially Commits

    There's no error handling in that code. Hence any one of those statements could fail and, providing the error isn't severe enough to terminate the connection or terminate the batch,...

    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 16, 2010 at 11:53 am

    #1194263

  • RE: System tables are too big

    How are you measuring memory usage?

    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 16, 2010 at 11:32 am

    #1194256

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/16/2010)

    Call me a spoiled American, but if it were only 46F in my house in the middle of the winter, there is a serious problem with our furnace...

    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 16, 2010 at 11:32 am

    #1194255

  • RE: Passed 70-442

    Duncan Pryde (7/16/2010)

    I did think it was amusing that one of the answers to each of the questions was along the lines of "I've never used SQL Server before", 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

    July 16, 2010 at 10:57 am

    #1194230

  • RE: MCTS 2008 Training Kit Question

    Really it depends on application, what the file is, how it's going to be used, how often it'll be updated, size of files, size of backups, etc. Not a clearcut...

    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 16, 2010 at 10:56 am

    #1194229

Viewing 15 posts - 31,771 through 31,785 (of 49,552 total)