Forum Replies Created

Viewing 15 posts - 166 through 180 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/7/2015)


    Stefan Krzywicki (1/7/2015)


    Wow, that's a complete disaster. I wouldn't just be "downloading data to make sure I had access during the...

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

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    Wayne West (1/7/2015)


    It's always interesting, starting out like that and learning new things. Access is a good tool and I use it a lot as my front-end to talk...

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

  • RE: Are the posted questions getting worse?

    Wow, that's a complete disaster. I wouldn't just be "downloading data to make sure I had access during the outage" I'd be...

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

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    IncidentalProgrammer (1/6/2015)


    Grant Fritchey (1/6/2015)


    IncidentalProgrammer (1/6/2015)


    Along with a schedule of backups, I got this from the big DBA at corporate, so I think I'm set on backups:

    "The full backups would be...

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

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    The link I gave you for the data types is part of Microsoft's Book On Line for SQL Server. That and TechNet are two great resources for you, but they...

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

  • RE: Are the posted questions getting worse?

    Happy New Year everyone!

    Who, like me, is at work today?

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

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    IncidentalProgrammer (12/29/2014)


    Stefan Krzywicki (12/29/2014)


    IncidentalProgrammer (12/29/2014)


    Stefan Krzywicki (12/29/2014)


    I've dealt with Access databases that reach that 2GB limit. You're going to want to switch long before you reach that limit since Access...

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

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    GilaMonster (12/30/2014)


    IncidentalProgrammer (12/29/2014)


    Fortunately, I won't have to worry about doing the backups in SQL, myself. Corporate backs everything up automatically on a daily basis, and I'm told that to restore,...

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

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    IncidentalProgrammer (12/29/2014)


    Stefan Krzywicki (12/29/2014)


    I've dealt with Access databases that reach that 2GB limit. You're going to want to switch long before you reach that limit since Access starts to slow...

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

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    IncidentalProgrammer (12/29/2014)


    Thanks so much for all the help! I've added links to my favorites, and am going to pick up some of those "accidental DBA" books (my cube is turning...

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

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    I just thought of something else.

    You might want to be doing some of the initial development/testing in SQL Server 2012 instead of in Access. It'll make it easier to learn...

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

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    When you switch Access to SQL Server and let the tool do the transfer, you can get really weird formatting of your TSQL. You might want to allocate some time...

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

  • RE: Starting from Scratch - How long to get the gist of SQL Server?

    I'd like to add that I got my start in IT by building small systems in Access or some programming languages while I was a secretary. That said, it was...

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

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (12/23/2014)


    Lynn Pettis (12/23/2014)


    Eirikur Eiriksson (12/23/2014)


    Lynn Pettis (12/23/2014)


    Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now....

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

  • RE: Warning: The join order has been enforced because a local join hint is used. ( two views )

    farrukhhameed786 (12/23/2014)


    Hi

    Thank you

    I removed the join hint form the statement by replacing below. The application having no breaking or fault.

    1.

    FROM [Test1].[dbo].ITEM_EVENT e,[Test1].[dbo].ITEM_PROPERTY p0

    WHERE e.ITEM_ID = p0.ITEM_ID

    2.

    ...

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

Viewing 15 posts - 166 through 180 (of 2,838 total)