Forum Replies Created

Viewing 15 posts - 31,471 through 31,485 (of 49,552 total)

  • RE: GROUP BY Vs DISTINCT

    No. check the exec plans. They're identical.

    Personal preference - if distinct rows are wanted, use distinct. If aggregates are needed grouped by one or m ore columns, use 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

    August 3, 2010 at 6:23 am

    #1201467

  • RE: move files to different file group

    I don't believe you can move files from one filegroup to another.

    With all the files in one filegroup, that table is spread across all of them. Tables may only...

    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

    August 3, 2010 at 4:29 am

    #1201438

  • RE: The INSERT permission was denied on the object <Tablename>, <database >, schema 'dbo'.

    So ask the DBA to run it.

    Difference could be related to data volumes, stats that haven't been updated, difference in schema, etc.

    Have you run the procedure from management studio 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

    August 3, 2010 at 4:25 am

    #1201435

  • RE: Need help in creating useful index

    An index scan is the best that query can do. You're asking for the entire table aggregated. Hence it has to scan something. Better a nonclustered index than the cluster.

    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

    August 3, 2010 at 4:05 am

    #1201422

  • RE: The INSERT permission was denied on the object <Tablename>, <database >, schema 'dbo'.

    vatha.meba (8/3/2010)

    The scenario is there is a thread that works in the background in vb.net code which calls a stored procedure which does the insert.

    Earlier it use to take 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

    August 3, 2010 at 4:03 am

    #1201420

  • RE: How the data will be distributed to the secondary file?

    SQL uses a proportional fill algorithm where the amount of data written to the files in the filegroup is proportional to the amount of free space in the files.

    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

    August 2, 2010 at 11:28 pm

    #1201355

  • RE: RESTORE IN SQL 2005

    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

    August 2, 2010 at 11:18 pm

    #1201352

  • RE: Question to Experts

    Steve Jones - Editor (8/2/2010)

    Jonathan Kehayias (8/2/2010)

    I don't definitively know why Microsoft made the engine work that way...g.

    Bug, crappy programming and testing.

    In this case, design decision, intended behaviour.

    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

    August 2, 2010 at 11:14 pm

    #1201349

  • RE: Question to Experts

    Leo.Miller (8/2/2010)

    An odd bit of behaviour I've noted with dropping databases is that, if the database is OffLine when you drop it, the physical files are not deleted.

    It's not odd...

    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

    August 2, 2010 at 11:13 pm

    #1201347

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/2/2010)

    GilaMonster (8/2/2010)

    Stefan Krzywicki (8/2/2010)

    Roy Ernest (8/2/2010)

    Five heads are better than two... Or so they think.. 🙂 That is why they prefer to take 5 not so good personnel...

    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

    August 2, 2010 at 4:24 pm

    #1201296

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (8/2/2010)

    GilaMonster (8/2/2010)

    Stefan Krzywicki (8/2/2010)

    Roy Ernest (8/2/2010)

    Five heads are better than two... Or so they think.. 🙂 That is why they prefer to take 5 not so good personnel (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

    August 2, 2010 at 4:12 pm

    #1201292

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/2/2010)

    Roy Ernest (8/2/2010)

    Five heads are better than two... Or so they think.. 🙂 That is why they prefer to take 5 not so good personnel (that comes cheap)...

    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

    August 2, 2010 at 3:53 pm

    #1201287

  • RE: Question to Experts

    raamaakrishna (8/2/2010)

    Hi Gail, Can you please find out what api is called?

    Looks like it's the DeleteFile function in Kernel32, so nothing special.

    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

    August 2, 2010 at 3:49 pm

    #1201283

  • RE: Are the posted questions getting worse?

    bteraberry (8/2/2010)

    ... so even if they need 15 hrs/week they would rather pay $150+ in consulting than to hire someone at a reasonable rate.

    Suits me. 😀

    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

    August 2, 2010 at 3:06 pm

    #1201266

  • RE: Question to Experts

    raamaakrishna (8/2/2010)

    If we know exactly what command is being run to delete those files may be we can recover the database even though we do not have backups...

    You'd need 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

    August 2, 2010 at 2:21 pm

    #1201243

Viewing 15 posts - 31,471 through 31,485 (of 49,552 total)