Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 2,838 total)

  • RE: Partitioning strategies for 18tb ++++ database,

    zach_john (4/28/2011)

    My database has three tables that will be around 5-6tb, another 1tb in all other tables(12). All tables grow 550GB per month. The primary key is a GUID it...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 28, 2011 at 10:30 am

    #1317390

  • RE: Insertion using linked server.

    krishnaroopa, that might be a good solution that you have there or you might want to use another technology like Mirroring, Log Shipping, Messaging or something else. Or it might...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 28, 2011 at 7:50 am

    #1317264

  • RE: SQL Server Replication alternatives

    Rog Saber (4/27/2011)

    How would "Merge Replication" work? Is it reliable? What is the potential for data conflict pushing and pulling.

    What limits would we run in to running the Express edition?

    This...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 3:13 pm

    #1316932

  • RE: SQL Server Replication alternatives

    opc.three (4/27/2011)

    Rog Saber (4/27/2011)

    We have a customer which connects to our servers through Citrix. However, they have a major concern that the facilities in which they want to run our...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 3:10 pm

    #1316928

  • RE: Are the posted questions getting worse?

    GilaMonster (4/27/2011)

    Brandie Tarvin (4/27/2011)

    GilaMonster (4/26/2011)

    I don't do epic verse.

    Though... (read attached at your own risk, very amateur attempt)

    Wow. Gail, I loved the ice spirit story. That's beautiful and deserves a...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 3:03 pm

    #1316922

  • RE: SQL Server Replication alternatives

    [Jim].[dba].[Murphy] (4/27/2011)

    Stefan Krzywicki (4/27/2011)

    If the 30 tables they'd have would amount to less than 2 gig you should look into SQL Server Express and see if the licensing allows you...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 2:54 pm

    #1316916

  • RE: SQL Server Replication alternatives

    Rog Saber (4/27/2011)

    The database is not huge but it's not small either. However, to run their application we're probably only talking about 30 tables which is not big at all.

    As...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 1:32 pm

    #1316855

  • RE: X in query

    PHXHoward (4/27/2011)

    It does not work without the X. I don't understand in what part of the query execution it is referencing the subquery by alias.

    It is the entire outer query....

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 1:24 pm

    #1316847

  • RE: X in query

    This is simply giving an alias to a subquery so it can be referenced by the outer query. Try running it without the "X" and see what you get. Sometimes...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 1:15 pm

    #1316837

  • RE: SQL Server Replication alternatives

    Rog Saber (4/27/2011)

    We have a customer which connects to our servers through Citrix. However, they have a major concern that the facilities in which they want to run our applications,...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 1:12 pm

    #1316834

  • RE: Less Pay, More Convenience

    Peter Maloof (4/27/2011)

    GilaMonster (4/27/2011)

    Any wonder she doesn't let me work away from the office?

    If you were a little under the weather, would your manager expect you to:

    A. Telecommute, and do...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 11:26 am

    #1316779

  • RE: Less Pay, More Convenience

    Ninja's_RGR'us (4/27/2011)

    Stefan Krzywicki (4/27/2011)

    Steve Jones - SSC Editor (4/27/2011)

    Stefan Krzywicki (4/27/2011)

    Sure, these are all just my anecdotes, but they're what inform my perception of the state of management today. I've...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 11:25 am

    #1316777

  • RE: Less Pay, More Convenience

    Steve Jones - SSC Editor (4/27/2011)

    Stefan Krzywicki (4/27/2011)

    Sure, these are all just my anecdotes, but they're what inform my perception of the state of management today. I've also had some...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 11:10 am

    #1316767

  • RE: Less Pay, More Convenience

    Dan.Humphries (4/27/2011)

    I for one would love to get in a position where I could work from home. There is absolutley nothing I do now that I could not...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 10:43 am

    #1316747

  • RE: Less Pay, More Convenience

    Steve Jones - SSC Editor (4/27/2011)

    Stefan Krzywicki (4/27/2011)

    That mindset is unlikely to go anywhere. Many managers know that if they're not keeping an eye on the workers, they have nothing...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    April 27, 2011 at 10:32 am

    #1316741

Viewing 15 posts - 1,816 through 1,830 (of 2,838 total)