Forum Replies Created

Viewing 15 posts - 166 through 180 (of 616 total)

  • RE: How much Ram required.

    Minnu (6/25/2013)


    How much of RAM is required to overcome High physical memory utilisation issue.

    What do you mean?!

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Another grouping problem

    ChrisM@Work (6/25/2013)


    Abu Dina (6/24/2013)


    ChrisM@Work (6/24/2013)


    Abu Dina (6/24/2013)


    This is still giving me problems! :unsure:

    DECLARE @pairs TABLE (dropped_id INT, retained_id INT)

    INSERT INTO @pairs

    SELECT 16492, 23011 UNION ALL

    SELECT 23011,24014 UNION ALL

    SELECT 23011,24951...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Another grouping problem

    ChrisM@Work (6/24/2013)


    Abu Dina (6/24/2013)


    This is still giving me problems! :unsure:

    DECLARE @pairs TABLE (dropped_id INT, retained_id INT)

    INSERT INTO @pairs

    SELECT 16492, 23011 UNION ALL

    SELECT 23011,24014 UNION ALL

    SELECT 23011,24951 UNION ALL

    SELECT 16492,24951...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Another grouping problem

    This is still giving me problems! :unsure:

    DECLARE @pairs TABLE (dropped_id INT, retained_id INT)

    INSERT INTO @pairs

    SELECT 16492, 23011 UNION ALL

    SELECT 23011,24014 UNION ALL

    SELECT 23011,24951 UNION ALL

    SELECT 16492,24951 UNION ALL

    SELECT 16492,29381...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Can mirroring be set up with a copy only backup?

    GilaMonster (6/20/2013)


    Abu Dina (6/20/2013)


    Basically you use it so that you don't break the backup chain so go for it!

    You mean 'don't reset the differential base', because that's all that a...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Can mirroring be set up with a copy only backup?

    Can mirroring be initialized with a copy only backup?

    From MSDN (http://msdn.microsoft.com/en-us/library/ms191495.aspx)

    Restoring a copy-only full backup is the same as restoring any other full backup.

    Basically you use it so that...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Remove NewLine Charachters on a Select All.

    You say:

    However a couple of the columns contain addresses with the NewLine Cahrachter embedded in it which is ruining my export to Excel

    So if it's just a couple of columns,...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: regarding restore problem

    Are you 100% sure you restored the correct backup?!

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Backup Automation

    Have a look at this: http://ola.hallengren.com/

    This is also great: http://www.sqlservercentral.com/articles/Backup+%2f+Restore/66564/

    In the end I ended up impleneting my own solution after being inspired by http://sql-ution.com/download-the-dba-repository/ and http://sqlmag.com/sql-server/dba-repository-2010

    This is the query I...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Problem Inserting records per Portfolio into a temp table

    Have you tried the code I provided above?!

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: RESTORE DATABASE is terminating abnormally.

    Do you have another backup file?

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Problem Inserting records per Portfolio into a temp table

    There is no need for a cursor to get the top 10 rows per port_portcode.

    Try this (not tested due to lack of sample data though)

    ;with cTE AS (SELECT Port_Portcode,

    Class_0_Minor_Description,...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Pull Data from diffrent servers - SSIS

    You haven't provided enough information Tony.

    Are you pulling data from multiple SQL instances/databases?

    Are the SQL instances within a trusted domain?

    I would look at using the Foreach Loop Container for this...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Limiting the number of databases on an instance.

    You welcome! 🙂

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • RE: Restore Database if Job fails

    Isn't it just a case of adding an On Failure Action in the job and create an additional step in your job to perform the database restore?

    BTW, why not take...

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

Viewing 15 posts - 166 through 180 (of 616 total)