Forum Replies Created

Viewing 15 posts - 32,731 through 32,745 (of 49,552 total)

  • RE: How to group if there is nothing to aggregate

    mathewspsimon (5/26/2010)

    yes i am working on 2005 but dont have much idea about the newer stuff.

    Then look at this as an opportunity to get familiar with one of the 'newer'...

    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

    May 26, 2010 at 7:05 am

    #1172678

  • RE: Index on IDENTITY column

    karthikeyan-444867 (5/26/2010)

    First, what actually makes you say that and why are you "sure"?

    I read like 'Don't create clustered index on monotonically increasing column' some years back.

    I take it you didn'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

    May 26, 2010 at 5:50 am

    #1172623

  • RE: Index on IDENTITY column

    karthikeyan-444867 (5/26/2010)

    int identity for a primary key is nothing but unique clustered index.???

    By default 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

    May 26, 2010 at 5:38 am

    #1172618

  • RE: How to group if there is nothing to aggregate

    Look up PIVOT. Start with the SQL Books Online (sql help file)

    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

    May 26, 2010 at 5:05 am

    #1172597

  • RE: syntax error in query

    Insert... values cannot have a where clause, as there's no query to apply that where 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

    May 26, 2010 at 5:04 am

    #1172596

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    Jeff Moden (5/26/2010)

    Ken Lee-263418 (5/25/2010)

    2. You can build covering indexes for every selection criteria you use that starts with SampleDateTime as the first index field (The first covering index 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

    May 26, 2010 at 5:02 am

    #1172595

  • RE: Need help with 70-431 practice

    Oksana March (5/26/2010)

    GilaMonster (5/25/2010)

    Oksana March (5/25/2010)

    Or in other words, is it possible to see a list of ALL possible questions that may be in the exam?

    I know memorizing the answers...

    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

    May 26, 2010 at 3:11 am

    #1172546

  • RE: Partitioning column value range based on master table field?

    Thread continues here - http://www.sqlservercentral.com/Forums/Topic927956-360-1.aspx

    No further replies to this thread please.

    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

    May 26, 2010 at 1:32 am

    #1172504

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    Ken Lee-263418 (5/25/2010)

    1. All binary trees of all indexes only keep the first field defined in the index.

    Maybe I'm misunderstanding you, but...

    If you have a composite index (index defined on...

    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

    May 26, 2010 at 1:23 am

    #1172500

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    don.schaeffer (5/25/2010)

    I've just been testing fragmentation on a table that has a clustered index on a guid (ouch!), not my design. But I've found that with an appropriate fill...

    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

    May 26, 2010 at 1:17 am

    #1172497

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/25/2010)

    Trey Staker (5/25/2010)

    Steve Jones - Editor (5/25/2010)

    I don't understand how he got any degree with the lack of desire/ability to look things up himself.

    It may just be 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

    May 25, 2010 at 2:33 pm

    #1172351

  • RE: Are the posted questions getting worse?

    From http://www.sqlservercentral.com/Forums/Topic927200-338-1.aspx

    lmu92 (5/25/2010)

    I'm confused....

    If you can't explain the benefits of the fine tuning we you did, then why there was a need for tuning in the first place?

    😀 :hehe: :w00t:...

    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

    May 25, 2010 at 2:13 pm

    #1172340

  • RE: If Exists/If Not Exists

    Start with this - http://msdn.microsoft.com/en-us/library/ms188336.aspx. The performance stuff that I wrote (link Lutz posted) can wait until you understand what they do.

    Once you've gone through that (and experimented with code),...

    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

    May 25, 2010 at 2:12 pm

    #1172338

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (5/25/2010)

    I don't understand how he got any degree with the lack of desire/ability to look things up himself.

    Damned if I know.

    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

    May 25, 2010 at 11:00 am

    #1172239

  • RE: Logon Trigger Not Acting As Expected

    Howard.Veazey (5/25/2010)

    BTW...On the RAISEERROR that you originally said was not firing...It won't...The reason is the logon trigger fires *after* authentication but *before* actual connection, so it can't fire...

    It will fire.

    The...

    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

    May 25, 2010 at 10:48 am

    #1172232

Viewing 15 posts - 32,731 through 32,745 (of 49,552 total)