Forum Replies Created

Viewing 15 posts - 9,316 through 9,330 (of 14,953 total)

  • RE: Linked Servers: SQL Native vs OLE DB Provider

    Antero Ruiz (6/9/2009)


    Thanks GSquared. The script is useful but what what I need is to force the provider to be OLEDB and not SQL native client... do you know what...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/9/2009)


    Lynn Pettis (6/9/2009)


    He is obviously new to SQL Server and really needs to start doing some research instead of asking such broad based questions like this one.

    But then...

  • RE: SSL option

    Krasavita (6/9/2009)


    I need to know if SQL Server can communicate with other applications.

    Thank you

    You're kidding, right? What use would a database be if it couldn't communicate with other applications?

    Going...

  • RE: Should you use your full name as a username?

    I use "GSquared" because it's a nickname I ended up with in 9th grade algebra, based on my initials. Nothing to hide, nothing to show, just more fun that...

  • RE: Forums on your Resume/CV

    I have mention of it in my resume. It was ignored by one manager, and helped me get interviewed by two others. Both of those commented that reading...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/9/2009)


    Just seems a bit out of my usual SSC character. I'm usually the one trying to everything I can to help people and then I lmgtfy twice...

  • RE: Fixing Fragmentation After Shrinking

    GilaMonster (6/9/2009)


    GSquared (6/9/2009)


    Besides, it's necessary, since the indexes point to actual disk locations, and having them point to incorrect sectors isn't a good thing.

    ?????

    As far as I'm aware, nothing within...

  • RE: Architecture Dilemma

    That's the direction I'd go in, too.

    One common database with core, non-sensitive material. One database per customer.

    You can put a copy of the common database on the servers for...

  • RE: Software Giants

    I just hope that whole R&D budget wasn't to come up with "Bing". (Which I've tried, and like just fine, but its chances of accomplishing any serious move in...

  • RE: Fixing Fragmentation After Shrinking

    No. It won't undo the shrink. Adding data, adding indexes, etc., would do so. Rebuilding them shouldn't be a significant problem. Besides, it's necessary, since the...

  • RE: Linked Servers: SQL Native vs OLE DB Provider

    Here's the script I use to create linked servers to SQL Server, when I want the name to be something other than the actual name of the server or instance.

    --...

  • RE: Fixing Fragmentation After Shrinking

    Indexes need to be rebuilt after physical defragmentation, per Microsoft.

  • RE: Architecture Dilemma

    3. Need one common database the maintains the data for all the clients.

    4. Each client decides where the database should reside. Either with in my company's data center or within...

  • RE: Recursive Triggers

    I'm having trouble visualizing your data structure from the sample you gave. For one thing, what's a "Job" in this case? How does it relate to a "Part...

  • RE: execute as owner

    Search for "impersonation" in BOL. There's a whole section about it. It has all the data in there.

    I really can't be more specific. I haven't run into...

Viewing 15 posts - 9,316 through 9,330 (of 14,953 total)