Forum Replies Created

Viewing 15 posts - 2,761 through 2,775 (of 7,164 total)

  • RE: Alternative to views

    GSquared (11/21/2012)

    opc.three (11/20/2012)

    GSquared (11/20/2012)

    opc.three (11/19/2012)

    GSquared (11/19/2012)

    Keep in mind, with synonyms, that accessing a synonym is the same as accessing a table directly. If your security policy is to disallow...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 21, 2012 at 8:48 am

    #1561279

  • RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

    Why do you need randomness in your UUID?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2012 at 7:27 pm

    #1561069

  • RE: Today's Random Word!

    Ray K (11/20/2012)

    The Dixie Flatline (11/20/2012)

    FUBAR

    rebar

    Babar

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2012 at 10:48 am

    #1560934

  • RE: Has tempdb grown since the last restart?

    Caruncles (11/20/2012)

    Here are the results. Looks like quite a difference from the intital settings.

    namedb_filename ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2012 at 9:24 am

    #1560882

  • RE: Alternative to views

    GSquared (11/20/2012)

    opc.three (11/19/2012)

    GSquared (11/19/2012)

    Keep in mind, with synonyms, that accessing a synonym is the same as accessing a table directly. If your security policy is to disallow accessing tables...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2012 at 9:10 am

    #1560873

  • RE: Has tempdb grown since the last restart?

    james.johnson 22741 (11/20/2012)

    When I tried to modify the size of the tempdb on my system the results suggested that I was unable to specify the size of something smaller than...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2012 at 8:57 am

    #1560865

  • RE: Has tempdb grown since the last restart?

    Caruncles (11/20/2012)

    Would timing-out errors be a symptom of improper TempDB settings? Especially, during peak times. We are in our busy season right now there is a lot...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2012 at 8:35 am

    #1560840

  • RE: Has tempdb grown since the last restart?

    dineshvishe (11/20/2012)

    tempdbtempdevN:\Tempdb\tempdb.mdf446.50719.19 10%272.69

    tempdbtemplogN:\Tempdb\templog.ldf294.38294.38 50%0.00

    can this data is proper ???

    It seems plausible. It appears tempdev has grown...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2012 at 8:31 am

    #1560838

  • RE: Has tempdb grown since the last restart?

    sql.com (11/20/2012)

    Can you use Extended Events to track TempDB growth? I have read Jonathan Kehayias's article on tracking database growth, I wonder if that can be applied to tempdb too?

    p.s....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2012 at 8:30 am

    #1560835

  • RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

    dave-L (11/19/2012)

    Thanks for all the comments. I have one more idea for addressing this. I'm thinking about partitioning my table. Everything that has already been created with...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 19, 2012 at 10:04 pm

    #1560602

  • RE: VPN access for vendor, multiple instance

    Lowell has covered the database-level concerns well. All I'll add, at the server-level, is if you are concerned about the new vendor seeing databases other than their own when using...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 19, 2012 at 5:28 pm

    #1560575

  • RE: Alternative to views

    GSquared (11/19/2012)

    Keep in mind, with synonyms, that accessing a synonym is the same as accessing a table directly. If your security policy is to disallow accessing tables directly, then...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 19, 2012 at 2:25 pm

    #1560520

  • RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

    Jeff Moden (11/17/2012)

    opc.three (11/16/2012)

    You'll have to test because as usual, it will depend on your workload and data. Here is a great place to start:

    Does Index Fragmentation Matter with SSD’s?

    Apologies......

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 17, 2012 at 7:51 am

    #1560004

  • RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

    You'll have to test because as usual, it will depend on your workload and data. Here is a great place to start:

    Does Index Fragmentation Matter with SSD’s?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 16, 2012 at 1:31 pm

    #1559930

  • RE: Alternative to views

    dwain.c (11/15/2012)

    opc.three (11/15/2012)

    Linked Servers are useful for server-to-server communication but if you're just needing to communicate from one database to another on the same instance then Linked Servers would not...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 16, 2012 at 7:42 am

    #1559823

Viewing 15 posts - 2,761 through 2,775 (of 7,164 total)