Forum Replies Created

Viewing 15 posts - 256 through 270 (of 1,162 total)

  • RE: BI License

    Not sure I follow. I thought it followed the same sort of terms as the Enterprise CAL licenses in 2008? E.g. you buy CALS for the number of users who...

  • RE: SQL 2008 CLustering

    Whilst it's not an absolute requirement to have matching hardware for servers in the cluster, it is recommended and makes configuration easier in general. I've never heard of people using...

  • RE: Math operation debugging

    SQL Kiwi (12/4/2012)


    We should all switch to Oracle immediately!

    LOL

    It would make answering questions on the forum easier. We could just patronisingly point everyone to the homepage for Oracle documentation in...

  • RE: Math operation debugging

    bleroy (12/4/2012)


    For Information purposes only, copy/pasted your SQL and then added FROM dual; at the end to run it in Oracle and got the right answer without any further manipulations:

    4020.73315

    (running...

  • RE: SQL Server process growing memory usage

    SQL Server will eventually use all the memory allocated to it. It doesn't ever really de-allocate memory, it will just move the oldest cached data out as it needs to...

  • RE: Yet another question about log files!

    Abu Dina (11/13/2012)

    Also, can I just confirm that by shrinking the log file from 26GB to 1GB for example, my backup will also reduce by the same size?

    No. Backups do...

  • RE: Yet another question about log files!

    Assuming that the growth to 36GB was an unusual activity or was caused when it was in FULL Recovery Model and TLog backups weren't being run, then yes, a one...

  • RE: Permission Denied

    I seem to remember there are circumstances after an initial install where you have to open Internet Explorer with the "Run as Administrator" option, then browse to the server locally...

  • RE: Retention Period for Queries Executed

    sys.dm_exec_query_stats

    Returns aggregate performance statistics for cached query plans in SQL Server 2012. The view contains one row per query statement within the cached plan, and the lifetime of the rows...

  • RE: What are reading now?

    GilaMonster (10/18/2012)


    If you enjoy that, look up the Iron Druid series (Hounded is I think the first book). Similar style.

    Thanks Gail. Added to the list!

  • RE: What are reading now?

    Just finished Proven Guilty (Dresden Files) by Jim Butcher. Really enjoying this series. It's not high fiction, by any means, but as an easy reading escape whilst work's hectic it...

  • RE: Connecting to Oracle from SQL 2012 Visual Studio 2010 Shell

    I'm not sure if anything has changed in 2012, but in 2008, BIDS/Visual Studio will only run debug in 32-bit, so you need the 32-bit drivers installed as well to...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/3/2012)


    HowardW (10/2/2012)


    Anyone else eagerly awaiting this?

    Have to say, getting increasingly irate about e-book pricing. Why do I have to pay 50p more, given all the costs of printing,...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/2/2012)


    HowardW (10/2/2012)


    Anyone else eagerly awaiting this?

    Not quite as eagerly as I would have been 10 years or so ago when Banks was setting new ground with his Culture series....

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (10/2/2012)


    Not me. Banks is over-rated and over-priced. I'll wait until I can pick up a (paper) copy for £2 or less in a charity shop,...

Viewing 15 posts - 256 through 270 (of 1,162 total)