Forum Replies Created

Viewing 15 posts - 29,401 through 29,415 (of 49,552 total)

  • RE: Turn off Predictive Typing

    Personally I find the SSMS built in intellisense terrible. I spend more time fixing what it thought I meant than I would have spent just writing the query. A certain...

    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 12, 2010 at 4:58 am

    #1249921

  • RE: STATS_DATE return NULL

    Are there any rows in the table?

    What's the index_id for that item?

    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 12, 2010 at 4:57 am

    #1249919

  • RE: Are the posted questions getting worse?

    Henrico Bekker (11/12/2010)

    another one....

    http://www.sqlservercentral.com/Forums/Topic1019796-1550-1.aspx?Update=1

    What's wrong with that question?

    It's far more than just putting the server name in. There's all the VPN tools and remote access permissions to install and configure....

    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 12, 2010 at 4:53 am

    #1249917

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/11/2010)

    I have a few articles that I am finishing up currently.

    Topics?

    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 12, 2010 at 4:49 am

    #1249914

  • RE: How do I connect to SQL Server remotely ?

    Do you have a VPN configured? Some way to access your company's network from home? If not then you will need to speak with the appropriate people at your company...

    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 12, 2010 at 4:49 am

    #1249913

  • RE: Are the posted questions getting worse?

    WayneS (11/11/2010)

    Everyone thought that table variables were 1. memory-only, 2. did no logging, and 3. had no indexes. Now, about 20 more people know better.

    And I thought the 'no logging'...

    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 12, 2010 at 1:40 am

    #1249871

  • RE: Duplicate Index Performance

    GSquared (11/11/2010)

    SQL's smarter than that if the second index has the clustered index columns in the same order as they are in the clustered index, and adjacent to each other....

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

    #1249757

  • RE: Shrink Database Issue - Not enough free space/log in use.

    The messages are telling you that

    1) The data file has no free space in it

    2) All the logical sections of the log file are in use (full and needed)...

    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 11, 2010 at 2:23 pm

    #1249737

  • RE: Duplicate Index Performance

    Now let's see about that large index...

    Setup:

    CREATE TABLE TestingIndexes (

    ID int identity not null primary key,

    SomeCol Char(8) not null,

    RandDate datetime not null,

    Filler1 char(880) not null,

    Filler2 char(500)

    )

    create nonclustered index idx_Testing_Wide

    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

    November 11, 2010 at 1:50 pm

    #1249722

  • RE: Are the posted questions getting worse?

    WayneS (11/11/2010)

    Well, I'm off to give my first presentation of "Comparing Tables Variables and Temporary Tables" to my UG tonight. Wish me good tidings, smooth talk, and all the other...

    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 11, 2010 at 1:36 pm

    #1249716

  • RE: Are the posted questions getting worse?

    Nor here any longer. Guess the results are no longer 'latest'

    Just a list of several people retweeting and/or agreeing with Grant's initial tweet

    From @SQLintheWild : Yea though I walk through...

    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 11, 2010 at 1:28 pm

    #1249711

  • RE: Duplicate Index Performance

    Proof:

    CREATE TABLE TestingIndexes (

    ID int identity not null,

    SomeCol Char(10),

    RandDate datetime,

    Filler char(200)

    )

    create unique clustered index idx_Testing_ID on TestingIndexes (ID, SomeCol)

    create nonclustered index idx_Testing_Wide on TestingIndexes (RandDate, SomeCol, ID) -- entire cluster...

    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 11, 2010 at 1:22 pm

    #1249703

  • RE: Duplicate Index Performance

    GSquared (11/11/2010)

    Another way is to have a multi-column clustered index, and to include those same columns in a non-clustered index. Since the clustered index is automatically included, duplicating 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

    November 11, 2010 at 1:01 pm

    #1249686

  • RE: Ok i'm stumped...

    nm

    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 11, 2010 at 12:13 pm

    #1249662

  • RE: Are the posted questions getting worse?

    http://twitter.com/#!/GFritchey/status/2742141222658049

    and

    http://www.google.com/search?hl=en&tbo=1&tbs=rltm%3A1&q=sqlinthewild+%22Yea+though+I+walk%22+site%3Atwitter.com&aq=f&aqi=&aql=&oq=&gs_rfai=

    Kinda...

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

    #1249640

Viewing 15 posts - 29,401 through 29,415 (of 49,552 total)