Forum Replies Created

Viewing 15 posts - 29,521 through 29,535 (of 49,552 total)

  • RE: 2005 instance on 2008 Front end

    goodguy (11/7/2010)

    When we are coding, we like to keep all other connections as simple and generic as possible, and you will be amazed that most programmers' implementation of SQL Server...

    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

    November 7, 2010 at 5:46 am

    #1247448

  • RE: Where in @someString

    ashkan siroos (11/7/2010)

    Cause I think when you join two tables one with a million row and other with about 1k rows , it will take more calculation than just a...

    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

    November 7, 2010 at 3:55 am

    #1247446

  • RE: How to get name field

    Either all in the group by, or have a subquery (in the from clause) that queries and aggregates Orders and joins that to Customers.

    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

    November 7, 2010 at 2:45 am

    #1247444

  • RE: 2005 instance on 2008 Front end

    goodguy (11/7/2010)

    I don't know what I may have I messed up during the install; of course I am not very expert on all the arcane options about named instances, pipes,...

    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

    November 7, 2010 at 2:39 am

    #1247443

  • RE: database snapshot

    p.brat.23 (11/6/2010)

    Thanks for the update.

    In our case, data file is 96% used and we are getting alerts as it crossed the threshold.

    The source database or the snapshot?

    So in and all,...

    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

    November 7, 2010 at 2:36 am

    #1247442

  • RE: Missing NDF File

    da-zero (11/6/2010)

    Throw the database away and start with a clean slate.

    Not funny in a disaster situation.

    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

    November 6, 2010 at 1:32 pm

    #1247416

  • RE: Missing NDF File

    Can you please be more specific about the scenario?

    Is this a file in the primary filegroup? Or is it a file a file in a secondary filegroup?

    What edition of SQL?

    Is...

    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

    November 6, 2010 at 1:32 pm

    #1247415

  • RE: 2005 instance on 2008 Front end

    goodguy (11/6/2010)

    It seems there is no guarantee that Uninstall does what it is supposed to.

    You must have either done something odd or the uninstaller failed with an error and 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

    November 6, 2010 at 1:01 pm

    #1247413

  • RE: Date Question

    Pulivarthi Sasidhar (11/6/2010)

    take care abt DateTime storing in table and comparison/condition also in same format 103/101/ yyyy-mm-dd

    Only if the column is actually a varchar (which is a seriously bad idea)....

    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

    November 6, 2010 at 12:12 pm

    #1247409

  • RE: Where in @someString

    ashkan siroos (11/6/2010)

    But As you know it will be to really slow to join 2 tables VS select one table where parameter in 'some values'

    It is? Got hard numbers...

    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

    November 6, 2010 at 12:00 pm

    #1247407

  • RE: How to get name field

    There are, but they require subqueries. Why are you concerned about having the name in the group by?

    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

    November 6, 2010 at 11:55 am

    #1247406

  • RE: 2005 instance on 2008 Front end

    goodguy (11/6/2010)

    I want to remove the 2005 instance and create a new 2008 instance. What should I do?

    Either uninstall 2005, locate a 2008 DVD and install from there or locate...

    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

    November 6, 2010 at 11:54 am

    #1247405

  • RE: database snapshot

    Database snapshots are read only. Completely

    That said, it's highly unlikely that the snapshot is taking the full 25GB. Snapshots use sparse file technology where the file is only as big...

    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

    November 6, 2010 at 11:51 am

    #1247404

  • RE: i want to deploy 2008 RDL's to 2005 RS. is this possible??

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1016856-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

    November 6, 2010 at 2:09 am

    #1247396

  • RE: Clustered Index and Striping

    biju.pad (11/5/2010)

    1. Relevant index pages are brought into memory.

    2. The pages are inspected and we retrieve a bunch of RIDs.

    3. We next bring in all the pages associated with...

    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

    November 6, 2010 at 2:07 am

    #1247395

Viewing 15 posts - 29,521 through 29,535 (of 49,552 total)